sql connection string - AndreaVB OnLine

AndreaVB OnLine : Database : sql connection string

Poster

Resource

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