I am working with VS 2005/ASPnet 2.0; but still need to work on some
old VS 2002/3 codes. The following connection coding which I tried to modify received the subject error msg.

Exactly what's wrong with the connection string?

TIA,
jeffrey

Dim conClsf As OleDbConnection
        Dim cmdMbrs As OleDbCommand
        Dim rdrMbrs As OleDbDataReader

        conClsf = New OleDbConnection( _
                 "Provider=SqlOleDb;" & "Data Source=myWebServer;" & "Initial Catalog=Northwind;" & "User Id=ME;" & "Passwrod=pwdpwdpwd;" & ";")
        conClsf.Open()
        cmdMbrs = New OleDbCommand( _
                  "select * from Employees", _
                  conClsf)

__________________
C. Jeffrey Wang

"Passwrod=pwdpwdpwd;" may be the problem..

Try "Password" ;)

Rob
http://robzyc.spaces.live.com

Thank you very very much. It worked.

HTH, I know how valuable a second pair of fresh eyes can be when you have been trying to spot something like this!

Rob
http://robzyc.spaces.live.com