asp_database_setup thread: Re: Error Type: (0x80004005) Unspecified error when opening a recordset.
Hi there,
Did you ever solve this problem ?
CHeers
John
> I'm able to get some of my pages to communicate with the access db with
no
p> roblems, however I get errors when trying to call recordsets to open.
> In my global.asa I've got:
> Sub Application_OnStart
'> Add your Application_OnStart code here
A> pplication("openStr") = "Provider=Microsoft.Jet.OLEDB.4.0;Data
S> ource=C:\Inetpub\Training_server\training.mdb"
E> nd Sub
> for my connection in the .asp page I'm using:
> Set cn = Server.Createobject("adodb.connection")
c> n.Open Application("openStr")
> Connecting via the ODBC access driver works as follows:
> openStr = "driver={Microsoft Access Driver (*.mdb)};" & _
> "dbq=" & Server.MapPath("training.mdb")
S> et cn = Server.Createobject("adodb.connection")
c> n.Open openStr
> Can anyone please help?