Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

marksmunich
Contributor II

QlikView Odbc

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

M

Tags (1)
1 Solution

Accepted Solutions
awhitfield
Esteemed Contributor

Re: QlikView Odbc

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

9 Replies
Arjunarao
Honored Contributor II

Re: QlikView Odbc

Hi marksmunich

Could you provide the error screen?

Arjunarao
Honored Contributor II

Re: QlikView Odbc

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

awhitfield
Esteemed Contributor

Re: QlikView Odbc

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

ely_malki
Contributor

Re: QlikView Odbc

Hi,

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

Regards

vardhancse
Valued Contributor II

Re: QlikView Odbc

Hi,

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

Data<Tab>->Under Data base

marksmunich
Contributor II

Re: QlikView Odbc

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 ?

awhitfield
Esteemed Contributor

Re: QlikView Odbc

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

Andy

marksmunich
Contributor II

Re: QlikView Odbc

ok. will check it. anyways thanks once again.

M

admin1
New Contributor III

Re: QlikView Odbc

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 

Community Browser