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

[Miguel_Angel_Baeyens]

Hi,

You can use ODBC instead and store the user and password in it, so you are not prompted each time you reload the script or connect, unless your Oracle security does require you to do. Although I never tried with OLE DB, you can also store passwords there, so the connection string has the password scrambled, and therefore not prompting each time you reload.

Hope that helps.

Miguel