error when connecting to sql server
am 22.03.2007 09:16:53 von bartHi,
I get following error when trying to connect to a MDF file of sql server
express 2005 database:
"Microsoft OLE DB Service Components 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"))
%>
global.asa:
----------
Sub Application_OnStart
Application("newres") = "Provider=SQLOLEDB; Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\newres. mdf;Integrated
Security=True;User Instance=True"
End Sub
Thanks for hrlp
Bart