Discussion on asp access data errors

The day before yesterday, N had an Access database program that had been made for a long time before, and the program had not been changed. It was good before and suddenly failed.

The error message is as follows:

----------------------------------

Microsoft ole db provider for ODBC drivers error ''000000''

[Microsoft] [ODBC Microsoft Access driver] common errors do not enable the Registry keyword ''temporary (volatile) jet DSN for process 0x728 Thread 0x854 DBC 0x276fb44 jet ''.

----------------------------------

　　

A server was damaged by attacks recently and is being reinstalled. You have no time to handle this problem. Later, I decided to deal with it with the help of a friend (who is the user of the program.

At the beginning, I really don't know what's going on. I have searched a lot on Google and have different opinions. I have filtered out a bunch of unwanted junk information for the following possible reasons:

1. Microsoft has not updated ODBC and needs to use jet to connect to access database files;

2. The permission of the system directory is changed.

There are also some old posts saying why: "The ACCESS database file is Access97". I don't need to consider this. I use the Access2000 Database.

　　

For the first reason, the original connection string is as follows:

-- ODBC connection method ------------------------

Mdbpath = server. mappath ("My. MDB. asp ")

Cnnstr = "DBQ =" & mdbpath & "; driver = {Microsoft Access Driver (*. mdb)}; uid = admin; Pwd ="

-------------------------------------

　　

The connection string is:

--- Jet connection method ---------------------

Cnnstr = "provider = Microsoft. Jet. oledb.4.0; user id = admin; Data Source =" & mdbpath & "''; Password = luntanbbs"

-------------------------------------

　　

The error message displayed after the test is invalid:

----------------------------------

Microsoft Jet Database Engine error ''000000'' unspecified error

----------------------------------

　　

Finally, check the second reason: the system directory permission is insufficient. After inquiry, a colleague set the WINNT directory of the server to Administrators, System "Full Control" for security reasons, and users is read-only.

However, in this permission setting, the ODBC driver is in winnt/system32/odbcjt32.dll, which is also readable. Is it because the "execution" permission is missing?

I granted the "execution" permission to all DLL files starting with ODBC in the WINNT/system32/directory and found the same error message. I simply set the entire system32 directory to the everyone executable, but the test still fails.

Is there other files called by ODBC or jet, but not in the System32 directory and not fully authorized?

When you think about it, you can see the WINNT/TEMP directory. Hey, I set the temp directory to everyone to "write.

One test, hey, yes. The program connected using ODBC successfully reads the records in the updated access database.
　　

Interestingly, the program using the jet connection method reports another error:

-------------------------------------------

Microsoft Jet Database Engine error ''80040e4d '': the application cannot be started.

The workgroup information file is lost or exclusive to other users.