Kbase P169801: Error "The specified DSN contains an architecture mismatch between the Driver and Application" when
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/14/2010 |
|
Status: Unverified
SYMPTOM(s):
Error "The specified DSN contains an architecture mismatch between the Driver and Application" when connecting via DataServer for MS SQL Server
Error "The specified DSN contains an architecture mismatch between the Driver and Application" when attempting a schema pull via DataServer for MS SQL Server
Could not connect to "<database>" as "<user>"
IM014: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
FACT(s) (Environment):
Using the SQL Server ODBC driver
OpenEdge version used is 32-bit
Windows operating system is 64-bit
OpenEdge 10.2x
Windows
CAUSE:
ODBC DSN has been created using %WINDIR%\System32\odbcad32.exe so the ODBC driver used in the DSN is 64-bit. The 32-bit Progress client cannot access the 64-bit ODBC driver.
FIX:
Recreate the ODBC DSN using %WINDIR%\SysWow64\odbcad32.exe.
The version of odbcad32.exe in %WINDIR%\SysWow64 is 32-bit and accesses 32-bit ODBC drivers.