Designer 64bit ODBC drivers missing

[julien.pierre]

I'm having an issue accessing a 64bit ODBC driver from the Designer.
By default the deisgner loads all 32bit drivers.

Missing64BitDrivers.PNG (17.18 KiB) Viewed 3073 times

I have even tried to build the sample targetting x64 platform to see if it was going to force to look into the 64bit ODBC driver, but no success.

So I have tried to use the 64bit driver in the designer, but I'm getting the following error

MismatchError.PNG (15.11 KiB) Viewed 3073 times

Can you help please.

[Alex K.]

Hello,

The topic from the following link:
http://dacosta9.wordpress.com/2011/10/2 ... plication/

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Did you create a DSN, but your application cannot access the DSN?
I created a DSN, but could not connect via SSIS. It seems that the DSN I created was 64-bit, while the application I was using (SSIS) could only connect to 32-bit DSNs.

After some research I have realized that there are two different ODBC Administrator runtimes on a 64-bit machine.

The first ODBC Manager is used to manage 64-bit data sources, while the second is used to manage 32-bit data sources.

If you are running a 32-bit Operating System, you will have only 32 bit drivers installed. If you are using a 64 bit machine, the default ODBC Manager will be for 64-bit data sources.

Use this ODBC Manager to Review 64-Bit Data Source Names

c:\windows\system32\odbcad32.exe

Use this ODBC Manager to Review 32-Bit Data Source Names

c:\windows\sysWOW64\odbcad32.exe

If you are trying to access a DSN in your application and receive the error “ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application” check to see if you have a DSN configured for the architecture of your application ( 32-bit / 64-bit ).

I create my DSNs twice – once for 32 bit architecture and once for 64 bit architecture. My naming convention is as follows:

DSN_NAME_64 created using c:\windows\system32\odbcad32.exe
DSN_NAME_32 created using c:\windows\sysWOW64\odbcad32.exe

References: http://msdn.microsoft.com/en-us/library ... 85%29.aspx

Thank you.

[julien.pierre]

Hi Alekey,

Thanks for your reply.

When I'm on a 64bit PC, I cannot install the 32bit ODBC drivers, and therefore I cannot create a DSN from c:\windows\system32\odbcad32.exe, the driver is not listed!
However, I can create a DSN from c:\windows\sysWOW64\odbcad32.exe.

Everything is fine when I run the WPF designer on a 32bit PC, because the designer will load the 32bit ODBC drivers.
But the problem is that the WPF designer does NOT load 64bit drivers on a 64bit PC!

Any ideas?

Regards,
Julien

[Alex K.]

Hello,

We couldn't reproduce this bug.

Thank you.