error when trying to establish connection

[anuradhaa]

Facing the below error when trying to establish connection with Oracle10 client.

SQL##f - SqlState: IM004, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

I have 64 bit qlikview desktop version and 32 bit oracle client

[avinashelite]

Try with Force 32 connection in Qlikview script

[Anonymous]

Agreed with Avinash, try with Force 32 Connection.

See the attachment..

[Anonymous]

Check this as well?

The Great ODBC Confusion

Some clarification around the 32-Bit & 64-Bit usage with Qlik Sense

how to connect in oracle database? | Qlik Community

[JoaquinLazaro]

Hi anuradhaa

Maybe you should install the Oracle ODBC driver

Hope this helps you

Joaquín

[chrisjbishop]

Hi, if using the 32bit connection does not help then try using the Oracle odbc driver as suggested.

The error message suggests that you are using the Microsoft odbc driver.

Good luck.

[anuradhaa]

I'm using Oracle ODBC driver 32bit version and my Qlikview is 64 bit

[anuradhaa]

I'm using Oracle ODBC driver 32bit version and my Qlikview is 64 bit

[maxgro]

Me too I have a 64 bit QlikView and a 32 bit Oracle driver

It works: flag the Force 32 bit in the script editor as already suggested

[anuradhaa]

doesn't work.