Reverse Engineering SQL Server 2005 database using Visio 2003

[WhyDoIneedAHandle]

Trying to reverse engineer SQL Server 2005 database using Visio Professional
2003. It works with the generic ODBC driver, but then all my data types
don't match up.

In the Reverse Engineering Wizard, Selecting Microsoft SQL Server from
Installed Visio drivers, and clicking New... It takes me through all the
wizardly steps of setting up the DSN no problem, but when I finish up and
return to the Reverse Engineer Wizard the data source I just defined isn't
there to pick! A real catch-22.

Is there any way to reverse engineer a SQL 2005 database and get the right
data types? I can get the latest Vision through the corporate help desk but
that's going to take time (that I really don't have)...

Thanks in advance

 

[WhyDoIneedAHandle]

Update:
Installed Visio 2007 and am able to reverse engineer SQL server 2005 OK.

I am, however, extremely surprised by Visio 2007. It is exactly, completely
the same as Visio 2003. Where is all the new cool Office features and look?
The only improvement I can see is that the list view backgrounds are
gradients. Sure glad I didn't spend my own money for the upgrade or I would
be very, very unhappy!!

 

[David Parker]

The big new things in Visio 2007 Professional are Link Data to Shapes, Data
Graphics and PivotDiagrams ...
I can't think of any good reason to "upgrade" to Visio 2007 Standard!!

 

[WhyDoIneedAHandle]

Thanks David. I did run it all day without it crashing even once, or
refusing to exit. THAT alone is worth the price of the upgrade....