Kbase P86521: Steps to configure and test a ODBC Data Source with the MERANT 3.60 SQL92 driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/9/2009 |
|
Status: Verified
GOAL:
Steps to configure and test a ODBC Data Source with the MERANT 3.60 SQL92 driver
FACT(s) (Environment):
Progress 9.1D
Windows NT 32 Intel/Windows 2000
FIX:
1. Make sure TCP/IP networking is configured properly on the test machine
2. Start the Progress database using a free service port
Example: proserve sports -S 7777
and check in the database log file if that service port is taken as service.
3. Create a user account "pub" with the Progress Data Administration tool
4. In the ODBC Data Source Administrator for the ODBC Progress SQL92 Driver Setup
specify as:
-Host Name the IP address of your test machine
-Port Number the port number for which you started the database example 7777
-Database Name the name of the database without any path or extension
example: sport
-User ID : pub
5. Click on the "Test Connect" button and specify as password what you assigned
to the pub user account with the Progress Data Administration tool.