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.

 

[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...