Have Geek Brain

Invalid Authorization Specification Error Using Classic ASP to Access SQL Server

I am getting the following error: Invalid Authorization Specification

I have narrowed down the error to a connection string. I have verified that the server name, database, username and password are correct. Here is the line:

"Provider=SQLOLEDB;Server=xxxxx.db.12345.hostedresource.com;Database=foo;UID=fooUser;PWD=fooPW"

The SQL server is hosted on Godaddy, so I don't have access to its settings.

Please help, I tried internet for a solution!

+2


a source to share


2 answers


You did not mention which version of SQL server.



See this site for all allowed connection strings - you will need to look at your version under the OLE DB driver.

+1


a source


try:



Provider = SQLOLEDB.1; Home directory = fooDB; Data source = xxxxx.db.12345.hostedresource.com; User id = fooUser; Password = fooPW; Persist Security Info = True

0


a source






More articles:


All Articles