| || |
Passing username/password for dbConnect
Is there any way to pass username/password to an ODBC connection using dbConnect? I am using and ODBC driver that requires the password to be entered each time it is accessed and there is no way of saving the password in the DSN setup. I tried setting up a file dsn entry(this allowed me to save the password by editing the file using notepad) but when I try to call it using the dbConnect command, it comes back and says that there is not such connection.
Re: Passing username/password for dbConnect
Never mind about the above post. I figured out that if you format the dbconnect command like this:
It works even thought QARun colors everything past the first ';' as if it was commented out.