sql connection string - AndreaVB Visual Basic and VB.NET source code discussion board

Next Topic (how to connect an oracle database by using Dao reference??)

AndreaVB Forum : Database : sql connection string

Poster

Message

krishna_thakrar
Level: Guest

sql connection string

I have a problem with the connection string to sql using ADO.

The following is the string I use and I get the error message "Object dosen't support named arguments"

Please help

msConnectString = "Provider=SQLOLEDB.1;" & _
                      "Data Source=" & sServerName & ";" & _
                      "uid=" & sUserID & ";" & _
                      "pwd=" & sPassword & ";" & _
                      "Initial Catalog=" & sDatabaseName & ";"

Thanks very much