Creating A DSNless Connection String with various Databases

A DSNless connection string is one that does not require a DSN (DataSource) to be created in the WebControlCenter.

Access
"DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=d:\inetpub\EXAMPLE\database\database.mdb

FoxPro
"DRIVER={Microsoft Visual Foxpro Driver (*.dbc)};
DBQ=d:\inetpub\EXAMPLE\database\database.dbc

Dbase
"DRIVER={Microsoft dBase Driver (*.dbf)};
DBQ=d:\inetpub\EXAMPLE\database\database.dbf

The local path to the website can be found in the WebControlCenter. If you have not already, login to the Control Center at
https://www.webcontrolcenter.com/domain.aspx
and from the menu item Site > Site Overview.

Further examples of DSN and DSNless connection strings can be found in Connection Strings For MySQL .

** DSNless connection strings do not work with ColdFusion MX. Therefore, FoxPro and Dbase are not supported with a ColdFusion MX plan.

Add Feedback