Progress Open Edge 11.6.3 ODBC 32 Bit System Error 192 - Forum - OpenEdge General - Progress Community

Progress Open Edge 11.6.3 ODBC 32 Bit System Error 192

 Forum

Progress Open Edge 11.6.3 ODBC 32 Bit System Error 192

This question is not answered

Dear all,

my progress on server 2012R2 was update from 10.2b 32 bit to 11.6.3 64 bit.

By this installation the 32 bit ODBC driver is delete and the 64 bit install.

But I have a program that need the 32 Bit ODBC. So  I install and config it, and it run.

After update windows and restart, there was no ODBC connection.

If I want look to the 32 bit ODBC config I get a System Error 192.

After read some article  I delete the some entries in the registry under ODBC 32 bit and reinstall the driver.

But if I want add a new connection with ODBC 32 bit admin console, I found the progress 11.6 entry and get then the System Error 192 again.

I send my actual ODBC registry and the error message

.

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\DEFAULT]
"HostName"="localhost"
"PortNumber"="10035"
"Database"="dpw_data"
"UserID"="sysprogress"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"saperion"="SQL Server"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\saperion]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Description"="Saperion"
"Server"="SGRATWI005"
"LastUser"="saperiondb75"
"Database"="Saperion75"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Conversor de pagina de codigo MS]
"Translator"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,\
  00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,\
  58,00,4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,58,00,\
  4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Driver da Microsoft para arquivos texto (*.txt; *.csv)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,74,00,65,00,78,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Driver do Microsoft Access (*.mdb)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="2"
"FileExtns"="*.mdb"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Driver do Microsoft dBase (*.dbf)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,64,00,62,00,73,00,\
  65,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Driver do Microsoft Excel(*.xls)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,65,00,78,00,6c,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.xls"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Driver do Microsoft Paradox (*.db )]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,70,00,64,00,78,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.db"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)]
"UsageCount"=dword:00000003
"Driver"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODDBS.DLL"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.dbf, *.ndx, *.mdx"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="2"
"FileExtns"="*.mdb"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access Driver (*.mdb, *.accdb)]
"UsageCount"=dword:00000003
"Driver"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODBC.DLL"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb,*.accdb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access Text Driver (*.txt, *.csv)]
"UsageCount"=dword:00000003
"Driver"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODTXT.DLL"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.txt, *.csv"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Access-Treiber (*.mdb)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="2"
"FileExtns"="*.mdb"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft dBase Driver (*.dbf)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,64,00,62,00,73,00,\
  65,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft dBase-Treiber (*.dbf)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,64,00,62,00,73,00,\
  65,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Excel Driver (*.xls)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,65,00,78,00,6c,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.xls"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)]
"UsageCount"=dword:00000003
"Driver"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODBC.DLL"
"Setup"="C:\\PROGRA~2\\COMMON~1\\MICROS~1\\OFFICE14\\ACEODEXL.DLL"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.xls,*.xlsx, *.xlsb"
"SQLLevel"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Excel-Treiber (*.xls)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,65,00,78,00,6c,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.xls"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft ODBC for Oracle]
"CPTimeout"="120"
"SQLLevel"="1"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYY"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6d,00,73,00,6f,00,72,00,63,00,\
  6c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6d,00,73,00,6f,00,72,00,63,00,\
  6c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Paradox Driver (*.db )]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,70,00,64,00,78,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.db"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Paradox-Treiber (*.db )]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,70,00,64,00,78,00,\
  33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.db"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Text Driver (*.txt; *.csv)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,74,00,65,00,78,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Microsoft Text-Treiber (*.txt; *.csv)]
"SQLLevel"="0"
"DriverODBCVer"="02.50"
"APILevel"="1"
"ConnectFunctions"="YYN"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,74,00,65,00,78,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,6f,00,64,00,62,00,63,00,6a,00,\
  74,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MS Code Page Translator]
"Translator"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,\
  00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,\
  58,00,4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,58,00,\
  4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\MS Code Page-Ubersetzer]
"Translator"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,\
  00,79,00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,\
  58,00,4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,4d,00,53,00,43,00,50,00,58,00,\
  4c,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Core]
