Saturday, 28 December 2013

Microsoft Office ODBC Drivers DriverID registry values

Microsoft Office ODBC drivers all share a common dll for their various functions.

The DriverID field that is stored in the registry in the following location determiners which ODBC driver is used within that library file.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

I've started to put together a list of the various driver names as they are seen in the ODBC data sources tool (odbcad32.exe) and the corresponding driver ID

Platform
Driver ID
Application
32-bit
25
Microsoft Access-Treiber (*.mdb)
32-bit
25
Microsoft Access Driver (*.mdb)
32-bit
25
Driver do Microsoft Access (*.mdb)
32-bit
27
Microsoft Text Driver (*.txt; *.csv)
32-bit
27
Microsoft Text-Treiber (*.txt; *.csv)
32-bit
790
Microsoft Excel Driver (*.xls)
32-bit
790
Driver do Microsoft Excel(*.xls)
32-bit
533
Microsoft dBase Driver (*.dbf)
32-bit
533
Microsoft dBase-Treiber (*.dbf)
64-bit
25
Microsoft Access Driver (*.mdb, *.accdb)
64-bit
27
Microsoft Access Text Driver (*.txt, *.csv)
64-bit
1024
Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)

If you're looking to document the ODBC configuration on your network machines take a look at our Server Documentation Tool.

1 comment:

  1. If I've missed any of the ODBC drivers please let me know. It's interesting that the only driver that changes between 32bit and 64bit is the Excel driver....

    ReplyDelete