Recently upsized MS Access database to SQL Server 7 hosted at an ISP. Was able to login using connection string:
CS = "Provider=sqloledb.1;"
CS = CS & "Data Source=Client-Sample;"
CS = CS & "Initial Catalog=xterm;"
CS = CS & "Persist Security Info=False;"
CS = CS & "User ID=pretend; Password=sample"
' Create the Connection object and open it.
set oCONc = Server.CreateObject("ADODB.Connection"
oCONc.Open CS
But after inserting a record using ASP I find that I am now unable to log back into the file. The following message occurs:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database requested in login 'xterm'. Login fails.
Maybe the insert was a coincidence. As for the connection string, other databases were recently converted and nothing is wrong with them. I'm able to login, read, insert into the other databases using the same connection string format.
What's your guess?
CS = "Provider=sqloledb.1;"
CS = CS & "Data Source=Client-Sample;"
CS = CS & "Initial Catalog=xterm;"
CS = CS & "Persist Security Info=False;"
CS = CS & "User ID=pretend; Password=sample"
' Create the Connection object and open it.
set oCONc = Server.CreateObject("ADODB.Connection"
oCONc.Open CS
But after inserting a record using ASP I find that I am now unable to log back into the file. The following message occurs:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database requested in login 'xterm'. Login fails.
Maybe the insert was a coincidence. As for the connection string, other databases were recently converted and nothing is wrong with them. I'm able to login, read, insert into the other databases using the same connection string format.
What's your guess?
