I have a web hosting server that requires the Access database reside in data/ directory off the root and setup a DSN on the server in the format of mysite.DSN Name(where name is the DSN name I gave it) Since this is residing on the hosting server, how do I config the application to use the hosting server's DSN that I established?
Hi, you don't need to use DSN if you work with Access.
check off Use Server.MapPath on the Database file tab in ASPRunner.
In the Output directory copy of the database is created and afterwards ASP pages work with this particular copy. After you'll transfer db directory to the remote server open include/dbconnection.asp file and edit path to database.
It will looks like server.mappath("..\db\test.mdb") for example.
