ODBC 32 bit and 64 bit

[dave]

One thing to know is that there is 32 bit and 64 bit version of ODBC drivers. Generally you cannot access a 32 bit data source with a 64 bit ODBC driver.

The 32 bit version of SQL Script Builder can only set and access 32 bit ODBC sources, and 64 bit version of SQL Script Builder can only set and access 64 bit ODBC sources.

That is why there's a 32 bit and a 64 bit ODBC data sources manager on x64 Window OS, the 64 bit version is the default one. To see the 32 bit version on 64 bit Windows use C:\Windows\SYSWOW64\odbcad32.exe (C:\%windir%\syswow64\odbcad32.exe)