Tuesday, September 21, 2010

Windows 7 - Enabling Microsoft dBase Driver as Data Sources (ODBC)

In windows 7 you can only find the SQL Driver and none of the other drivers are listed. You would need to set the target to point to the 32-bit ODBC exe to find the other Data Sources to be listed:

1) Click on Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
2) Right-click on properties and select the target as "%windir%\syswow64\odbcad32.exe".
3) In the User DSN tab, click on Add...
4) In the screen that follows, select Microsoft dBase Driver (*.dbf)
5) Click Finish.

4 comments: