Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have upgraded to SQL 2012 and Am trying to reverse engineer our Dbs into Visio 2010. I setup a connecting using SQL 11 driver and Visio complains that that driver is not supported.

Any one run into this?

share|improve this question
Here is another post with a similar question. Since SQL Server 2012 came out after Visio 2010 it is not supported, even though it uses the Native Client. – grid Oct 4 '12 at 19:17
Funny, ironic and sad (some things never change, do they):… – Magnus Oct 4 '12 at 21:31

The Generic OleDB Driver also works for reverse engineering a SQL Server 2012 database using Visio 2010.

(Might not be "supported", but this works). Select the Generic OLE DB Provider from the list of Installed Visio drivers and click Next. Then pick the Microsoft OLD DB Provider for SQL Server and then go to the Connection tab.

  1. Enter in your server name,
  2. choose the authentication method,
  3. Select the database name from dropdown (or build from file) and click the Test Connection button.

I didn't need to do anything with the Advanced or All tabs after the connection succeeded, just clicked OK and was able to pick the object types and list of objects and it exported everything to the diagram.

share|improve this answer
That's an interesting workaround and an approach that works. – Mike Walsh Nov 27 '12 at 2:19
Can you give any more details on how to go about that? (hint: it'll give you a fair number more rep ;-) ) – jcolebrand Nov 27 '12 at 3:18
Pretty crappy answer considering you didn't indicate how to get this driver. Vote down. – Craig May 5 '15 at 19:16

I cannot test it from here, but I would try using the SQL 10 driver if you can. They usually have high level of compatibility across versions.

Or else try using the Generic ODBC driver. That almost always works, though you don't always get as much with it.

share|improve this answer
I have had luck with the ODBC drivers before as well.. however you don't get access to some of the Binary data types such as XML, Geography etc – JasonHorner Oct 4 '12 at 21:04

What you need is "Microsoft® ODBC Driver 11 for SQL Server® - Windows" which can be downloaded from:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.