Unspecified Error (0x80004005)

R

rOadhOg

Help please!

I set up a simple access 2000 database and I'm running IIS5.
The first time I try it, it works, then it seems like I have to wait for
some kind of time out for it to work again, because if I click the link that
goes to the page again I get this error...

Error Type:
Provider (0x80004005)
Unspecified error
/aspfile.asp, line 123

If I wait a few minutes before I try it again it works fine.

I have set up my data connection as follows

Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 5
objDC.CommandTimeout = 10

objDC.Open "DBQ=" & Server.MapPath("database/database.mdb") &
";Driver={Microsoft Access Driver
(*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"

strSQL = "SELECT Table.* FROM Table

Set objRS = Server.CreateObject("ADODB.Recordset")

objRS.Open strSQL, objDC, adOpenForwardOnly, adLockReadOnly

I close the recordset and connection at the end of the page with:

objRS.Close
Set objRS = Nothing
objDC.Close
Set objDC = Nothing

I have set the permisions for Everone and IUSR_MachineID to Full Control for
the database directory and the database.

I have played around with the timeout values above and it seems to have no
effect.

Any help?

rh
 
D

dany

rOadhOg said:
Help please!

I set up a simple access 2000 database and I'm running IIS5.
The first time I try it, it works, then it seems like I have to wait for
some kind of time out for it to work again, because if I click the link that
goes to the page again I get this error...

Error Type:
Provider (0x80004005)
Unspecified error
/aspfile.asp, line 123

maybe this can help:

http://www.aspfaq.com/show.asp?id=2413


d.
 
R

rOadhOg

Just to let you all know I added the line
objDC.mode = 3 ' adModeReadWrite
and this seemed to fix all.

rh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top