Connect Visio 2007 to any SQL Server Version after SQL Server 2005

• Download source - 296.7 KB

Introduction

There is an immense need to do reverse engineering of some data tables and generate a relationship snap between them. Visio gives a powerful functionality of connecting to underlying DB and getting a relationship snap.

When you try to connect Visio 2007 with SQL Server 2008 R2 or any version above SQL Server 2005 with SQL Server driver, it gives an incompatibility warning.

How to Connect Visio 2007 to SQL Server 2008 R2

There is a way round to perform the task.

1. Select the 'Generic OLEDB Provider' for Installed Visio driver option.
2. Click on the next button and select 'Microsoft OLEDB Provider for SQL Server' as an option for Data Link Properties window.
3. Click Next and provide the credentials, and list the database.
4. Select the db objects and click ok.