Macromedia colfusion mx 7 Manual
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:
find more information about them:
To see a list of database versions that ColdFusion MX supports, go to
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
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
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
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.
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.
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
DB2 OS/390
4
Informix
4
Microsoft Access
3
Microsoft Access with Unicode
support
support
2
Microsoft SQL Server
4
MySQL
4
ODBC Socket
3
Oracle
4
Other
Sybase
4