System Error When Connecting to Local Server

[pagego]

I get a System Error when I try to run a database program using a dataset. I declare the connection below:

 

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

 

After I get the error message the following line is highlighted:

 

myconnection.Open()

 

Is there possibly a problem with my software? Is there something database related that I need to have installed on my computer that I might not have? Thanks for your help.

[Guest mutant]

For me localhost or something like that doesnt always work.

Try specifying your computer name and sql server instance instead of local. Like this:

COmputerName\SqlServerName

[Robby]

Something more generic that should be more portable...

 

...server=127.0.0.1...