S
Stevek
Hello all,
I have a spreadsheet that has a number of queries. The queries connect to a
SQL database via an ODBC connection. The ODBC Connection uses a common SQL
Username and Password. When I refresh the queries the ODBC connection
prompts me for the password for each query. I cannot use a trusted
connection because multiple people will use the spreadsheet. How do I get
the ODBC Connection to remember the password? Or is this even my problem?
Best Regards
Steve K.
I have a spreadsheet that has a number of queries. The queries connect to a
SQL database via an ODBC connection. The ODBC Connection uses a common SQL
Username and Password. When I refresh the queries the ODBC connection
prompts me for the password for each query. I cannot use a trusted
connection because multiple people will use the spreadsheet. How do I get
the ODBC Connection to remember the password? Or is this even my problem?
Best Regards
Steve K.