Configure Datasources

Adding Data Sources

If you are using the Data Import Feature to bring in records from an existing CHRID Access Database you will need to install 3 datasources using the Coldfusion Administrator. If you are starting from scratch and you do not plan on using the data import then you only need to install one datasource. Before you begin you will need:

1.	FLQDN - Fully Qualified Domain Name for your SQL server.

You should avoid using an IP address for your SQL server. Since the CF server uses JDBC, a FLQDN is a better choice. Even if your SQL server doesn't have a FLQDN you can still add an entry to the host file to keep JDBC from trying to resolve the IP via "reverse lookup" - an expensive process that adds time to your initial connection request.

2.	A username and password with full permissions to the SQL server in question.

3.	The name or names of the databases on the SQL server.

4.	A blank Access DB (one is provided for you in the /install directory).

More information on adding datasources to a Coldfusion server may be found in the Coldfusion Administrators Guide.