Viewing the Available ODBC Drivers

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  SPS File and Databases > Connecting to a Database > Setting up an ODBC Connection >

Viewing the Available ODBC Drivers

You can view the ODBC drivers available on your operating system in the ODBC Data Source Administrator. You can access the ODBC Data Source Administrator (Odbcad32.exe) from the Windows Control Panel, under Administrative Tools. On 64-bit operating systems, there are two versions of this executable:

 

The 32-bit version of the Odbcad32.exe file is located in the C:\Windows\SysWoW64 directory (assuming that C: is your system drive).
The 64-bit version of the Odbcad32.exe file is located in the C:\Windows\System32 directory.

 

Any installed 32-bit database drivers are visible in the 32-bit version of ODBC Data Source Administrator, while 64-bit drivers—in the 64-bit version. Therefore, ensure that you check the database drivers from the relevant version of ODBC Data Source Administrator.

WinODBCDrivers

ODBC Data Source Administrator

If the driver to your target database does not exist in the list, or if you want to add an alternative driver, you will need to download it from the database vendor (see Database Drivers Overview ). Once the ODBC driver is available on your system, you are ready to create ODBC connections with it (see Setting up an ODBC Connection ).


© 2019 Altova GmbH