topic Re: OLEDB Connection in QlikView

OLEDB Connection

md_qlikview — Mon, 21 Jul 2014 18:07:59 GMT

Hello All,

How do i make connection to oracle sql developer using OLEDB connection?

What are the things that i need to consider?

Thanks In Advance

Re: OLEDB Connection

Mon, 21 Jul 2014 18:15:04 GMT

Hello MD_Qlikview,

Do look into the link provided and i hope it helps.

SQL Consulting | Connect SQL Developer to Oracle Database -

Re: OLEDB Connection

Anonymous — Mon, 21 Jul 2014 18:31:44 GMT

Hello,

First of all you have to install the oracle client in your pc, doing so you will then see the oledb driver for oracle in QV.

http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip?AuthParam=1405028558_66462920a9da875b73204f9013bacf5d

Then you have to put the TNSNAMES.ora file in the network folder for the client installation to be able to establish the connection.

Re: OLEDB Connection

Tue, 22 Jul 2014 04:27:39 GMT

Please follow the steps mentioned in the attached file

Re: OLEDB Connection

sasikanth — Tue, 22 Jul 2014 04:43:11 GMT

HI,

three thing you should know,

Driver details,

Server name,

User name ,

Password,

and then follow the above document by Agasti,,

Re: OLEDB Connection

Anonymous — Tue, 22 Jul 2014 05:02:10 GMT

Hello

You need to create 1st DSN entry which gives you connection details.In DSN entry you need to provide Server name,User name and password.After providing all this information click on test coneection button.Which show connection are succeeded.

Re: OLEDB Connection

Tue, 22 Jul 2014 06:08:32 GMT

Please refer below details for the OLEDB in oracle

http://docs.oracle.com/cd/A91202_01/901_doc/win.901/a90171.pdf