ODBC Password

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top