This TechNote describes how to configure Macromedia ColdFusion MX to use the Sybase JDBC jConnect 5.5 driver to connect to Sybase databases.

To connect to a Sybase database using the JDBC jConnect 5.5 driver, you'll need to install and configure the following in your development and deployment environment:

1. Download the jconnect55.zip file from the Sybase web site.
2. Windows platforms:
   1. Stop the ColdFusion Application service.
   2. Extract the jconn2.jar file and save it in thecf_root/runtime/servers/lib directory.
      
      Note: If this directory does not exist, you will need to create it. The jconn2.jar file contains the SybDriver class information that you need resident on your ColdFusion MX server.
   3. Restart the ColdFusion Application service.
   Unix platforms:
   1. Stop the ColdFusion process.
   2. Extract the jconn2.jar file and save it in thecf_root/runtime/servers/lib directory.
      
      Note: If this directory does not exist, you will need to create it. The jconn2.jar file contains the SybDriver class information that you need resident on your ColdFusion MX server.
   3. Edit the cf_root/runtime/bin/jvm.config file, adding the path for runtime/servers/lib into the classpath. Thismust go first in the classpath, not at the end.
      
      Here is an example: java.class.path={application.home}/runtime/servers/lib,
      {application.home}/runtime/../../src,{application.home}/lib/cfusion.jar,
      {application.home}/runtime/pointbase/lib/pbclient42RE.jar,
      {application.home}/runtime/pointbase/lib/pbembedded42RE.jar,
      {application.home}/runtime/pointbase/lib/pbserver42RE.jar,
      {application.home}/runtime/pointbase/lib/pbtools42RE.jar,
      {application.home}/runtime/lib/webservices.jar,
   4. Restart the ColdFusion process. From thecf_root/runtime/bin directory, run./coldfusion restart
3. Use the ColdFusion MX Administrator Data Source page to add a new data source for the Sybase jConnect driver.
   
   For example:
4. 1. Enter a name for the data source.
   2. Select Other in the driver field to tell ColdFusion you will describe another type of driver.
   3. Click Add to add the data source and display the default driver window for this driver.
5. Enter the following in the JDBC URL field:
   
   jdbc:sybase:Tds:db_server:port_no/database_name
   
   Where db_server is the name of the database server.
   
   Where server_port is the port number for the data source connection (the Sybase default port is 5000).
   
   Where database_name is the name of the database you want to use.
   
   For example:
   
   jdbc:sybase:Tds:ps-db:5000/training_dept
   
   Note: The information in this field is case-sensitive.
6. Enter the following in the Driver Class field:
   
   com.sybase.jdbc2.jdbc.SybDriver
   
   Note: The information in this field is case-sensitive.
7. (Optional) Enter the name of the driver in the Driver Name field.
8. Enter a valid username and password in the Username and Password fields.
   
   Where the username and password are defined as user account information on the database server.
9. Click submit to apply the changes to the data source.

Additional Information

• ColdFusion MX: Trailing space in Driver Class field causes data source verification failure (TechNote tn_18612)
• ColdFusion MX: Configuring the Oracle JDBC thin driver (TechNote tn_18344)

Products affected