Microsoft JET Database Engine (0x80004005) Unspecified error

[ddz]

Hi all,
I got Win2000 and I just developed an intranet solution installed on my web server (IIS). The application worked nicely and there were not any problems. Few days ago I re - installed win2000 and I installed the IIS and my intranet solution but there is an error and the application doens't operate correctly with the Access database.
When it tries to retrieve data from the database the following error appears:

Microsoft JET Database Engine (0x80004005)
Unspecified error

The line of the code which is indicated by the error is the following:

objConn.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = "&loc&"; Jet OLEDBatabase Password="&passwd)

I updated Microsoft JET and MDAC. But just yesterday I went through the localhost web page and then I visited the web page of my application. In this way the error with the Microsoft Jet engine disappeared. I still don't know why but I repeated this procedure more times and everything works fine. If I try to connect directly to the url of the application (which is a virtual dir on the web server) I got the same problem.
If I go to localhost and then visit my application it works.

But it is not all. I noticed that if I stop browsing my application web site, after some minutes, I got the same error with the Microsoft JET engine.

Can someone explain me the reasons of this strange behaviour?
How can I resolve it?

Thanks,

Ddz

[BuddhaMan]

That command isn't close to being right and OLEDatabase isn't spelled right.

Suggest you read some more via Google searches starting with the correct format for the connection string.

http://www.asp101.com/articles/john/connstring/default.asp

This is one of mine:

DataPath = "..\data\rap.mdb"
DB_CONNECTIONSTRING = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & Server.Mappath(DataPath) & ";"

Set rsTRBRequirements = Server.CreateObject("ADODB.Recordset")
strSQLRequirements = "SELECT * FROM requirements INNER JOIN requirementdata ON requirements.requirementlist=requirementdata.requirement WHERE crewposition='" & strCP & "' ORDER BY sort;"
rsTRBRequirements.Open strSQLRequirements, DB_CONNECTIONSTRING

<Do stuff to the data here>

rsTRBRequirements.Close

[ddz]

Hi,
I tried with your example and I got the same error.
The fact is that it worked before without any problems...

I still really don't know how to resolve this problem.

Ddz