Sometimes configuring ODBC gives error code 193 on windows 64 bit. Let’s see how we can fix it. At Bobcares, we can handle your server-related issues with our Server Management Services.

Configuring ODBC gives error code 193 on windows 64 bit – Why?

The setup of OpenEdge 10.2A produces registry entries under the wrong Node. 10.2A includes functionality for 64-bit OpenEdge installations, so the wownode is no longer written to, unlike in 10.1B and 10.1C. The installation creates ODBC driver registry keys in the:

The ODBC driver is not properly created in the wownode as it would be like:

The error message is as follows:

We can resolve this problem if the setup recognizes “if bits=64” and writes to the 64-bit registry or the wownode as necessary. This is possible by upgrading to OpenEdge 10.2B or later.

How to fix the error?

We can use any of the below methods to create the registry keys. We’ve to make sure to keep a backup of the registry before any change.

Method 1

1. 1. On Windows, go to start >> programs >> run >> regedit.exe.
   2. Navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
   3. Choose export by right-clicking on ODBC drivers.
   4. Save in a file xx.reg
   5. Go to [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Progress OpenEdge 10.2A Driver] from regedit again.
   6. Choose export by performing a right-click on Progress OpenEdge 10.2A Driver.
   7. Save in a file yy.reg
   8. Modify yy.reg and add Wow6432Node to the line.

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

      The new line will be:

      [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
   9. Maintain yy.reg.
   10. Utilize the Register Editor’s import feature (File >> import) to import xx.reg.
   11. Utilize the Register Editor’s import feature (File >> import) to import yy.reg.
   12. From this point forward, add or configure your User or System DSN using the 32-bit ODBC Data Source Administrator by running %WINDIR%\SysWow64\odbcad32.exe

Method 2

1. Copy the below contents after creating a .REG file.

   
2. To add the keys to the registry, save the file and double-click on it.

[Need help with another issue? We’re available 24/7.]

Conclusion

The article points out the cause for the error code 193 on windows 64 bit while configuring ODBC. We also provide two methods from our Tech team to fix the issue.