Connecting to MS SQL 2005 SQLEXPRESS

jdubois · Post by **jdubois** » Sat 05 Jan 2008 05:37

I am using version 4.3 of the SDAC component. On a PC running Windows XP Pro, I can connect to my SQL 2000 database just fine. The same application running on a Windows Vista Home Premium runing the MSSQL 2005 SQLExpress cannot connect (or find?) the database. The same application running on the Vista PC also cannot connect to the SQL 2000 database accross the network either.

yeohray · Post by **yeohray** » Mon 07 Jan 2008 08:21

I would suggest installing Query Analyzer/Management Studio to confirm that there are no network issues in connecting to the SQL Server instances first.

jdubois · Post by **jdubois** » Mon 07 Jan 2008 13:30

Query Analyzer and Enterprise Manager work fine and I'm able to create tables, query, etc.

Antaeus · Post by **Antaeus** » Tue 08 Jan 2008 13:24

We have answered you by e-mail.

yeohray · Post by **yeohray** » Wed 09 Jan 2008 11:42

What was the issue then? I would have thought that if you can connect via QA/SSMS, connecting via SDAC shouldn't be an issue.

Thanks.

jdubois · Post by **jdubois** » Wed 09 Jan 2008 15:15

I ran some more of the system updates and it started working just like it was supposed to. We're guessing that the SQL Client software needed to be updated.