Friday, March 9, 2012

Invalid authorization specification connecting to Sql Server 2000

I have a vb 6 program that has been running for several years against a 6.5 db. I convert the db to 2000, and now when I repoint the software to the 2000 db, I get "Invalid Authorization Specification" when I try to open the connection. The connection string is:
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "Provider=SQLOLEDB" & _
";Data Source=" & sServer & _
";Initial Catalog=" & sDB & _
";User Id=" & goProcess.UserID & _
";Password=" & goProcess.Password & ";"
All of the variables are filled out correctly, when I go against a 6.5 it works, Sql Server 2000 doesn't.Did you set up the user in SQL 2000? and give persmissions for the database you are querying against?
|||I used the "sa" user to try to eliminate any issues. I'm able to use several C# programs to connect to the server in the same way (except vb uses ado, and C# uses ado.net).

No comments:

Post a Comment