Unspecified Error (0x80004005)

[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.CreateOb ject("ADODB.Con nection")
objDC.Connectio nTimeout = 5
objDC.CommandTi meout = 10

objDC.Open "DBQ=" & Server.MapPath( "database/database.mdb") &
";Driver={Micro soft Access Driver
(*.mdb)};Driver Id=25;MaxBuffer Size=8192;Threa ds=20;", "username", "password"

strSQL = "SELECT Table.* FROM Table

Set objRS = Server.CreateOb ject("ADODB.Rec ordset")

objRS.Open strSQL, objDC, adOpenForwardOn ly, 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

[dany]

Re: Unspecified Error (0x80004005)


"rOadhOg" <roadhog@nospam .phreaker.net> wrote in message
news:u3seA69PDH A.3768@tk2msftn gp13.phx.gbl...[color=blue]
> 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[/color]
that[color=blue]
> goes to the page again I get this error...
>
> Error Type:
> Provider (0x80004005)
> Unspecified error
> /aspfile.asp, line 123
>[/color]

maybe this can help:

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

d.

[rOadhOg]

Re: Unspecified Error (0x80004005)

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

rh

"rOadhOg" <roadhog@nospam .phreaker.net> wrote in message
news:u3seA69PDH A.3768@tk2msftn gp13.phx.gbl...[color=blue]
> 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[/color]
that[color=blue]
> 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.CreateOb ject("ADODB.Con nection")
> objDC.Connectio nTimeout = 5
> objDC.CommandTi meout = 10
>
> objDC.Open "DBQ=" & Server.MapPath( "database/database.mdb") &
> ";Driver={Micro soft Access Driver
> (*.mdb)};Driver Id=25;MaxBuffer Size=8192;Threa ds=20;", "username",[/color]
"password"[color=blue]
>
> strSQL = "SELECT Table.* FROM Table
>
> Set objRS = Server.CreateOb ject("ADODB.Rec ordset")
>
> objRS.Open strSQL, objDC, adOpenForwardOn ly, 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[/color]
for[color=blue]
> 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
>
>
>[/color]