Link to home
Start Free TrialLog in
Avatar of triphen
triphen

asked on

ODBC error on 64bit mahcine

Hello Experts,

I released a new build of my application and now on 64bit machines I am getting this error:


ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

This was working fine on my last build and I didnt really change anything that has to do with the ODBC or anything like that.



        'Look for SQL Engine
        Try
            Dim str As String = "DSN=sqlbase;uid=dba;pwd=password;"
            Dim con As New OdbcConnection(str)
            Dim com As String = ("select company from sysinfo")
            Dim Adpt As New OdbcDataAdapter(com, con)
            Dim ds As New DataSet()
            Adpt.Fill(ds)
        Catch ex As Exception
            MessageBox.Show("SQL Engine not running! Closing application.  " & ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            End
            Exit Sub
        End Try

Open in new window



SyBase SQL Anywhere v10
VB.net VS2010
Avatar of it_saige
it_saige
Flag of United States of America image

You need to install 32-bit versions of the SyBase drivers on the 64-bit clients.

-saige-
ASKER CERTIFIED SOLUTION
Avatar of triphen
triphen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I was just about to recommend that as well.  ;)

-saige-
Avatar of triphen
triphen

ASKER

I found my issue. It was the Target CPU setting.