Connecting to SQL Server 2005

P

Paul Nuttall

I can not connect to any SQL Server 2005 systems using Visio 2003.
I used to have SQL 2000 installed on my system and now i have SQL 2005.
I used to be able to set up a DSN to my SQL Server and reverse engineer the
database. Now I can't

Anyone know why? How I get around this?
 
A

Al Edlund

I just tried it on mine (first I went through and validated the odbc
definitions and verified that the test worked over there) and was able to
connect and reverse engineer using the Visio EA 2003.
al
 
P

Paul Nuttall

What settings are you using when you set up your DSN via Windows?
What settings are you using in Visio?
When you say ODBC do you mean that you are using the Generic ODBC driver?
 
A

Al Edlund

I'm using the sql odbc driver, control panel => administrative tools =>
odbc sources => system dsn => add => sql server, and then fill in the
blanks....

al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export data from a VISIO ER diagram to SQL server 1
how to generate a database diagram from existing database 0
Connect to SQL Server 2005 2
Reverse Engineering SQL Server 2005 database using Visio 2003 3
SQL server 2005 1
Org Chart Wizard Automation in Visio 2003 with SQL Server 2
Can't send emails but can receive in Outlook 2019 1
Table Security in Access 2013 1

Top