DSNless connections are preferred and take less time to start using. For more information, please refer toDSNless connections.
If you require a DSN configured within the ColdFusion Administrator; please be sure to create your Database connection via the control panel; then simply open a support ticket request that contains the following connection information.
Database Type: MSSQL; MySQL or Access
Desired Data Source Name (DSN):
yourdatabasename:
Optional: (see note below)
yourDBusername:
yourDBpassword:
Providing the Username/Password combination in your code is the preferred and suggested method of setting up and accessing your DSN.
**CFDynamics is not responsible for any security issues if you are allowing ColdFusion Administrator to manage and pass this information in the DSN.**
*****Access DB Note*****
Please make sure your Access database is uploaded to the \data\ folder located above your wwwroot; if this step is not completed the process will take longer to finish.