ODBC Password - SQL Server

  • Thread starter Thread starter Steve Andrews
  • Start date Start date
S

Steve Andrews

When I set up an ODBC Connection with SQL Server,how can I
get the password to be saved so that the user isn't
prompted every time they open the linked SQL table?
 
Steve Andrews said:
When I set up an ODBC Connection with SQL Server,how can I
get the password to be saved so that the user isn't
prompted every time they open the linked SQL table?
Click to expand...

When you create the links there is an option to save the password as part of the
connection string. This can be disabled on the server though. Have you thought
about using integrated security instead? Then the password is a non-issue.
 
Back
Top