Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sathish_expo
Contributor

Architecture error while connecting oracle 11g from Qlikview

Hi all,

I installed and created listener for oracle 10g and I had created a USER DSN in ODBC Administrator.

Now while Connecting it from my Qlikview Application it is showing the error as shown in the below screen shot Error.png

What may be the issue????

16 Replies

Re: Architecture error while connecting oracle 11g from Qlikview

Either you're using a 32-bit ODBC driver with a 64-bit QlikView or vice-versa. Install the correct driver for your architecture.

BTW Oracle 11g or Oracle 10g?

Peter

brijesh1991
Valued Contributor

Re: Architecture error while connecting oracle 11g from Qlikview

Peter Cammaert is right. . .

preminqlik
Valued Contributor II

Re: Architecture error while connecting oracle 11g from Qlikview

got the same prblem with ODBC......connect through OLEDB ...solved

gupta_n8
Valued Contributor II

Re: Architecture error while connecting oracle 11g from Qlikview

Check with the installed Oracled ODBC driver ,

Is it 32 bit or 64 one,

If its 32 bit driver the check the Force 32 bit check box and try again connecting it.

sathish_expo
Contributor

Re: Architecture error while connecting oracle 11g from Qlikview

we are using 64 bit ODBC dreiver .oracle11g.

MVP
MVP

Re: Architecture error while connecting oracle 11g from Qlikview

Hi,

Try using

select Force 32 bit check box


below the ODBC dropdown.


Regards,

Jagan.

MVP
MVP

Re: Architecture error while connecting oracle 11g from Qlikview

Hi

from the Tools Menu of Qlikview script editor try to define a new ODBC SYSTEM DSN (you can see 32 bit and 64 bit odbc, choose 64 if you have 64 bit oracle client) and test odbc connection; does it works?

Regards

Not applicable

Re: Architecture error while connecting oracle 11g from Qlikview

Prueba esa cadena pero antes cambia el server..

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=admsit;Data Source=BCRDESA;Extended Properties=""] (XPassword is HPLUWZFMDDZKWZFMSC);

sathish_expo
Contributor

Re: Architecture error while connecting oracle 11g from Qlikview

Hi I tried by selecting force 32 bit check box it is displaying the same error


Community Browser