I'm trying to use "dbConnect" to connect to an Oracle database. I used dbConnect("DNS=MyDB").
When I execute the script an Oracle ODBC login box comes up prompting for a password. I don't want to have to type the password in. I tried to automate entering the password but script execution remains in the dbConnect function until the password is typed and ok button is clicked. So there is no way to execute the part of the code that enters the password into the edit control until dbconnect function is done. And there is no way to enter the password in the system DSN for an Oracle connection.