Visio driver is not compatible with the data source

Asked By patricia123 0 points N/A Posted on - 10/08/2011

Hi Tech Guys,

I’m trying to create Microsoft Visio Database Model Diagram and need to do a reverse engineer a Microsoft SQL Server 2008.

While doing Reverse Engineer through the Wizard, Visio asked me for the user credentials. I gave the correct username and password after which I received the following error message:

“The currently selected Visio driver is not compatible with the data source.”

I tried the older version of SQL and reconfigured. I still receive the above error. I’m badly in need of any advice.

 Error: The currently selected Visio driver is not compatible with the data source.

Thanks for your help,

Patricia

• Status: Open
• Question Views: 6511
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by metex

Go To Solution

Best Answer

Best Answer

Answered By metex 5 points N/A #89066

Visio driver is not compatible with the data source

Further investigation reveals that this is an expected behavior for Visio 2007.

When Visio opens a connection using the Visio SQL Server Driver, it checks the server version and since SQL Server 2008 shipped after Visio 2007, it doesn't recognize SQL Server 2008 as a supported version and closes the connection.

You can wait for a future version of Visio to ship which does recognize SQL Server 2008 or use the Visio Generic ODBC driver which can successfully open connections to SQL Server 2008.

A third option is to use a copy of SQL Server 2005 for initial reverse engineering. The Visio team is aware of this issue.

Thank you. Hope it will help you definitely.

About metex

Questions
2

Answers
37

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 10/14/2011
• Question Category: MySQL Server

Answered By Felipa Dolore 20 points N/A #197164

Visio driver is not compatible with the data source

Do this to connect Visio 2007 to a SQL Server 2008 database:

 

1. Run the Reverse Engineer Wizard.

 

 

2. From the Installed Visio Drivers drop-down menu, select the ODBC Generic driver.

 

3. Using the SQL Native Client (2005.90.4035, 2005 SP3), create a new data source.

 

4. Click OK when you get a message saying that some information retrieved may be incomplete.

 

This procedure might also resolve the problem.

About Felipa Dolore

Questions
0

Answers
100

Best Answers
48

• Vote Up 0 Vote Down

• Posted on - 11/27/2013
• Question Category: MySQL Server