Kbase 44427: How to configure an SQL-92 driver for a remote Progress database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/22/2001 |
|
Solution ID: P14427
GOAL:
How to configure an SQL-92 driver for a remote Progress database
GOAL:
Quick SQL-92 ODBC configuration guide
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 v9.1D)
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.
E.g. 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.