Your choice will also determine available features.For more information about which JAR file to choose, see System Requirements for the JDBC Driver. If you want to use it, you must set the classpath to include the file, sqljdbc4file, the sqljdbc41file, or the sqljdbc42file.
Some servlet/JSP engines provide setup screens that you can use to set the classpath of the engine.
In that situation, you must append the correct JDBC Driver JAR file to the existing engine classpath and restart the engine.
If you suspect these types of issues, you should temporarily move the file, sqljdbc4file, or the sqljdbc41file into a simple directory name such as The classpath is configured in the operating system.
Append sqljdbc.jar, sqljdbc4.jar, or sqljdbc41to the classpath of the system.
See Upgrade Data Direct Sequelink ODBC Server to version 5.4 and Cold Fusion MX 7.0 and 7.0.1: Hot fix available for Seque Link 5.4 Socket server.61315 - SQL Server - CFQUERY INSERT does not return a query object (resultset) when the table contains an IDENTITY type column.
With 3.3 drivers included with 7.0 and 7.0.1, the query object returned would contain the identity key value and could be referenced with normal #Query. Cold Fusion MX 7 Multiserver Configuration loads the JDBC drivers in macromedia_in /jrun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib.
The Microsoft JDBC Driver 4.1 for SQL Server provides sqljdbc.jar, sqljdbc4.jar, and sqljdbc41class library files to be used depending on your preferred Java Runtime Environment (JRE) settings.
The Microsoft JDBC Driver for SQL Server 4.0 provides and sqljdbc4class library files to be used depending on your preferred Java Runtime Environment (JRE) settings.
Configuration requires adding to the JDBC URL through the "Connection String" field.