TechNote: Using The SQL Server 2005 JDBC Driver With ColdFusion

I blogged an entry about SQL Server 2005 Express at http://myxomatosis.colebarksdale.com/client/index.cfm/2006/7/5/SQL-Server-2005-Express-and-CFMX . It looks like the Adobe technote is for SQL Server 2005, not express. So there's the link if you need it.

Why should I use this JDBC driver instead of the SQL driver that comes with standard Coldfusion ?

Will this JDBC driver also work with SQL Server 2005 Express?

Has there been any internal talk of performance improvements using this driver?

Good lord! Finally! Thanks for posting this Ben!

For questions of type: "Why should I use JDBC driver...". You should use it because this is dedicated MSSQL 2005 driver. You should use it to not ask later "Why this is not woring correctly with my MSSQL 2005..."

>>Why should I use this JDBC driver instead I'm not sure about the 1.0 version but, with the CTP v1.1 MS adds support for mirrored databases.

Same question as Mikkel and Sami, is it worth it to change my datasources from the packaged SQL Server driver? Are there any noticeable performance increases?

Some of these comments about driver and SQL-2005 versions are somewhat confusing. Maybe this is more specific: Microsoft released "Microsoft SQL Server 2005 JDBC Driver 1.0" on 1/19 and released the 1.1 version on 6/26. Both drivers work with SQL2005 and SQL2005 Express. The Adobe TechNote was written on 8/2, but references a link to the older 1/19 Microsoft download. But Adobe's instructions are the same for configuring either JDBC release to work with coldfusion. So either version of the JDBC driver will work with any version of SQL2005, with the same Adobe instructions.

Thanks For Posting Bem, Great Job