Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Re: BegASP3.0/Error Type: Microsoft JET Database Engine (0x80004005)


Message #1 by "John Epson" <john_epson@h...> on Mon, 15 Jul 2002 20:41:34
> Suddenly, when it had been working for months, my DB connection seems to
> have broke down and doesn't work anymore, generating the following...
> ----------------------------------------------
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Unspecified error
> ----------------------------------------------

You won't believe it, I have exactly the same problem (on three sites on 
the same server, with 3 different databases that all work fine on another 
machine).  So far, I have read the following.

1. Security problem (this I checked IUser has full control on the 
directories and the database - so I rule this out)

2. The TEMP & TMP environment variable has to be set to a directory that 
iuser has access to. Done this, no luck. 

I am rather keen to hear if you have any other ideas, or if you have 
found the solution ? 

Thanks

John
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 16 Jul 2002 13:37:48 +1000
a) Try the OLEDB Provider (if you not using it already):
www.adopenstatic.com/faq/whyOLEDB.asp

b) Also, have a look at the suggestion here:
http://www.aspfaq.com/show.asp?id=2142

c) If none of that works, then you may have corrupted MDAC components (this
has happened once or twice to me). If you're using Win2k/XP you can boot
from the CD and choose to repair your existing installation. This will
revert your MDAC components back to MDAC v2.5 - then download and install
the latest components from www.microsoft.com/data/

You could (before trying the above), try installing the latest Jet Service
Pack (v6), just to see if that fixes the problem:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010&

d) Changing temp environment variables doesn't work (AFAIK) - Jet always
uses x:\winnt\temp\ so you'll need to give permissions to that folder, not
to whatever folder tmp and temp are set to.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "John Epson" <john_epson@h...>
Subject: [asp_database_setup] Re: BegASP3.0/Error Type: Microsoft JET
Database Engine (0x80004005)


: > Suddenly, when it had been working for months, my DB connection seems to
: > have broke down and doesn't work anymore, generating the following...
: > ----------------------------------------------
: > Error Type:
: > Microsoft JET Database Engine (0x80004005)
: > Unspecified error
: > ----------------------------------------------
:
: You won't believe it, I have exactly the same problem (on three sites on
: the same server, with 3 different databases that all work fine on another
: machine).  So far, I have read the following.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.


  Return to Index