Skip to main content
A
ARPAdmin
Participant
August 18, 2010
Question

JDBC error trying to connect to MS SQL Express 8 on WIN7-64-Home

  • August 18, 2010
  • 1 reply
  • 929 views

Having a problem connecting even though the DSN connects properly when setup in the ODBC control panel.

Using socket in Coldfusion Administrator the following error occurs:

Connection verification failed for data source: FMDesk4
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

Do I need to use another driver as the internal MS SQL driver will also not connect?

William Maliepaard

This topic has been closed for replies.

1 reply

Owainnorth
Owainnorth
Inspiring
August 18, 2010

Certainly I'd fancy my chances far better with the built-in MSSQL driver than I would ODBC, there are many untold issues with cross-architecture ODBC connections.

Can you connect to the SQL instance using Management Studio? Most of the time these are issues by something silly like TCP connections not being enabled in SQLServer rather than an issue with CF or JDBC.

O.

A
ARPAdminAuthor
Participant
August 19, 2010

Thanks you hit the nail on the Head - with all the new security built

into the system you now have to enable TCP IP connection to MS SQL and

remember to stop and start the service (which was another couple of

hours as it did not warn you....)

Thanks for the response.

William.

Owainnorth
Owainnorth
Inspiring
August 19, 2010

Glad to hear you got it sorted

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