AdobeStock_455007340

TechNote: Using The SQL Server 2005 JDBC Driver With ColdFusion

10 responses to “TechNote: Using The SQL Server 2005 JDBC Driver With ColdFusion”

  1. Sami Hoda Avatar
    Sami Hoda

    Good lord! Finally! Thanks for posting this Ben!

  2. Sami Hoda Avatar
    Sami Hoda

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

  3. Michael De Jonghe Avatar
    Michael De Jonghe

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

  4. Mikkel Johansen Avatar
    Mikkel Johansen

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

  5. Cole Barksdale Avatar
    Cole Barksdale

    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.

  6. Joe Mastroianni Avatar
    Joe Mastroianni

    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?

  7. J Enters Avatar
    J Enters

    >>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.

  8. Radek Avatar
    Radek

    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…"

  9. Tom K Avatar
    Tom K

    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.

  10. Gavy Avatar
    Gavy

    Thanks For Posting Bem, Great Job

Leave a Reply