Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
SunilChauhan
Esteemed Contributor

Connecting to Database

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

4 Replies
adhudson
Contributor II

Re: Connecting to Database

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
Esteemed Contributor

Re: Connecting to Database

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

Highlighted
adhudson
Contributor II

Re: Connecting to Database

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
Esteemed Contributor

Re: Connecting to Database

thanks for your reply

let me check and reply you.