Unable to connect to the Pubs.mdf database file

[LiLo]

Hi,

I am using vb2005 to try to connect to the PUB.MDF database file. I copied the file into the same folder as the vb code files.

I used the statement below as the sqlConnection:

dim myConnection as SqlConnection = new _
SqlConnection("server=(local);database=pubs;uid=sa;pwd=")

When the program runs, there was a run time error and vb highlighted the line "myConnection.open()" and said that there was an error connecting to the database.

How do I solve this problem?

I did not set any password and userID to the database file. I tried removing the uid and pwd parameters but the error remains.