Accessing SQL Server
I'm trying to connect to a sql server, but am getting the following error...
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
/login_submit.asp, line 23
this is login_submit.asp line 23
which uses the connection string from the global.asa
Application("WR_ConnectionString") = "Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=user;Initial Catalog=[catalog];Data Source=[DS];"
Any help would be appreciated, thanks.
Okay, thanks, I'll give that a try.