Connecting to Database

[SunilChauhan]

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]

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]

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]

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]

thanks for your reply

let me check and reply you.