troubleshooting Question

Understanding ODBC bridge Authentication

Avatar of StampIT
StampITFlag for United States of America asked on
DatabasesMicrosoft Access* ODBCSQL
39 Comments2 Solutions155 ViewsLast Modified:
In an MS Access database I have tables linked from SQL Server via an ODBC bridge. The bridge is set up with SQL Authentication. However when I link a table to this Access database I can use either the SQL user name and password or Trusted Connection. Either way the table is accessible. The connection strings are below for the same table. Is this normal ? If the bridge is set up with SQL Authentication I thought that is the way the SQL tables had to be linked. Trying to understand how this works so I can set up other clients. Thanks.

ODBC;DSN=ERP_Data;Description=ERP Database;Trusted_Connection=Yes;APP=Microsoft Office 2016;;TABLE=dbq.ds_WrkCtr

ODBC;DSN=ERP_Data;Description=ERP Database;UID=ERP_dbq;;APP=Microsoft Office 2016;;TABLE=dbq.ds_WrkCtr
Join our community to see this answer!
Unlock 2 Answers and 39 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 39 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros