.NET 2003 Connection Issues with SQL Personal Edition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stosh - 13 Aug 2003 21:28 GMT

Has anyone seen this. I have SQL Server 2000 personal
edition installed on my laptop and cannot get VS.NET 2003
Enterprise Architect to establish a database connection.
Following the database connection steps, I select the
local domain, enter SA and password, select "Northwind"
and then click "Test Connection" and the result is "Test
Successful". When I then click OK, the resulting message
is "unable to connect".
If anyone has any insight, it would be most helpful.

Thanks in advance.

Reply to this Message

Felix Wu [MSFT] - 14 Aug 2003 04:02 GMT

Hi Stosh,

Can you connect to the database with Query Analyzer? Also, you could try
using SqlConnection class to connect to the db programmatically. For
example:

SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = "user id=sa;password=mypassword;initial
catalog=northwind;data source=mySQLServer;Connect Timeout=30";
myConnection.Open();

Another possible cause is that some MDAC components were corrupted on the
machine. You could re-install the latest MDAC.

For more information about MDAC, please check this link:
http://www.microsoft.com/data

Regards,

Felix Wu
=======
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>Content-Class: urn:content-classes:message
>From: "Stosh" <steve.aufderheide@suntrust.com>
[quoted text clipped - 27 lines]
>
>Thanks in advance.

Reply to this Message

.NET 2003 Connection Issues with SQL Personal Edition

Free Magazines