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

this error occured when i ran batch job for importing data from ODBC

Capture

solution for this is add CLIENT on class identifier to make the code run on 32Bit and match the ODBC driver . example :
Capture

Advertisements

4 thoughts on “error : [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

  1. Can you give more info about this solution?

    I tried but my code is not running.

    My issue is like this – AX server run on 64 bit, other db on 32. When i try to connect to other system with 32bit DSN it gives me that error.

      • my class was intended for Batch purpose.

        so after i modified the identifier to client. then i did incremental CIL.

        i dont know why it’s not working for you.
        maybe you should check the ODBC driver on batch or AOS server itself , make sure it is on 32Bit.
        like example below :

        but for me, it solved the error and ran without problem.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s