Path issues for Access databases in ASP

Most of the websites you do are using SQL databases, so there is not much contact with websites that use Access databases. Yesterday, when I was helping my friends with a Web site Admin program using an Access database, I got into some trouble.

The directory settings for this site are as follows (only the relevant sections are listed)


F1 directory is the background management program, F2 directory of Mydata.mdb is a database file, cnn.asp the database to specify the way, in other files in the way to include files.

Because Mydata.mdb and cnn.asp are in the same directory, the connection statement in Cnn.asp is written like this:
STRCNN = "Driver={microsoft Access Driver (*.mdb)};d bq=" & _
Server.MapPath ("Mydata.mdb")

Because it was originally written, I did not think carefully about what, directly in the F1 directory of the index.asp file to add the F2 statement
<!--#include file= ". /f2/cnn.asp "-->
Then run ... Well??? There's been a mistake!!
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft] [ODBC Microsoft Access Driver] Common error cannot open registry key ' temporary (volatile) Jet DSN for process 0x94 Thread 0x9a0 DBC 0x13b0074 T '.
The error prompted an error in the open database and the database was not found. is the database path wrong?

Look at the strcnn output in the cnn.asp first
Driver={microsoft Access Driver (*.mdb)};d Bq=c:f1mydata.mdb
Sure enough, the path is wrong!

It seems that this is the Server.MapPath the path to the page file containing the cnn.asp file as the current path. That is, if the index.asp in the F1 directory contains cnn.asp, then Server.MapPath ("Mydata.mdb") is C: F1mydata.mdb if a file under the F1 directory contains a cnn.asp, then Server.MapPath ("Mydata.mdb") is C:f1newsmydata.mdb;
Verified that the situation is indeed the case.

If the problem is found, it should be solved. Because you cannot qualify to include cnn.asp files in a few levels, you cannot get the correct path to the database using Server.MapPath; Do you want to write all the connections to the database in all the files that use the database? This is the next worst, try to avoid.

After n minutes of thinking, finally came up with a more cost-effective way is to not use the virtual path, first determine the actual path of the root directory, and then join the database path. The implementation code is as follows:

cnn.asp file:

Dim strcurpath,strcurlocation