Hi,

I try to access within an classic ASP page an MDF file (newres.mdf) of sql server express 2005 database which is located in
c:\inetpub\wwwroot\reskrosql\App_Data.
I get following error :

Provider error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done"

The code in ASP file:
--------------------
<%
set objdc = Server.CreateObject("ADODB.Connection")
objdc.Open(application("newres")) 'error line
%>

global.asa:
----------
Sub Application_OnStart
Application("newres") =
"Provider=SQLOLEDB;DATABASE=c:\inetpub\wwwroot\res krosql\App_Data\newres.mdf;Data
Source=.\SQLEXPRESS;AttachDbFilename=c:\inetpub\ww wroot\reskrosql\App_Data\newres.mdf;Integrated
Security=True;User Instance=True"


'i also tried this:
Sub Application_OnStart
Application("newres") = "Provider=SQLOLEDB;DATABASE=newres;Data
Source=.\SQLEXPRESS;AttachDbFilename=c:\inetpub\ww wroot\reskrosql\App_Data\newres.mdf;Integrated
Security=True;User Instance=True"

End Sub

Thanks for help
H.

Hi hertendreef,

The feature AttachDbFilename is supported by ADO.Net 2.0 .
(http://msdn2.microsoft.com/en-us/library/ms254499.aspx)

I am not sure if this is supported by classic ADO.
May be this is the reason you got the error.


Regards
Bishnu Pokharel
[email protected]
http://www.bishnupokharel.com.np/