User Guide

Chapter 4: Managing Data Sources 105
Creating the data source in ColdFusion:
1. Open the ColdFusion Administrator to the Data sources, Native Drivers page.
2. Enter a data source name and select the Oracle 8 native driver from the drop down
list.
3. When you click Add, ColdFusion opens the configuration page for the data source.
Here you enter information that tells ColdFusion where to find the database. The
options that are most important for a successful connection are:
• Host string — Enter the exact database alias you created using the Oracle Net8
Easy Config utility.
• ColdFusion Login username and password — These options appear when you
click the CF Settings button. The username and password are the same as those
used in the Oracle Net8 Easy Config connection test. If you don’t know what the
username and password should be, see your Oracle 8 DBA.
You may want to avoid setting a username and password here for security
reasons. If you don’t set a name and password, each CFML database call must
specifically define a username and password.
4. Once you have created the data source, open the Verify Data Source page in the
Administrator to verify that ColdFusion can connect to the Oracle 8 database.
Connecting to DB2 Data Sources
You can configure DB2 ColdFusion data sources for Windows NT and UNIX, using
both ODBC and native drivers.
Configuring DB2 Options (Windows)
If ColdFusion Server Enterprise edition is installed on a Windows NT server, you can
configure DB2 ColdFusion data sources using a native driver.
Native Driver: DB2 Universal Database 5.2/6.1 Options (Windows)
The following table describes ColdFusion options for the DB2 Universal Database 5.2/
6.1 native driver. You set these options when you configure a ColdFusion data source.
See “Adding Data Sources for ColdFusion” on page 82 for more information about
adding data sources to ColdFusion.
Configuring DB2 Options (UNIX)
If ColdFusion Server Enterprise edition is installed on a Solaris or Linux server, you can
configure DB2 ColdFusion data sources using a native driver. On a Solaris server, you
can also use an ODBC driver.