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
.NET ProgrammingSybase DatabaseDatabases

Avatar of undefined
Last Comment
triphen

8/22/2022 - Mon
it_saige

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

-saige-
ASKER CERTIFIED SOLUTION
triphen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
it_saige

I was just about to recommend that as well.  ;)

-saige-
triphen

ASKER
I found my issue. It was the Target CPU setting.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck