Is there any way to setup MetaTraffic so it accesses the database as a DSN for MS Access? My DSN points to a folder that is outside of the normal www area. That way it can't be hacked by going to it or figuring out how to get my databases.
The setup.asp won't let me use the DSN (A1870_MetaTraffic).
My DSN is coded:
"Provider=MSDASQL.1;Persist Security Info=False;User ID=;Data Source=A1870_MetaTraffic"
DSN
You can easily specify a file outside of your web site's directory structure by using an absolute path to the db. For example:
d:\inetpub\database
MetaTraffic does not support DSNs natively. The primary reason for this is because DSNs add extra overhead to database connections. It is more efficient to use file names instead.
The easiest way to add DSN support to MetaTraffic would be to add some code to the CreateDatabaseConnection function in the core.asp file. Some minor knowledge of ASP would be required to do this.
Regards,
~Chad