OLEDB Connection

[md_qlikview]

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

[#2]

Hello MD_Qlikview,

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

                        SQL Consulting | Connect SQL Developer to Oracle Database -

[Anonymous]

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_66462...

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

[#4]

Please follow the steps mentioned in the attached file

[sasikanth]

HI,

three thing you should know,

Driver details,

Server name,

User name ,

Password,

and then follow the above document by Agasti,,

[Anonymous]

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.

[#7]

Hi

Please refer below details for the OLEDB in oracle

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