Connect to SQL Server 2005

[REK]

I'm using Visio 2003 Pro. When I use the SQL Server driver, or the native
client driver, via a DSN to connect to my DB is get "The currently selected
Viso driver is not compatible with the data source" as an error.

In Database>Options>Drivers I'm set to MS SQL Server, SQL Native Client
isn't available here. DSN is set to the same and I still get the error as
above. "Test Connection" in the DSN works.

The Generic ODBC driver works, but I get a message that says "...the DDL
script generated or the update of the database wil be incompatible...".

Is it possible to connect to SQL Server 2005 with Visio 2003 Pro? If so,
what driver should I use (hopefully to have full compatibility)?

 

[Rob]

I'm in the same position, did you ever get to the bottom of the problem.

 

[REK]

No, I didn't. Frustrating. I ended up just working with the ODBC driver as
ultimately I didn't need to worry about the generated script, I was just
mapping an existing schema to share with others and breaking it up into
functional groupings much like can be done with DB Diagrams.

Rick