ODBC error using valid connection....

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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