Need Visio 2003 drivers for SQL Server 2008 with instructions

Need Visio 2003 drivers for SQL Server 2008 with instructions

Drivers are small software programs, responsible for compatibility with hardware, software and operating system. In case of Visio, the drivers are the communication media between the Visio 2003 and SQL server 2008.

 Basically, Visio 2003 drivers have two drivers:

1. ODBC Driver ( 32-bit ODBC driver)

2. Generic OLE DB Provider Driver

These drivers act as the access point to server Database, which further enables you to perform DBMS-specific Functionality (re-engineer, view and store tables) through your Visio software. These drivers are installed automatically by Visio setup program. The driver works specifically with the Database Model Diagram template and the Microsoft ODBC Data Access Pack.

You can check the drivers installed on your system by navigating the Menu Database>Options>Drivers.

In this case the Visio Database driver should target the SQL server 2008.

As far as your question related to downloading the Visio 2003 drivers, you can opt to use the generic driver, entirely surpassing the ODBC driver, else select the ODBC driver. Following are the steps:

1. Navigate to the Database menu in Microsoft Office Visio, then Options> Drivers.

2. Look for a default driver for Visio, select the driver which would associate with an ODBC driver, and then setup.

3. Select a 32-bit ODBC driver under the ODBC driver tab to associate with the Visio driver you selected. Choose a 32-bit ODBC database driver that supports SQL Server 2008.

4. Click OK to close all open dialog boxes.