I get prompted to enter the password during every reload. How can I avoid this?
Configure ODBC DSN so it contains the password. Or use password in your script.
at Script Editor, configure your ODBC connection, see image below:
this will create a connection string in your script
Thank you so much! It worked.
Retrieving data ...