topic Re: QlikView Odbc in QlikView

QlikView Odbc

marksmunich — Mon, 27 Jul 2015 07:45:04 GMT

Hello Qlik's,

I have made a DSN entry in ODBC Administrator. I have also installed Oracle Odbc driver on my system. But i fail to see this new DSN in Qlikview ODBC connect.

Any Suggestions.

Thanks

Re: QlikView Odbc

qlikviewwizard — Mon, 27 Jul 2015 08:32:22 GMT

Hi marksmunich

Could you provide the error screen?

Re: QlikView Odbc

qlikviewwizard — Mon, 27 Jul 2015 08:33:11 GMT

Please provide the steps you have followed. It will help us give the right and quick fix. Thank you.

Re: QlikView Odbc

awhitfield — Mon, 27 Jul 2015 08:33:33 GMT

HI Mark,

ensure you that you have the correct option set for 'FORCE 32 Bit' and the you have SHow User DSns checked if applicable.

HTH - Andy

Re: QlikView Odbc

elyM — Mon, 27 Jul 2015 08:33:34 GMT

Hi,

maybe your QlikView installation is 32 bit on Windows 64 bit and your DSN is configured in 64bit driver?

Regards

Re: QlikView Odbc

vardhancse — Mon, 27 Jul 2015 08:40:43 GMT

Hi,

Enable force 32-bit(Check box) in script editor.

Data<Tab>->Under Data base

Re: QlikView Odbc

marksmunich — Mon, 27 Jul 2015 08:50:18 GMT

Thanks Andrew. It worked. But why force 32Bit. My OS is 64Bit, QV is 64Bit and Driver is also 64 Bit. Any explanation for this ?

Re: QlikView Odbc

awhitfield — Mon, 27 Jul 2015 08:52:41 GMT

If this needed to be checked on, then sounds like you have created a 32bit odbc connection by mistake.

Andy

Re: QlikView Odbc

marksmunich — Mon, 27 Jul 2015 09:00:09 GMT

ok. will check it. anyways thanks once again.

Re: QlikView Odbc

Anonymous — Mon, 05 Oct 2015 13:30:36 GMT

As an addition to correct answer here is a useful link to Oracle ODBC connection and configuration guide

You may use this Oracle ODBC driver for that purpose