Oracle provider missing

[#1]

Hi All,

I want to connect to a oracle database server.When I open edit script and click on connect I can not see 'Microsoft OLEDB provider for oracle' in the providers list.Do I need to configure or install something to get this provider?

[agni_gold]

You can use ODBC database for oracle connction and please share your screen shoot to understand your problem

Regards,

Agnivesh Kumar

[agni_gold]

http://www.oracle.com/technetwork/database/windows/downloads/index-096177.html

download ODBC driver from ablove link and create a DNS for your database to be connect.

and after this try to connct using ODBC in qlikview .

Hope this will help you .

[#4]

Hi Agnivesh,

Thanks for your response.

PFA screenshot in which I am using OLEDB connection.Here I can not find any provider to connect to oracle.

[agni_gold]

there is no screenshot friend.

[#6]

Agnivesh,I have added the attachment earlier however I am adding again

PFA

Thanks & Regards

Murali krishna

[agni_gold]

Sorry friend i am not able to find any attachment ,

any way tell me some answer about your machine :

1:  Is Oracle is installed on your machine.

2:  Go to directory C:\Program Files\Oracle\Product\11.0\   is ODBC folder is present ?

3: If u r not able to see in OLEDB  so u can try ODBC with making  a DNS

[aveeeeeee7en]

Which Server are you using.

[aveeeeeee7en]

There are 2 ways to Connect to the database:

1. Create a ODBC system DSN and Test it. The connection made should be Successful.

2. Create a Connection String. Steps: Go to Edit Script of Qlikview than select Database OLEDB from Dropdown option click Connect Button and than choose"Microsoft OLE DB Provider for SQL Server". After this go to Next, choose or write the server name than add Credentials or click Windows Authentication. Final Step, Click on the Test Connection. It should display the Message Successful.

Hope it works.

[#10]

Hi Murali, I needed install providers (64-bits) for Postgres and MySQL because they not exists in standard installation. I believe that same was happening with you and Oracle. You must find correct provider for your machine and install it. This must resolve.

Regards.