QlikView test database connection fails but succeeds via ODBC data source administrator

[#1]

Hi all,

I'm really at my wits' end why this error occurs. Basically, I'm trying to connect to Oracle DB via ODBC. I created the configuration via ODBC datasource administrator and it worked when I tested the connection.

However, at QlikView, once I tested the connected, the QlikView application hung and prompted "Connection Failed". I attached the word doc for you reference.

May I know why this happens?

[Anonymous]

Is it System DSN or User DSN?  You should use System.

The checkbox "force 32 bit" is not checked, that means you're using 64.  Make sure your Oracle client and ODBC admin are all 64-bit.  If they are 32, check the box.

Regards,

Michael

PS: What about using OLEDB instead?

[#3]

Hi Michael,

I got my administrator to re-create under system DSN.

I also checked the "force 32 bit" as my system is 32bit.

However, I still face the same problem. Test connection via ODBC datasource administrator tested ok.

[#4]

I found out the reason why.

Reason is I downloaded oracle 10g client and that version was not meant for windows 7?

I redownloaded oracle 11 client and it worked for me.