User Tools

Site Tools


applications:adobe:coldfusion

Applications - Adobe - ColdFusion

Blogposts/Articles

ColdFusion 9

Documentation

ColdFusion 8

ColdFusion 9

ColdFusion 8

ColdFusion 9

Software updates

ColdFusion 8

ColdFusion 9

Troubleshooting

Installation of the JT400 JDBC driver in ColdFusion 9 to access an AS/400

A 64-bit installation of ColdFusion 9 does not support 64-bit ODBC drivers (source).
Installing the 64-bit iSeries Client Access to get the ODBC drivers is therefore useless.
To work around this you can revert to using 32-bit ColdFusion 9 and iSeries Access Client or you can install a JDBC driver for AS/400 in ColdFusion 9 by doing the following:

  1. Download the latest JT400 driver from JTOpen.
  2. Extract jt400.jar from the zip file to \JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\lib\ (for multiserver or J2EE configuration) or %cf_root%/lib (for server configuration only) on the server.
  3. Restart all ColdFusion 9 services or just the Macromedia JRun CFusion Server service for the multiserver or J2EE configuration.
  4. Open a browser, browse to http://servername/IDE/administrator and log in.
  5. Go to Data & ServicesData Sources.
  6. Below Add New Data Source:
    1. Enter a name for Data Source Name.
    2. Select other as the driver.
  7. Click on Add.
  8. Enter a JDBC URL like
    jdbc:as400://server_name/database_name;prompt=false;
  9. Enter the following for Driver Class:
    com.ibm.as400.access.AS400JDBCDriver
  10. Enter JT400 as Driver Name.
  11. Enter a username and password for the connection.
  12. Click on Submit

Sources:
ColdFusion Developer's Journal - Macromedia ColdFusion - MX to iSeries Demystified for the JDBC URL and Driver Class.
Configuring and Administering ColdFusion 9 - Data Source Management - Connecting to an external JDBC Type 4 data source for the correct location for jt400.jar.
Adobe Forums > ColdFusion > ColdFusion Server Administration > 64-bit ColdFusion 9 ODBC drivers confusion? (architecture mismatch) to find out that the 64-bit ColdFusion 9 does not properly support 64-bit ODBC drivers.

applications/adobe/coldfusion.txt · Last modified: 2022/08/07 16:27 by bas

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki