R
RN1
I use SQL Server 2005 Management Studio Express as the database. For
ASP files to connect to SQL Server 2005, I am using the following
ConnectionString:
<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Data Source=RON\SQLEXPRESS;Initial
Catalog=RON;Integrated Security=True"
%>
But ASP generates the following error pointing to the objConn.Open
line:
-------------------------------------------------------------------------------
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
-------------------------------------------------------------------------------
But when I use the same ConnectionString is ASPX files, no error gets
generated & I can access records residing in SQL Server 2005
successfully.
What could be causing this problem?
ASP files to connect to SQL Server 2005, I am using the following
ConnectionString:
<%
Dim objConn
Set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "Data Source=RON\SQLEXPRESS;Initial
Catalog=RON;Integrated Security=True"
%>
But ASP generates the following error pointing to the objConn.Open
line:
-------------------------------------------------------------------------------
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.
-------------------------------------------------------------------------------
But when I use the same ConnectionString is ASPX files, no error gets
generated & I can access records residing in SQL Server 2005
successfully.
What could be causing this problem?