MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION..., Manual

Page: 45 / 170

Adding data sources 45
Supplied drivers
The following table lists the database drivers supplied with ColdFusion MX and where you can
find more information about them:
To see a list of database versions that ColdFusion MX supports, go to
www.macromedia.com/go/sysreqscf .
When running in the J2EE configuration, the ColdFusion MX Administrator also lets you
configure a data source that connects to a JNDI data source. A Java Naming and Directory
Interface (JNDI) data source is equivalent to a ColdFusion data source, except you define it using
your J2EE application server. After it’s defined, ColdFusion MX applications use it as they would
any data source. For information on defining a JNDI data source, see
“Connecting to JNDI data
sources” on page 63 .
Adding data sources
In the ColdFusion MX Administrator, you configure your data sources to communicate with
ColdFusion. After you add a data source to the Administrator, you access it by name in any
CFML tag that establishes database connections; for example, in the
cfquery
tag. During a
query, the data source tells ColdFusion which database to connect to and what parameters to use
for the connection.
The ColdFusion MX Administrator organizes all the information about a ColdFusion MX
server’s database connections in a single, easy-to-manage location. In addition to adding new data
sources, you can use the Administrator to specify changes to your database configuration, such as
relocation, renaming, or changes in security permissions.
Driver Type For more information
DB2 Universal Database 4 “Connecting to DB2 Universal Database” on page 47
DB2 OS/390 4 “Connecting to other data sources” on page 60
Informix 4 “Connecting to Informix” on page 49
Microsoft Access 3 “Connecting to Microsoft Access” on page 50
Microsoft Access with Unicode
support 2 “Connecting to Microsoft Access with Unicode”
on page 52
Microsoft SQL Server 4 “Connecting to Microsoft SQL Server” on page 53
MySQL 4 “Connecting to MySQL” on page 56
ODBC Socket 3 “Connecting to ODBC Socket” on page 57
Oracle 4 “Connecting to Oracle” on page 59
Other “Connecting to other data sources” on page 60
Sybase 4 “Connecting to Sybase” on page 62