Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: Error Type: (0x80004005) Unspecified error when opening a recordset.


Message #1 by "John Epson" <john_epson@h...> on Mon, 15 Jul 2002 20:47:21
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?

  Return to Index