I am trying to get some code to work from the book and I keep getting an error.

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

Additional information: System error."

I get the error at the 'objConnection.Open()' line

Here is the objConnection defined:
Dim objConnection As New SqlConnection("server=(local);database=pubs;user id=administrator;password=all")

I can connect to the db via the tools menu and every other way I have tested, just not via my code which is just as it it described to me in the book.

Any help would be greatly appreciated.

I got it. I changed how I was authenticating with the server.

From:
'Dim objConnection As New _
    'SqlConnection("server=(barsitech);database=pubs;u ser id=sa;password=")


To:
Dim objconnection As SqlConnection = New _
        SqlConnection("server=barsitech;integrated security=SSPI;initial catalog=pubs;")

not did you help yourself you helped me too!!!! THANKS!!!!, how and where did you figure this out?