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).
Friday, March 9, 2012
Invalid authorization specification connecting to Sql Server 2000
Labels:
authorization,
connecting,
convert,
database,
invalid,
microsoft,
mysql,
oracle,
program,
repoint,
running,
server,
software,
specification,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment