I used ODBC with Progress (OE 10.1b It think) back when we were on V8.
Does the ODBC connection setup on the computer pass the connection test?
There’s a chance you might need to run the ODBC32 setup on the client machine, instead of the 64 bit ODBC.
The 32 bit ODBC is at C:\Windows\SysWOW64\odbcad32.exe
There were also some “fixes” that we had to do. It involved creating a few registry entries. Here’s the contents of a REG file we used to run on clients so they could use ODBC connections to the V8 server.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC]
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MC_MfgSys]
"Driver"="\\\\usdataps00108\\progress\\openedge\\bin\\pgoe1022.dll"
"Description"="Live Company"
"HostName"="USDATAPS00108"
"PortNumber"="8350"
"DatabaseName"="mfgsys"
"LogonID"="sysprogress"
"StaticCursorLongColBuffLen"="4096"
"UseWideCharacterTypes"="0"
"EnableTimestampWithTimezone"="1"
"DefaultIsolationLevel"="SQL_TXN_REPEATABLE_READ"
"ArraySize"="50"
"DefaultLongDataBuffLen"="2048"
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"MC_MfgSys"="OpenEdge 10.1B driver"
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
"OpenEdge 10.1B driver"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\OpenEdge 10.1B driver]
"APILevel"="1"
"ConnectFunctions"="YYY"
"CPTimeout"="60"
"Driver"="\\\\usdataps00108\\progress\\openedge\\bin\\pgoe1022.dll"
"DriverODBCVer"="5.1"
"FileUsage"="0"
"Setup"="\\\\usdataps00108\\Progress\\OpenEdge\\bin\\pgoe1022.dll"
"SQLLevel"="1"
"UsageCount"="1"
"WorkArounds2"="40960"
usdataps00108 is the name of the V8 server that Progress resided on.
The “WorkArounds2”=“40960” is the fix we needed to manually enter.
Duplicate the entries in [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MC_MfgSys] with updated name and Port setings for connections to other DB’s. For example:
[HKEY…ODBC.INI\MC_PilotComp]
“Description”=“Pilot Company”
“PortNumber”=“8380”
all other entries are the same as those in [HKEY…MC_MfgSys]
and add "MC_PilotComp"="OpenEdge 10.1B driver"
to the [HKEY...\ODBC Data Sources] section