The Native Database Data Sources page displays existing ODBC data sources by name and driver, and the connection status (OK or Failed). Use this page to configure a new data source, edit the configuration of an existing source, and verify connections. (Note that you can also manage connections using the Datasource Connection Summary page.)
Click Server>Native data sources in the ColdFusion Administrator navigation frame. The Native Data Source page appears.
Enter a name in the Data Source Name field. ColdFusion reserves the words "Registry" and "Cookie" for use. Do not use one of these words as a data source name.
Select a driver from the drop-down Driver list.
Click Add to see the Create ODBC Data Source page. The fields you see depend on the selected driver.
Complete the configuration
as described in the appropriate topic for your selected driver. (See the
database driver topics list.)
Note that if you are creating a UNIX data source, you might have to
set environment variables for your database client library by editing
the ColdFusion start script in <installdir>/coldfusion/bin. For
detailed information about editing the ColdFusion start script, see the
book Advanced ColdFusion Server Administration.
You can set further specifications for the data source, such as requiring use of a username and password. Click CF Settings to see additional fields. Complete the fields as described in Select ColdFusion Settings.
Click Create
when you finish configuring the data source.
ColdFusion Administrator verifies automatically that it can connect
to the data source. If verification succeeds, the Data Source page displays
with the new data source highlighted. If the verification fails, an error
message displays. For information about troubleshooting verification failures,
see the book Advanced ColdFusion Server
Administration.
On the Native Data Sources page, click a name in the Data Source Name column. The Edit ODBC Data Source page appears.
Edit the configuration as described in the appropriate topic for your selected driver. as described in the appropriate topic for your selected driver. (See the database driver topics list.) To cancel your changes any time, click Cancel. Your original configuration remains intact.
To set further specifications for the data source, click CF Settings to see additional fields. Complete the fields as described in Select ColdFusion Settings.
Click Update
when you finish changing a configuration.
ColdFusion Administrator verifies automatically that it can connect
to the data source. If verification succeeds, the Data Source page displays
with the new data source highlighted. If the verification fails, an error
message displays. For information about troubleshooting verification failures,
see the book Advanced ColdFusion Server
Administration.