Kbase P6260: Unable to establish connection via System DSN for ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2006 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
Windows 32 Intel
SYMPTOM(s):
Unable to establish connection via System DSN.
MERANT: Invalid attribute in connection string: description MERANT ODBC Progress driver Progress
[DataDirect][ODBC PROGRESS driver]Invalid attribute in connection string.
Error in Network Daemon
[DataDirect][ODBC PROGRESS driver]Error in Network Daemon.
System Data Source Name fail
User Data Source Name works fine
Used service name in ODBC DSN to connect to database
No mapping in services file for service name to port number
CAUSE:
ODBC DSN could not find mapping between port number and service name, thus could not connect to the correct port
FIX:
Use port number instead of service name, or add service name to port number mapping in services file