Open DataBase Connectivity (ODBC)

Microsoft Open DataBase Connectivity (ODBC) is a standard application programming interface for connecting client applications to Windows-based database management systems.

  1. 64-bit versions of Windows maintain two sets of the System Data Source collection; one for 64-bit (“C:WindowsSystem32odbcad32.exe”) applications and one for 32-bit (“C:WindowsSysWOW64odbcad32.exe”) applications.
  2. To create a System Data Source that is accessible to both 64-bit and 32-bit applications, you must run a copy of the 32-bit ODBC Administrator (located in the WINDOWSSysWOW64 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source.
  3. Typical ODBC.INI file location is “C:WindowsODBC.INI”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.