error when connecting to sql server

Hi,

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
bart [ Do, 22 März 2007 09:16 ] [ ID #1665475 ]
Webserver » microsoft.public.inetserver.asp.db » error when connecting to sql server

Vorheriges Thema: Error with Connection Objectq
Nächstes Thema: Simple SQL ORDER BY doesn't work!