The ColdFusion Administrator lets you quickly create a data source so that your ColdFusion applications can interact with various databases.
In the Add New Data Source area of the Data Sources page, enter a data source name.
Select a driver from the drop-down list box.
Click Add. A form appears that requests additional information. The available fields in this form depend on the driver that you selected. The following names are reserved; you cannot use them for data source names:
service
jms_provider
comp
jms
In the Database field, enter the name of the database.
In the Server field, enter the network name or IP address of the server that hosts the database, and enter any required port value. The ColdFusion Administrator suggests typical default ports, such as 1433 for SQL Server. For more information, see the "Connect to..." topic for your database in the Related topics.
If your database requires login information, enter your user name and password.
Tip: The omission of required user name and password information is a common reason why a data source fails to verify.
(Optional) Enter a description.
(Optional) Click Show Advanced Settings to specify any additional settings; for example, to configure which SQL commands will interact with this data source. For more information, see the "Connect to..." topic for your database in the Related topics.
If you do not want to autogenerate the keys for data sources, select the Disable autogenerated keys check box. By default, this check box is not selected. If you select it, the autogenerated keys are not retrieved when you run INSERT queries. When transaction volumes are very high, Oracle data sources throw the exception "Auto-generated keys were not requested", or "the SQL was not a simple INSERT statement". This happens because the autogenerated keys are retrieved with the transactions. The Disable autogenerated keys setting disables the retrieval of auto generated keys to resolve this issue.
Click Submit to create the data source. ColdFusion automatically verifies that it can connect to the data source.
(Optional) To verify this data source later, click the Verify All Connections icon.
1. From the Connected Data Sources list, click the first icon under Actions, which is the edit icon. You can also edit the data source by clicking the data source name.
2. Modify the settings for the datasource and click Submit to update the configuration.