Page 1 of 1
Connecting to MS SQL 2005 SQLEXPRESS
Posted: Sat 05 Jan 2008 05:37
by jdubois
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.
Posted: Mon 07 Jan 2008 08:21
by yeohray
I would suggest installing Query Analyzer/Management Studio to confirm that there are no network issues in connecting to the SQL Server instances first.
Posted: Mon 07 Jan 2008 13:30
by jdubois
Query Analyzer and Enterprise Manager work fine and I'm able to create tables, query, etc.
Posted: Tue 08 Jan 2008 13:24
by Antaeus
We have answered you by e-mail.
Posted: Wed 09 Jan 2008 11:42
by yeohray
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.
Posted: Wed 09 Jan 2008 15:15
by jdubois
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.