The steps to create ODBC Data Source (DSN) depend on platform your website is hosted on:

Windows 2003

Windows 2008

Note: Data Source Name must be unique on the Shared Server your website is hosted on; HostPilotĀ® Control Panel will reject a name if it is already in use by another customer on the same Shared Server.

Windows 2003

MSSQL/MySQL

  1. Create your SQL (MSSQL or MySQL) database using HostPilot.
  2. Navigate to HostPilot > Web/FTP Server > Web Server > ODBC Data Sources page:
    - leave the Currently Selected Database as is;
    - specify your Data Source Name to be used;
    - select a corresponding driver to match the database type;
    - click on Add ODBC Data Source button:

     
  3. You will be prompted to enter the database server name (your SQL server name can be found on HostPilot > SQL Server > Databases page) and the corresponding SQL database that was previously created; after providing all of these details you will see the Data Source created:
     

Other database types (MS Access .mdb, Excel .xls, etc.)

  1. Upload the database file to your FTP Server; we recommend uploading it to /Database directory Anonymous user has Write permissions to. and then you need to specify the path to it in the Currently Selected Database field using Browse button  
  2. Navigate to HostPilot > Web/FTP Server > Web Server > ODBC Data Sources page:
    - specify the path to your database file in the Currently Selected Database field using the Browse... button;
    - specify your Data Source Name to be used;
    - select a corresponding driver to match the database type;
    - click on Add ODBC Data Source button:
  3. You will see the Data Source created in the ODBC Data Sources section.

Notes:

  • The Maintain option is applicable for accounts on ColdFusion plans only.
    It improves performance by caching the data source connection. When the Maintain option is enabled for a data source, ColdFusion keeps the connection open after its first connection to the database, it does not log out of the database after this first connection. Therefore, in case you need to disable Maintain option to download/upload your Access database or modify SQL database directly, please do not forget to enable this option again.
  • ODBC Datasources for MAccess databases are not supported on accounts with ColdFusion 8. 

 

Windows 2008

To create ODBC Data Sources on Windows 2008 hosted website we recommend to use the Connection Strings option available in the IIS Remote Manager.

If you use a database to store data for your applications, you can create a connection string in IIS to store the information that an application uses to connect to the database. To create a connection string:

  1. Connect to your sever using IIS Manager.
  2. In Features View, double-click Connection Strings.
  3. On the Connection Strings page, click Add in the Actions pane.
  4. In the Add Connection String dialog box, type a name for the connection string in the Name text box.
  5. With the SQL Server option selected, type the name of the server that hosts the database in the Server text box and type the name of the database in the Database text box.
  6. Select Specify credentials and click Set. Type a user name and password for an account that can connect to the server and database in the User name and Password text boxes. Then type the same password in the Confirm password text box, and click OK.
  7. Click OK.

Notes:

  • We support only MSSQL\MySQL Servers drivers on Windows 2008.
  • When a DSN is created via IIS Manager or by editing web.config, such a DSN can be used only for ASP.NET applications. If you are running an ASP application, you may either need to create a connection string in your global.asa or hard-code it in your script.