Kbase P162301: Errors 'Data source name found and no default driver specified' when 64 bit ODBC Data Administrator
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2011 |
|
Status: Unverified
SYMPTOM(s):
Errors 'Data source name found and no default driver specified' when 64 bit ODBC Data Administrator is used in with 32 bit Progress
IM002:[Microsoft][ODBC Driver Manager] Data source name found and no default driver specified
Failed to connect to the MSS database (6142)
Errors appear using system DSN
Errors appear with using unified brokers
FACT(s) (Environment):
MS SQL DataServer
Progress 9.1x
OpenEdge 10.x
Windows
CAUSE:
The ODBC administrator is 64 bit but progress product is 32 bit, 32 bit process can not see 64 bit ODBC DSN
FIX:
Use 32 bit ODBC administrator to configure a System DSN by running the the following from Start > Run of by going to the directory and double clicking on the executable:
C:\windows\syswow64\odbcad32.exe