"UsageCount"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
"Microsoft Access-Treiber (*.mdb)"="Installed"
"Driver do Microsoft Paradox (*.db )"="Installed"
"Driver do Microsoft Excel(*.xls)"="Installed"
"Microsoft Text Driver (*.txt; *.csv)"="Installed"
"Driver da Microsoft para arquivos texto (*.txt; *.csv)"="Installed"
"Microsoft dBase-Treiber (*.dbf)"="Installed"
"SQL Server"="Installed"
"Microsoft Excel Driver (*.xls)"="Installed"
"Driver do Microsoft dBase (*.dbf)"="Installed"
"Microsoft Paradox-Treiber (*.db )"="Installed"
"Microsoft ODBC for Oracle"="Installed"
"Microsoft Text-Treiber (*.txt; *.csv)"="Installed"
"Microsoft Excel-Treiber (*.xls)"="Installed"
"Microsoft Access Driver (*.mdb)"="Installed"
"Driver do Microsoft Access (*.mdb)"="Installed"
"Microsoft Paradox Driver (*.db )"="Installed"
"Microsoft dBase Driver (*.dbf)"="Installed"
"Microsoft Access Driver (*.mdb, *.accdb)"="Installed"
"Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)"="Installed"
"Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)"="Installed"
"Microsoft Access Text Driver (*.txt, *.csv)"="Installed"
"Progress OpenEdge 11.6 Driver"="Installed"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Translators]
"MS Code Page Translator"="Installed"
"MS Code Page-Ubersetzer"="Installed"
"Conversor de pagina de codigo MS"="Installed"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Progress OpenEdge 11.6 Driver]
"Driver"="D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge\\pgoe27.dll"
"Setup"="D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge\\pgoe27.dll"
"DriverODBCVer"="3.52"
"APILevel"="1"
"ConnectFunctions"="YYN"
"CPTimeout"="60"
"FileUsage"="0"
"SQLLevel"="0"
"UsageCount"="1"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\SQL Server]
"CPTimeout"="60"
"SQLLevel"="1"
"DriverODBCVer"="03.50"
"APILevel"="2"
"ConnectFunctions"="YYY"
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,73,00,71,00,6c,00,73,00,72,00,\
  76,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
  00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,53,00,51,00,4c,00,53,00,52,00,\
  56,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"FileUsage"="0"

Thank you for your help

Bernd

All Replies
  • Hi Bernd,

    On the screenshot I can see that the dpw_data System DSN is for the 64 bit version of the OpenEdge 11.6 ODBC driver.

    The registry key:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Progress OpenEdge 11.6 Driver]

    "Driver"="D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge\\pgoe27.dll"

    "Setup"="D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge\\pgoe27.dll"

    "DriverODBCVer"="3.52"

    "APILevel"="1"

    "ConnectFunctions"="YYN"

    "CPTimeout"="60"

    "FileUsage"="0"

    "SQLLevel"="0"

    "UsageCount"="1"

    however show a 32 bit OpenEdge ODBC driver entry.

    Is the OpenEdge installation on

    D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge

    a 32 bit installation?

    Also I would have expected the file pgoe27.dll to be within a bin directory, something like:

    D:\\Appl\\Appl\\DPW\\Progress\\OpenEdge\\bin\\pgoe27.dll

    which 32 bit OpenEdge product was installed to provide the 32 bit version of pgoe27.dll on the Windows machine?

    The received Microsoft error 193 is described on:

    knowledgebase.progress.com/.../The-setup-routines-for-the-Progress-OpenEdge-10-x-Driver-ODBC-driver-could-not-be-loaded-due-to-system-error-code-193

    This error 193 is either caused by a 32 bit program trying to use a 64 bit driver or a 64 bit program trying to use a 32 bit ODBC driver  

    Kind regards,

    Tinco

  • Hi,

    thanks for your answer.

    I have get the ODBC 32 bit install file from an external technician, which update to 11.6.2 64 bit.

    I have install it in folder D:\Appl\Appl\DPW\Progress\OpenEdge\

    I hope, it’s the right file and directory.

    The version of the driver install file is:

    The version D:\Appl\Appl\DPW\Progress\OpenEdge\pgoe27.dll is:

     

    The version D:\Appl\Appl\DPW\Progress\OpenEdge\bin\pgoe27.dll is:

    What I wonder is, that the 32 bit and the 64 bit ODBC have the same directory and I can open the config from the 64Bit odbc.

     

    Thank you for your help

    Bernd

  • You are welcome Bernd,

    If you download the sigcheck utility from

    docs.microsoft.com/.../sigcheck

    and do a

    sigcheck64.exe D:\Appl\Appl\DPW\Progress\OpenEdge\pgoe27.dll

    do you get something like:

           Description:    Progress Software Corporation OpenEdge ODBC Driver

           Product:        ODBC Pack

           Prod version:   07.16.0175

           File version:   07.16.0175 (B0296, U0197)

           MachineType:    64-bit  <-----

    or something like:

           Description:    Progress Software Corporation OpenEdge ODBC Driver

           Product:        ODBC Pack

           Prod version:   07.16.0175

           File version:   07.16.0175 (B0296, U0197)

           MachineType:    32-bit  <-----

    ?

    If you do receive "MachineType:    32-bit" you could then try the ODBC connection using the 32 bit powershell as I described on:

    knowledgebase.progress.com/.../how-to-test-an-odbc-connection-dsn-on-windows-using-powershell

    to see if the 32 bit ODBC connection works file outside of your 32 bit application.

    If the 32 bit ODBC connection does not work through a 32 bit powershell connection then you might want to open a Supportcase to further investigate the issue.

    Kind regards,

    Tinco

  • Hi,

    It´s a wrong ODBC 64bit driver.

    Where can I download the 32 Bit ODBC driver?

    Thank you for your help

    Bernd

     

  • Via Progress ESD (www.progress.com/esd) and then look for the SQL Client Access Product and select the 32-bit version.

  • Hi,

    if I want download, I get follow message:

    You lack access rights for: Electronic Software Distribution.

    I have a licence paper with 11.6 64bit

    How can I get the rights for ODBC 32 bit?

    Thank you for your help

    Bernd