topic Re: Connecting to Database in QlikView

Connecting to Database

SunilChauhan — Thu, 11 Oct 2012 06:27:56 GMT

hello all,

i am able to connect Database to Oracle but its asking each time password while connecting to Oledb connection.

Please suggest.

Thanks In Advandce

SKC

adhudson — Thu, 11 Oct 2012 06:48:55 GMT

Hi,

In QlikView Script, Have you mentioned User ID and Password in the connection string?

And don't forget to set PERSIST INFO=YES in it.

Hope this helps.

Regards

Andrew Hudson

SunilChauhan — Thu, 11 Oct 2012 07:28:30 GMT

Thanks for your Reply.

yes username and password available but

where to put persist Info PERSIST INFO=YES

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=User;Data Source=Ipadress/servicename] (XPassword is AHfPFGVIBSUOF);

Please suggest

adhudson — Thu, 11 Oct 2012 07:36:02 GMT

Hi,

Try this connection string.

OLEDB CONNECT32 TO [Provider=MSDAORA.1; PERSIST INFO=YES; User ID=User;Data Source=Ipadress/servicename] (XPassword is AHfPFGVIBSUOF);

SunilChauhan — Thu, 11 Oct 2012 08:22:14 GMT

thanks for your reply

let me check and reply you.