Regarding Connection Between Oracle and Alteryx using Odbc 32 bit

[PiyushJain]

Hi Team,

I am trying to connect Alteryx with oracle using 32 bit ODBC connector, but getting error.

I followed couple of vedios and blogs,but still my issue remain same.

Error: IM014[ Microsoft] "ODBC Driver Manger

The specified DSN contains an architecture mismatch between the driver and application "

Request you to please provide step by step Solutions. 

Few information/ Doubts ( Refer Below):

1. Alteyx  Version : 2020.1.5 ( Alteryx Designer x64)

2. I am not sure whether with this version i can connect with oracke ODBC 32 bit connector. 

If yes ,then please provide step by step details.

If not then,please provide how to connect with 64 bit ODBC.

Currently i have Oracle "oraclient12 Home1_32 bit "

Oracle setup.

Also please provide driver details.. in both case ( 32 bit and 64 bit).

Please let me know if you need more information.

Regards 

Piyush Jain

[BrandonB]

You might find that the "Quick Connect" option is easier that uses OCI. Driver information can be found here: https://help.alteryx.com/current/designer/oracle

It sounds like you are trying to use a 32 bit driver when you should in fact be using a 64 bit driver. 

[BrandonB]

This is also a very helpful article that covers all of the different ways that you can connect to Oracle with Alteryx: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas...

[PiyushJain]

Thanks Brandon,

As per my investigation the issue occurred because of environmental variable .

After providing correct details, i am able to connect with Oracle using 64bit ODBC driver.

I will keep below information ( provide by you) for my reference. 

Thanks once again.

Regards 

Piyush J

[MarianBalta]

Hi,

Could yo please give some details on how you have fixed this? I am having the same problem - Oracle 32bit client with 32bit ODBC connection working OK, but same error when used in Alteryx. Is there a way to connect without installing the 64bit ODBC Driver?

Thanks.

[apathetichell]

@MarianBaltathis thread is 5 years old. You must use a 64 bit ODBC driver. That is not optional.