topic Re: ODBC error using valid connection.... in QlikView

ODBC error using valid connection....

Tue, 21 May 2013 16:25:14 GMT

Hi all,

I've set up an ODBC connection to an Oracle 11g database and can test the connection using the ODBC Admin Tool.

However, in Qlikview when I try to use the connection using 'Connect..' it presents me with the DSN but when I use it I get this error

Connection Test Failed

SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

The other day I did get further and managed to connect enough to put some table SELECTs in the script but then on execution they failed with a similar error.

Any ideas on this?

Thanks

Gary Revell

Re: ODBC error using valid connection....

Gysbert_Wassenaar — Tue, 21 May 2013 16:33:04 GMT

You're using a 32-bit odbc driver with a 64-bit Qlikview or a 64-bit odbc driver with a 32-bit Qlikview. That in itself isn't fatal with a 64-bit Qlikview but when you do things like that you need to specify CONNECT32 instead of just CONNECT.

Re: ODBC error using valid connection....

Tue, 21 May 2013 20:19:34 GMT

Hi Gysbert,

Thanks for the answer. I unclicked the Force 32 bit and that enabled me to connect & browse the tables in the schema. However, when I try to execute a simple SQL SELECT then I get another ODBC error...

Oh well, I'll have a look at some of my .qvws on my old laptop and suss it out.

Best regards

Gary