Invalid authorization specification error with Classic ASP accessing SQL Server

I am getting the following error: Invalid authorization specification

I've narrowed down the error to my connection string. I have verified the server name, database, user & password are correct. Here is the string:

"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 开发者_JAVA百科access to its settings.

Please help, I've scoured the internet for a solution!

---

You did not specify what version of SQL server.

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

---

try with:

Provider=SQLOLEDB.1;Initial Catalog=fooDB;Data Source=xxxxx.db.12345.hostedresource.com;User ID=fooUser;Password=fooPW;Persist Security Info=True