Enter a password to connect to a database in the script

[#1]

Hello everyone,

I want to extract data from an oracle database. The problem is that each time I need to reload my application, a prompt opens up and I have to manually enter this password. (which makes impossible any planifications)

Is there a way to write the password directly into the script ?

[#2 · Accepted solution]

I managed to do it using OLEDB

Thanks all for your help