Visio doesn't reverse engineer SQL2005?

[Paul Ritchie]

I have tried to import table and view definitions using the reverse engineering
wizard in Visio 2003 and Visio 2005 from my SQL 2005 database however neither
views nor tables appear in the lists returned.

Where do I start to try and fix this - unfortunately I am bewildered!

Is there a known problem with the SQL 2005 interface?

cheers,
Paul

 

[Barb Way]

I'm not quite sure what 'Visio 2005' means. Visio Professional is
available in a Visio 2003 release, and there is the more recent Visio 2007
release. In addition, there is a version of Visio, based on the Visio 2003
release, that is bundled into Visual Studio 2005 - which displays in Help >
About as "Visio for Enterprise Architects".

The database drivers for SQL 2005 are available in Visio 2007 Professional,
and in Visio for Enterprise Architects / VS 2005 version. These updated
drivers allow the Visio database modeling solution to understand the most
recent version of SQL, and should work just as well as SQL 2000 drivers.

If you are using one of these versions, and are having database modeling
issues, you might try repairing Visio to ensure that the install is not
broken. If you can connect to your SQL 2005 server from another data app
(such as Access or Excel), and Visio is otherwise working fine, then you
can also contact support for further troubleshooting.

Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.