Saturday, February 25, 2012

Problems with myconnection.Open()

When my program is running, at the line myconnection.Open()m it says that there is an error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.

What is this?

I aquired SQL server 2000 and installed it on my machine

I thought the problem was with the line when setting up the connection as there wasnt previously a SQL server running on machine.

Dim myconnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=;pwd=")

Does anyone know how to fix this problem?At first guess, I'd say that it was because you have no loginid or password specified, but I could be confused!

I'm really surprised that Tony hasn't moved this off to the VB area. He generally tries to keep this area tightly focused on SQL only.

-PatP

No comments:

Post a Comment