On Windows 2008 R2 MYSQL ODBC Connection

Hi Experts,
I have MySQL installed on Windows XP 32Bit machine.
Installed the MYSQL ODBC connector 5.1.6 64Bit on Windows 2008R2 X64
Created the DSN for the same and try to use it
        Dim myConnectionString As String
        myConnectionString = "Dsn=snr;uid=fkt_test;pwd=fkt_test;MultipleActiveResultSets=true;"
        Try
            Dim conn As New System.Data.Odbc.OdbcConnection(myConnectionString)
            conn.Open()
        Catch ex As Exception
            Response.Write(ex.Message)
            Exit Sub
        End Try
I am getting error message "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

I have tried with MYSQL ODBC 32 bit version too.

Please guide me how to do the setup so can use in my web application. Same dsn work in windows 2003R2 32 Bit, Vista 32Bit etc.

Thanks
Mehul
MKPanchalAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TeethingConnect With a Mentor Commented:
See this link for setting up a 32bit ODBC connection:

http://support.microsoft.com/kb/942976/en-us
0
 
MKPanchalAuthor Commented:
Thanks Teething,
It works perfectly ok, in 64Bit DSN does not show it. I have added DSN and it is working,
Thanks,
Mehul
0
All Courses

From novice to tech pro — start learning today.