topic Re: Connect to oracle 11g in QlikView

Connect to oracle 11g

SunilChauhan — Mon, 01 Oct 2012 07:14:14 GMT

hello All,

I am facing problem after connection successful to Oracle DataBase.

after connecting when i select the Select Button.then it making clear the connection string

inplace of popup window for select.

is there any setting Required.Please suggets

Sunil

Re: Connect to oracle 11g

kamalqlik — Mon, 01 Oct 2012 08:30:40 GMT

Hi Sunil,

I am not getting.

Let me guess,you have made the DSN successfully.OK.

In qlikview you are able to connect with that DSN credential ie datasouce username and password.But when you are going for select button you are not getting the result for all the tables.

This may be because you may be not connected to the databse right now.

Try to make other new DSN.

Regards

Kamal

Re: Connect to oracle 11g

SunilChauhan — Mon, 01 Oct 2012 08:42:34 GMT

Hi Kamal,

Thanks for you reply

i have try at 10 times to create new dsn.But no success.

I thing dsn is not an issue .i think some setting required while creating Dsn.

or timeout issue.

Sunil

Re: Connect to oracle 11g

kamalqlik — Mon, 01 Oct 2012 08:45:21 GMT

Hi Sunil,

So when you are making a new connecion string .You are successfully able to do that with same credentials

Regards

Kamal

Re: Connect to oracle 11g

SunilChauhan — Mon, 01 Oct 2012 08:49:14 GMT

yes But Not able to select tables.

Please suggest.

Sunil

Re: Connect to oracle 11g

kamalqlik — Mon, 01 Oct 2012 08:51:23 GMT

Hi Sunil,

Go to the Data Sources in Control pannel and check that whether there is driver for oracle installed or not.

Other case may be that it is not getting the path specified for the Datasource you have specified.

So you have to contact with your database administrator.

regards

Kamal

Re: Connect to oracle 11g

SunilChauhan — Tue, 02 Oct 2012 05:12:11 GMT

thanks kamal,

i will try and let you know

Re: Connect to oracle 11g

SunilChauhan — Wed, 03 Oct 2012 06:08:55 GMT

Hi kamal,

Thanks for your Reply .

I have use OleDB connection.

its working for me now.