ODBC 64 bit error 193

Question

ODBC 64 bit error 193

D Bo 6

Hi all,

I was trying to create a connection for SQLite. I use a 64 bit version for this. It worked perfectly fine. However, I have upgraded from Home to Windows 11 Pro and now not one ODBC connection works anymore. I get the following error:

The setup routines for the SQLite3 ODBC Driver ODBC driver could not be loaded due to system error code 193: .

It seems to happen on every connection that I try to create.

I know there there are two ODBC Administrator toosl for 32 and 64 bit. I am able to install the 32 bit and create the connection. However, I can't use this connection with Power BI, because that is 64 bit. So I think the 64 bit ODBC tool seems to be corrupted.

Any help is appreciated, because I am running out of options.

Thanks in advance!

0 comments

4 answers

Your answer

Answer 1

oscarrudnas 20

I had the same issue and tried multiple times to install / uninstall. I finally managed to get it working by installing both versions (32 bit / 64 bit) of the ODBC connector (in my case Simba Athena) I then set all the odbc settings in the 32 bit version. I then opened regedit and exported (File-> export) the 32 bit version settings to the desktop (Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\Simba Athena) I opened the file in text editor and changed the location from above to this [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Simba Athena] I then import (File-> import) the settings in regedit. By doing this, the settings are imported from the 32 bit to the 64 bit and got everything working in 64 bit. Hope this is helpful :)

Pilares_Frank 0 Reputation points

2024-10-12T12:53:01.69+00:00

This workaround worked for me on a Apple M3 Pro machine with a Parallels VM with Windows Pro installed.

thank you. Much appreciated that you shared this.

Microsoft please fix this by default.
Anthony k 0 Reputation points

2024-12-16T10:42:25+00:00

@Pilares_Frank how did you do it for the Apple M3 with Parallels VM in Windows? Which drivers for ODBC are you using? How did you set it up? I am stuck similarly but with ODBC drivers for InterBase.
Pilares 0 Reputation points

2024-12-16T11:29:21.86+00:00

I've followed the instructions as supplied by "oscarrudnas". So, you should install both the 32 and 64 bits ODBC drivers, in your case of Interbase. Set-up a DSN with the 32-bits version of the ODBC Administrator and then use the Registry editor to copy (export, change the *.reg file, import) the ODBC settings.
John Alden 0 Reputation points

2025-03-03T05:03:22.34+00:00

@Pilares_Frank I'm stuck in a similar situation with Parallels and a Windows 11 VM.

So, you should install both the 32 and 64 bits ODBC drivers

How did you install the 32-bit driver? I get an error saying it can't install on a 64-bit OS.
Alexia Perry 0 Reputation points

2025-06-19T14:54:41.6633333+00:00

This helped me solve my issue, so thank you so much!!

I still had to manually add another registry key in addition to what oscarrudnas mentioned above, so wanted to share as it took me hours to finally find the solution. After you follow oscarrudnas steps above, navigate to:

Right click on ODBC Data Sources and click New and choose String Value. The value name should be your datasource name you created in 32 bit and the value will be your driver name. (For reference, I am using SAP Business One on HANA, so my value was HDBODBC). That was it!

This didn't fix the issue. We're searching for ODBC only shows the 32 pit version (which still opens the 64-bit ODBC Administrator), but I was able to work around it by launching the correct version directly from the file path below:
Pilares 0 Reputation points

2025-06-20T07:08:06.7166667+00:00

Good to hear that the workaround worked for you

Answer 2

Hello,

Regarding to your description, seems the installation of the driver mis-registered a 64 bit driver but it is a 32 bit or vise-versa version. As the ODBC driver listing is determined by registry keys that are set on installation of the driver, it is likely that the driver installer has a fault which is causing it to be mis-registered with ODBC.

Please try to load either a 32 bit driver from the 64 bit version (C:\windows\system32\odbcad32.exe) or trying to load a 64 bit driver from the 32 bit version (C:\windows\syswow64\odbcad32.exe).

Additional if you build and then run an application as a 32-bit application on a 64-bit operating system, the workaround is try to create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs.

More information, please refer to: The 32-bit version of the ODBC Administrator tool and the 64-bit version of the ODBC Administrator tool display both the 32-bit user DSNs and the 64-bit user DSNs in a 64-bit version of the Windows operating system
Reference: https://learn.microsoft.com/en-US/troubleshoot/sql/connect/odbc-tool-displays-32-bit-64-bit

---------------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--

Answer 3

D Bo 6

Yes, I've tried multiple times. Still the same error I mentioned.

I can see the SQLite drivers, but if I want to remove it or create the connection, I get the error.

0 comments

Answer 4

Castorix31 91,871

Did you try to install the 64-bit driver (sqliteodbc_w64.exe. from sqliteodbc) ?

0 comments

Share via

ODBC 64 bit error 193

4 answers

Your answer