Kbase P14427: How to configure an SQL-92 ODBC driver for a remote Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to configure an SQL-92 ODBC driver for a remote Progress database
GOAL:
How to connect to a Progress database using ODBC SQL-92
GOAL:
Quick SQL-92 ODBC configuration guide
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
DataDirect 4.20 32-Bit OpenEdge SQL92 10.0A
FIX:
The basic steps are as follows:
1. Start the database thus: proserve <database> -S <portnumber>
2. Open the ODBC Data Source Administrator
3. Click System DSN
4. Click Add
5. Select your driver (e.g. MERANT 3.6 32-bit Progress SQL-92 )
6. Click Finish and the Driver Setup window appears
7. Enter a name of your choice for the Data Source name
8. Enter the hostname of the database machine
9. Enter the port number you used with -S
10. Enter the database name
11. Enter your user name if security is defined for the database, if not you can leave this blank
12. Click Test Connect
13. The logon window appears
14. Again you are prompted for a user:
If you have security defined on the database enter your login and password. If you have no security defined then you can enter random characters in the User ID box but you can leave the password blank.
15. Click OK
You should see a dialog box saying 'Connection Established'.
16. Click Apply to save the Data Source
Your driver is now configured and you can access the database with your 3rd party product.
Example using WinSQL:
1. Start WinSQL
2. The Data Source dialog box appears
3. Select the Data Source from the dropdown list
4. If no security is defined on the database you can leave the password blank, otherwise enter your User ID and password
5. Click OK
You can now run queries.