Kbase P38148: When using connect statement get ODBC error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/06/2004 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
When using connect statement get ODBC error
ERROR:IM002: [Microsoft][ODBC Driver Manager] Data source name not found. DSN not specified. Failed to connect to the database.
Connection to schema holder and then connect to the foreign database using the prompt works fine.
The second database name is not the same as the ODBC data source name
CAUSE:
When connecting to the schema holder and the foreign database through the ODBC driver, use the following format of connection parameter:
connect -db <schema holder name> -RO -db <ODBC DSN name> -dt ODBC -ld <logical name provided in the schema holder> -U <user name -P <password>
In the above connection parameters, the schema holder is local to the progress client and no ODBC DataServer broker is running. If used native driver to the foreign database is running, the user name and password may not be necessary.
The error is apparent when the -db parameter name is not the same as the ODBC data source name (DSN). The error is exactly what it says in this case.
FIX:
Replace the foreign database name, i.e., the second -db parameter in the above connection parameter with the ODBC DSN.