lvance1611a

Hey everyone,

I have an ODBC connection to my SQL 2005 database using the Native 2005 driver. When I try to reverse engineer in Visio, I get the following error:

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

I've tried changing the default driver and datasource for the project. I've also searched for updates on MSDN and the Office websites. I'm using SP2 for Visio Professional 2003.

Any suggestions

Thanks,

Lee




Re: Modeling and Tools Reverse Engineer SQL 2005 with Visio 2003 Error

Mauro Regio

Lee,

this is what our Visio engineers explained me...
I'm relaying this to you, hoping you can find one of the options is good for you.

-------------------------------------------------------------------------------------------------------------------

When reverse engineering a database via ODBC, there are two ¡°drivers¡± that come into play. The first is the ODBC driver. The second is the Visio driver which essentially knows how to extract and interpret the schema of the database. Generally speaking, both of those drivers will match. You¡¯ll use the Visio driver for SQL Server to reverse engineer a data source using the SQL Server ODBC driver. What the customer is encountering is that the Visio driver for SQL Server that comes with Visio 2003 Professional doesn¡¯t support SQL Server 2005. It queries the ODBC driver for the database version and displays the error.

There are three (or four :-) ) things that can be done:

1) Use the Visio ODBC Generic driver. This should allow you to reverse engineer the database but it will probably not bring in data that is specific to SQL Server. For example, the data types may not be correct.

2) Use the Visio OLE DB Generic driver, which is listed as ¡°Generic OLE DB Provider.¡± This bypasses ODBC entirely and uses OLE DB to access the database. As with the Generic ODBC driver, this should allow you to reverse engineer the database but some SQL Server-specific data will probably be missing or different.

3) Obtain Visual Studio 2005 which comes with Visio for Enterprise Architects. This is a version of Visio, built on Visio 2003, which comes with an updated SQL Server driver that supports SQL Server 2005. It also has additional functionality that Visio Professional does not have, such as the ability to generate a database from the model.

4) Wait for Visio 2007 Professional, or become part of the Beta program. The updated driver that comes with Visio for Enterprise Architects will be included with Visio 2007 Professional and supports SQL Server 2005.

----------------------------------------------------------------------------------------------------------------

Mauro Regio






Re: Modeling and Tools Reverse Engineer SQL 2005 with Visio 2003 Error

Anonymous

The reverse engineering runs fnie in Visio 2007 andSQL 2005 but it only returns views not tables, although I checked tables - any suggestions

Thanks,





Re: Modeling and Tools Reverse Engineer SQL 2005 with Visio 2003 Error

Rxra

Thanks a lot. it works