topic error when trying to establish connection in QlikView

error when trying to establish connection

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: error when trying to establish connection

avinashelite — Fri, 04 Mar 2016 07:35:47 GMT

Try with Force 32 connection in Qlikview script

Re: error when trying to establish connection

Anonymous — Fri, 04 Mar 2016 07:39:18 GMT

Agreed with Avinash, try with Force 32 Connection.

See the attachment..

Re: error when trying to establish connection

Anonymous — Fri, 04 Mar 2016 07:40:32 GMT

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

Re: error when trying to establish connection

Joaquin_Lazaro — Fri, 04 Mar 2016 07:47:50 GMT

Hi anuradhaa

Maybe you should install the Oracle ODBC driver

Hope this helps you

Joaquín

Re: error when trying to establish connection

chrisjbishop — Fri, 04 Mar 2016 07:55:56 GMT

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.

Re: error when trying to establish connection

anuradhaa — Fri, 04 Mar 2016 08:38:42 GMT

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

Re: error when trying to establish connection

anuradhaa — Fri, 04 Mar 2016 08:38:51 GMT

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

Re: error when trying to establish connection

maxgro — Fri, 04 Mar 2016 08:41:24 GMT

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

Re: error when trying to establish connection

anuradhaa — Fri, 04 Mar 2016 08:47:50 GMT

doesn't work.

Re: error when trying to establish connection

anuradhaa — Fri, 04 Mar 2016 08:51:15 GMT

see attached

Re: error when trying to establish connection

Joaquin_Lazaro — Fri, 04 Mar 2016 08:56:18 GMT

Read this https://community.oracle.com/thread/876335?tstart=0

Maybe you should create a new connect sentence using the wizard in order to test the DSN configuration

Re: error when trying to establish connection

avinashelite — Fri, 04 Mar 2016 10:17:35 GMT

have you added the connection in DSN ?? Go to Script editor > Tools> configure 32 > select the Oracle driver > add the username and other details > test the connection and then use the connection wizard from the script i.e data

Try to use the OLEDB connection

Re: error when trying to establish connection

ravishankarqv — Fri, 04 Mar 2016 10:26:28 GMT

Hi Anu,

I think, it is nothing to do with QlikView.

You need to configure your Environment Variables properly. Make sure your Oracle path details configured properly. If that configured properly, check do you have right permissions for oracle client/ driver. If issue still not resolved, speak to your system admin or oracle DBA/Admin, they will resolve it quickly.

HTH

Ravi