ODBC Driver Issue: Progress OpenEdge - error code 193
You are trying to create a 64bit ODBC connection using a 32bit driver and the 32bit driver does not appear in the 32bit ODBC connection manager (SysWOW64)
You need to add the following keys:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
"Progress OpenEdge 10.2A driver"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Progress OpenEdge 10.2A Driver]
"Driver"="[DLC]\\bin\\pgoe1023.dll"
"Setup"="[DLC]\\bin\\pgoe1023.dll"
"DriverODBCVer"="3.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"CPTimeout"="60"
"FileUsage"="0"
"SQLLevel"="0"
"UsageCount"="1"
[DLC] should refer to the 10.2A installation directory
{From ProgressTalk Kbase Solution P141118}
ERROR
System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified
Be sure the ODBC connection is defined as a System DSN and was created using the C:\Windows\SysWow64\ODBCad32.exe
Also be sure that the AppPool running a webservice using the DSN is enabled for 32 bit applications.
No comments:
Post a Comment