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