TechNote (Archived)

ColdFusion MX: Configuring the Microsoft SQL Server 2000 JDBC driver

This TechNote describes how to configure Macromedia ColdFusion MX to use the Microsoft JDBC Type IV driver to connect to Microsoft SQL Server 2000 databases. This driver is distributed by Microsoft and is available for download to all licensed SQL Server 2000 customers at no charge.

Configuring ColdFusion MX to use the Microsoft SQL Server JDBC driver

1. Download the driver from Microsoft.
2. Install the driver. By default, this installs in C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC on Windows platforms.
3. In the ColdFusion Administrator, click on the "Java and JVM" page. Add the directory in which the mssqlserver.jar resides to the Class Path field. By default, this is C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib on Windows platforms.
4. Click Submit Changes to update Java and JVM Settings for ColdFusion MX.
5. Restart the ColdFusion MX Application Server service. Note: On Unix platforms, from the cf_root/runtime/bin directory, run coldfusion restart.
6. Use the ColdFusion Administrator Data Sources page to add a new data source for the Microsoft JDBC driver:
   For example:
   1. Name the data source ps_db where it will connect to the server named ps-db where MicrosoftSQL Server resides.
   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.
7. Enter the following in the JDBC URL field:
   
   jdbc:microsoft:sqlserver://ps-db:1433;DatabaseName=NorthWind
   
   Where ps-db is the name of the database server.
   
   Where 1433 is the port number for the data source connection.
   
   Where NorthWind is the database you are connecting to.
   
   Note: The information in this field is case-sensitive.
8. Enter the following in the Driver Class field:
   
   com.microsoft.jdbc.sqlserver.SQLServerDriver
   
   Note: The information in this field is case-sensitive.
9. 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.
10. (Optional) Enter the name of the driver in the Driver Name field.
11. 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 (18612)
• ColdFusion MX: Configuring the Sybase jConnect 5.5 driver (18591)
• ColdFusion MX: Enabling a JDBC data source for PostgreSQL (18338)
• ColdFusion MX: Configuring the Oracle JDBC thin driver (18344)

Search Support

---