AcquireConnection method - DSN contains an architecture mismatch between the Driver and Application

Question

I am building a package programatically by loading an existing SSIS package (application.LoadPackage(...).  In the package that I am loading, I have set the project properties for Run64BitRunTime to false.  If I run this package by itself, it works just fine.  As the new package is building, the DataSource AcquireConnection method is called.  I then receive the error:  {"ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"}.  What is the appropriate setting for the C# project that builds the package.  Thanks.

Answer 1

You are using 64-bit odbcad32.exe to configure a DSN that connects to a 32-bit driver.

Use the 32-bit odbcad32.exe to configure the DSN.

Answer 2

As I mentioned, it works just fine in the base package, which contains the connection object to the ODBC data source.  Its only when I load this package programtically and add on to it does the error occur.

Answer 3

How did you run the base package?

Answer 4

Through the Visual Studio development environment

Answer 5

THIS IS NOT YOUR ANSWER....

to give you an idea how it works here is an good example ....

 

Because you can run a package in BIDS doesnt mean that it will work on production

i.e Assuming SQL2005 and yourbox and production box are both 64 bit

- a package with a Excel source file , will work on you station using BIDS (your box or computer is 64bit)

BUT setting the same package on production using a SQL job wont work because the default execution if to run the packages are a 64bit you have to redirect them to a 32 bit execution file .

SO Manikandan is rightyou are not using the right odbcad32.exe.

 

---

Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Answer 6

Are you using BIDS in 64 bit server?

Answer 7

The program that builds the package is running on my PC.  Its not the package execution that is the issue, its the programmatic package build.

Answer 8

My environment is Windows 7, just recently switched.  Used to work fine under XP

Answer 9

I solved the issue by changing the Platform target project setting from Any CPU to x86.

Answer 10

can you please provide more details. thanks you.

Sorry I clicked on this post as an answer, by mistake, sorry  

 

---

Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Answer 11

Yes, in Visual Studio, I went to Project Properties, then clicked on the Build tab.  I then selected x86 from the Platform Target drop down.  Remember this is a C Sharp project which is building a SSIS package (programatically).

Answer 12

Hi garysklar

Thanks for the reply; I think that you should select your post as a final answer.

Brilliant, good luck

 

 

---

Sincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Answer 13

Thank you Manikandan. This is the only thing that worked for me (changing the target to x86 did not help in Win7-64bit/VS2008/SQLExpress2008R2). I just created a duplicate 32bit SystemDSN for the existing 64bit DSN. In Win7 I found the 32bit odbc admin at:

C:\Windows\SysWOW64\odbcad32.exe

Answer 14

Hi Guys

In addtion to the answer,  given by  garysklar,  if you get this same error in BIDs itself while the SSIS packages,   you can set the below project property to false to make it work

Project properties -->  Debuging -->  Run64BitRuntime to False

Answer 15

I had the same issue...and used the same method as alhann...worked for me...Thanks

Answer 16

I did the same as well, changing the Run64BitRuntime to false.  That worked for me.  Is there any downside to this.  Is it throttling the entire project down to running as a 32 bit app?

Answer 17

please visit this link : Architecture mismatch issue resolve

---

Umair Baig www.webeasyforall.co.cc