How to Update Your ODBC SQL Driver

by TS Jordan

The open database connectivity (ODBC) structured query language (SQL) driver is the file that enables your computer to connect with, and talk to, all types of servers and database programs. Updating your ODBC SQL driver is necessary when the new version contains bug fixes for your product or when your old driver has started to show signs of corruption.

1

Navigate to the Microsoft website and download the latest Microsoft data access center (MDAC) program. ODBC drivers can only be installed as part of a MDAC configuration.

2

Save the file to your desktop.

3

Double click on the downloaded file and click on the "Install" button.

4

Click on the location of your hard drive containing the new ODBC SQL driver when prompted during the installation.

5

Reboot your computer when the autoinstaller completes.

Items you will need

About the Author

TS Jordan is an Ohio licensed attorney living and practicing out of the Cleveland area. In addition to his Juris Doctorate, he holds a Bachelors' Degree in Information Systems. He has been writing professionally for less than a year.