Microsoft SQL OR JDBC database driver

[umuayo]

Hello,
My Network Server Admin guy just sent me this:

"I have added the JDBC driver, however I want to confirm prior to changing the xxxxxx datasource to use the JDBC driver.
You would like us to change from the Microsoft SQL driver to the JDBC database driver?"

Question is , Which database driver does MX 7 use in connecting to MS SQL Server 2005?

Presently it looks like we use Microsoft ODBC driver, do we change to JDBC and why?

Thanks

[LL]

To confirm what version of the JDBC drivers you are using, run this code:
<cfset jdbcDriver = CreateObject("java", "macromedia.jdbc.sqlserver.SQLServerDriver")>
<cfoutput>
JDBC version = #jdbcDriver.getMajorVersion()#.#jdbcDriver.getMinorVersion()#</p>
</cfoutput>
3.5 are the latest JDBC drivers available for ColdFusion MX
The Adobe drivers can be found here: http://www.adobe.com/go/42dcb10a
The Microsoft JDBC Driver can be found here
The TechNote for this can be found here: http://www.adobe.com/go/ded4216b