ODBC not working / cant find 32 bit ODBC driver

odbc
sql
Tags: #<Tag:0x00007f60c67c6810> #<Tag:0x00007f60c67c6400>

#1

After installing a SQL server (not just MSFT SQL Server, but any SQL server product), you might find that you can’t access the database from Clarion apps, or that you can’t see the ODBC drivers.

This can be because there are TWO ODBC administrator exes in Windows: a 32 bit one and a 64 bit one. The 64 bit ODBC administrator exe only displays 64 bit drivers. The 32 bit ODBC administrator exe only displays 32 bit drivers (the ones you want for Clarion).

Note: Clarion apps can access 64 bit database servers, but they need a 32 bit ODBC driver to do so.

The most fun about this situation is that the 64 bit ODBC administrator exe and the 32 bit ODBC administrator exe have the SAME FILE NAME. Stupid, right?

The 64 bit one lives in \windows\system32.
The 32 bit one lives in \windows\Syswow64.