What's wrong with this ASP connection string?

  • Thread starter Thread starter Ceptor
  • Start date Start date
C

Ceptor

Guest
Hi there,

Having a little trouble connecting to a remote SQL server using this connection string:

connection.Open "PROVIDER=MSDASQL; DRIVER={SQL Server}; SERVER=xxx.xxx.edu\xxx,1052; DATABASE=sms3000; UID=sms_db_ro;PWD=xxxxxx;"

Replaced personal information with Xs.

It's an ODBC connection.

Getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'sms3000'. Login fails.

Any ideas?
Addition Question:

Is it possible the string is correct and that the user simply does not have read/write priveledges on the database?
 
Back
Top