Knowledgebase

How to Create a ColdFusion Access DSN in the Control Panel

Posted by on September 02 2015 01:24 PM

A data source name (DSN) is a one-word identifier that points to your database and contains all the information needed to connect. When used on your site, the DSN tells the web server which database to connect to and what parameters to use for the connection. An Access DSN is configured differently than a regular DSN.

To configure a DSN for your Windows or ColdFusion plan to connect to a MySQL or MS SQL database, please see one of these articles: How to Create a Windows DSN in the Control Panel OR How to Create a ColdFusion DSN in the Control Panel

This article assumes that you are already familiar with how to log in to the customer control panel. If you do not know how to log in or have forgotten your password, please refer to this article first.

  • On the control panel Home tab, click "Manage" under the ColdFusion section.

  • From the Access DSNs tab, click "Add New".

  • Enter a DSN name, the database file location, and your database credentials (if needed). Click Next once completed. Note: Your DSN name will start with your subscription ID plus an underscore, followed by the name entered on this page. Database File Note: The file must be relative to your site directory (ie. /wwwroot/test.mdb).

  • Click Finish to confirm creation of the Access DSN.

If you have any further questions that were not answered in this article, please contact us.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Copyright © 2016 HostMySite