10
Chapter 1: Migrating Applications from ColdFusion 5
Using the ColdFusion Code Compatibility Analyzer
To isolate compatibility issues between ColdFusion MX and ColdFusion Server 5, use the Code
Compatibility Analyzer to check your ColdFusion pages. Based on diagnostic information, the
Code Compatibility Analyzer issues error and information messages to alert you to the following
compatibility issues:
•
Obsolete CFML features in ColdFusion MX
•
Deprecated CFML features in ColdFusion MX
•
CFML features that might produce different behaviors in ColdFusion MX
•
CFML syntax errors
To access the Code Compatibility Analyzer, click the link in the ColdFusion MX Administrator.
When using the Code Compatibility Analyzer, follow these guidelines:
•
To avoid time-consuming operations and possibly degraded server performance for an
extended period of time, do not run the Code Compatibility Analyzer on multiple application
directories.
•
Use the advanced options to custom the tags, functions, and operators that are analyzed.
Database operations
ColdFusion MX uses JDBC drivers to interact with databases; for example, to query, write, and
update a database. (JDBC is an Application Programming Interface (API) for Java programs to
access data.) To connect to Open Database Connectivity (ODBC) data sources on Windows, you
can use the Data Direct SQL Link Type III ODBC Socket database driver, which is included with
ColdFusion MX.
This section describes the known incompatibilities between the ODBC features of ColdFusion 5
and the JDBC features of ColdFusion MX, in addition to those that are documented in
Chapter 3, “Tag and Function Changes,” on page 33
(for example,
cfquery
,
cfcatch
, and
cfreport
).
For more information about the Data Direct JDBC drivers included with ColdFusion MX, see
www.datadirect.com/index.ssp
.
Connecting to Microsoft Access databases
The ColdFusion MX Administrator includes options that make it easy to define data sources for
Microsoft Access databases. When defining a data source in the ColdFusion MX Administrator,
select Microsoft Access as the driver type. The Administrator automatically configures the ODBC
Socket driver with Access-specific settings.
Note:
When using Microsoft Access on a Unicode system, select the Microsoft Access with Unicode
driver. This is a JDBC Type 2 driver that works with Microsoft Access Unicode databases.