topic Oracle provider missing in QlikView

Oracle provider missing

Mon, 25 Nov 2013 03:23:04 GMT

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?

Re: Oracle provider missing

agni_gold — Mon, 25 Nov 2013 07:07:40 GMT

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

Regards,

Agnivesh Kumar

Re: Oracle provider missing

agni_gold — Mon, 25 Nov 2013 07:21:17 GMT

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 .

Re: Re: Oracle provider missing

Mon, 25 Nov 2013 09:34:31 GMT

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.

Re: Re: Oracle provider missing

agni_gold — Mon, 25 Nov 2013 09:36:28 GMT

there is no screenshot friend.

Re: Re: Re: Oracle provider missing

Mon, 25 Nov 2013 10:01:10 GMT

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

PFA

Thanks & Regards

Murali krishna

Re: Re: Re: Oracle provider missing

agni_gold — Mon, 25 Nov 2013 10:09:06 GMT

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

Re: Oracle provider missing

aveeeeeee7en — Mon, 25 Nov 2013 10:58:08 GMT

Which Server are you using.

Re: Oracle provider missing

aveeeeeee7en — Mon, 25 Nov 2013 11:17:30 GMT

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.

Re: Oracle provider missing

Mon, 25 Nov 2013 11:48:11 GMT

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.

Re: Oracle provider missing

VishalWaghole — Tue, 26 Nov 2013 07:50:29 GMT

Hi Murali,

1st Check whether your Operating System is 32bit or 64bit and also check whether you

installed Oracle is 32bit or 64bit

If your Operating System is 64bit and you installed 32bit Oracle then

make select check box for Force 32 bit, You will find this checkbox ODBC.

Thanks and Regards,

Vishal Waghole

Re: Oracle provider missing

Anonymous — Tue, 26 Nov 2013 20:38:02 GMT

Murali

I find it better to install the full Oracle Client rather than just the ODBC part.

Best Regards, Bill

Re: Oracle provider missing

Anonymous — Tue, 08 Apr 2014 08:52:29 GMT

Fabio, which OLEDB Driver did you install for Postgres?