Progress Open Edge 11.6.3 ODBC 32 Bit System Error 192

Posted by swatch on 08-Jun-2018 04:40

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

OpenEdge General - Forum

All Replies

Posted by Tinco on 11-Jun-2018 06:18

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

Posted by swatch on 11-Jun-2018 07:39

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

Posted by Tinco on 13-Jun-2018 03:03

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

Posted by swatch on 14-Jun-2018 07:15

Hi,

It´s a wrong ODBC 64bit driver.

Where can I download the 32 Bit ODBC driver?

Thank you for your help

Bernd

 

Posted by Ruben Dröge on 14-Jun-2018 07:21

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

Posted by swatch on 15-Jun-2018 08:33

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

Posted by swatch on 25-Jul-2018 05:45

Hi,

I have now installed a 32 Bit driver. If I test the connection, I get the follow error:

Thank you for your help

Bernd

Posted by swatch on 25-Jul-2018 05:47

This thread is closed