Setting up a dsn-less connection is as simple as setting up a dsn through the cpanel or the SMT. However setting up a dsn-less connection allows you to place databases anywhere on your windows virtual server and map it accordinally. For older accounts (such as Power Sites), the actual syntax is:myDSN = “DRIVER={Microsoft Access Driver (*.mdb)};”
myDSN = myDSN & “DBQ=D:\Home\AITResell.com\webadmin@yourdomain.com\yourdomain.com\path\toyour\databasedatabasename.mdb;”
Conn.ConnectionString = myDSN
Conn.Open myDSN,””,””
The set of quotations are necessary for the connection to be made. This is where you would put your database username and password if you assigned one to the database. For newer accounts, you will use the same syntax, however, you will use the following path:D:\home\reseller@yourtld\webadmin@yourdomain.com\yourdomain.com\path\toyour\databasedatabasename.mdb
where “reseller@yourtld.com” is actually the path to your top level domain, and yourdomain.com is replaced with your domain.
For example, AITAccess.com is a virtual host of AIT.com. So the path to set this up for AITAccess.com would beD:\home\reseller@AIT.com\webadmin@AITAccess.com\AITAccess.com\db\access.db.