The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,231 other followers

Archive for the ‘ODBC’ Category

ODCB settings in the Windows registry on 32 and 64 bit windows

Posted by jpluimers on 2020/03/27

  • While 32-bit applications can run on 64-bit machines, they cannot use 64-bit ODBC drivers. A 64-bit application must use a 64-bit ODBC driver, and a 32-bit application must use a 32-bit ODBC driver.
  • ODBC.INI registry paths for the various permutations:
    • User DSNs for for 64-bit and 32-bit applications
      • HKEY_CURRENT_USER\Software\ODBC\ODBC.INI
    • System DSNs for 64-bit applications on 64-bit Windows and 32-bit applications on 32-bit Windows
      • HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI 
    • System DSNs for 32-bit applications on 64-bit Windows
      • HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI

Via: [WayBack] Windows registry on 32 and 64 bit windows, which also explains ODBCINST.INI to define drivers.

–jeroen

Posted in Database Development, Development, ODBC, Power User, Windows | Leave a Comment »

Exporting / importing ODBC DSNs (both System and User)

Posted by jpluimers on 2020/01/28

ODBC stores the DSN information in an ODBC.INI tree in the registry.

These posts explain how to export/import individual DSN entries:

–jeroen

Posted in Database Development, Development, ODBC, Power User | Leave a Comment »

 
%d bloggers like this: