I am sure I am posting this to the wrong section of this forum.
My question is related to SQL Server 2005 and Classic ASP.
I can't seem to connect to our prod db using the below code.
<%
set cn=server.createobject("ADODB.Connection")
cn.provider = "sqloledb"
provstr = "server=myserver;Database=SysProd;UID=abc;PWD=def;"
cn.open ProvStr
%>
If I change the database(SysProd) to point to our dev system (SysDev), I am able to connect.
At first I though this was related to user security. I am now not sure. As far as I can tell, the security is configured the same on each database for the user. Could there be a setting at the database level that I am not looking at which would prevent connecting via Classic ASP?
My question is related to SQL Server 2005 and Classic ASP.
I can't seem to connect to our prod db using the below code.
<%
set cn=server.createobject("ADODB.Connection")
cn.provider = "sqloledb"
provstr = "server=myserver;Database=SysProd;UID=abc;PWD=def;"
cn.open ProvStr
%>
If I change the database(SysProd) to point to our dev system (SysDev), I am able to connect.
At first I though this was related to user security. I am now not sure. As far as I can tell, the security is configured the same on each database for the user. Could there be a setting at the database level that I am not looking at which would prevent connecting via Classic ASP?