AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Windows 7 odbc manager1/1/2023 ![]() ![]() System DSNs will only be seen by the applications and tools which can use them - 32-bit DSNs for 32-bit applications, and 64-bit DSNs for 64-bit applications.įor this reason among others, we strongly advise using only System DSNs in 64-bit environments. #WINDOWS 7 ODBC MANAGER DRIVERS#Likewise, the 64-bit Administrator, and all 64-bit ODBC applications (typically installed to %systemdrive%/Program Files/), will list 32-bit User DSNs (that is, DSNs based on 32-bit ODBC drivers) - even though these DSNs and drivers cannot be used by the 64-bit tools/applications. ![]() Note that the 32-bit Administrator, and all 32-bit ODBC applications (typically installed to %systemdrive%/Program Files (x86)/), will list 64-bit User DSNs (that is, DSNs based on 64-bit ODBC drivers) - even though these DSNs and drivers cannot be used by the 32-bit tools/applications. Start -> Control Panels -> Data Sources (ODBC) (The 64-bit ODBC Administrator can also be accessed through the Control Panels interface, as the Data Sources (ODBC) control panel.) Typical Paths to ODBC Administrators This controls 64-bit ODBC drivers, which are required by 64-bit client applications. (The 32-bit ODBC Administrator cannot be accessed through the Control Panels interface the Data Sources (ODBC) control panel is the 64-bit ODBC Administrator.)Ĭounterintuitively, the 64-bit ODBC Administrator is found at %systemdrive%/Windows/System32/odbcad32.exe. This controls 32-bit ODBC drivers, which are required by 32-bit client applications. ![]() The 32-bit ODBC Administrator is found at %systemdrive%/Windows/ SysWoW64/odbcad32.exe. They are differentiated by their filesystem location. Many 64-bit environments still support 32-bit applications, and these require 32-bit ODBC drivers and DSNs, so it's important to understand how this all works.īoth the 32-bit and 64-bit ODBC Administrator are named odbcad32.exe. #WINDOWS 7 ODBC MANAGER WINDOWS#Using ODBC (32-bit and 64-bit) on 64-bit WindowsĦ4-bit Windows has some surprising and counterintuitive setup and behavior around 32-bit and 64-bit ODBC. ![]()
0 Comments
Read More
Leave a Reply. |