Skip to main content
O
OceanParkDude
Participant
November 17, 2015
Question

odbc sql server 2014 coldfusion 11 mismatch error

  • November 17, 2015
  • 1 reply
  • 484 views

I have installed 64 bit versions of SQL server express 2014 and ColdFusion 11 developer edition 64 bit in a Windows 8.1 machine that never had earlier versions of these applications installed.  I successfully created the SQL Server ODBC driver (64 bit) in Windows.  I then tried to create in ColdFusion the ODBC Socket connector.  It recognized the existence of the Windows ODBC configurations (it was in the drop down box).  Yet when I tried to complete the process I got the following error message:

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application

The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application

Thank you in advance for any help!

    This topic has been closed for replies.

    1 reply

    Carl Von Stetten
    Carl Von Stetten
    Legend
    November 28, 2015

    You should not have to use the ODBC driver to connect to SQL Server.  The built-in Microsoft SQL Server driver should work fine with SQL Server Express.

    -Carl V.

    S
    Steve Sommers
    Legend
    November 30, 2015

    Yes, use the built in Microsoft SQL Server driver.

    The original CFMX (CF6 I believe) used JDBC-->ODBC-->MS-SQL and it was V.E.R.Y...S.L.O.W.! I would be afraid that using an ODBC socket connector would set you back to the slow days of CF. I have not found any disadvantage of using the native Microsoft SQL Server driver.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices