I use connection strings to connect to SQL server and attach tables. For a while I used "SQL Server" such as:
This worked just fine. I could refer to the tables in code, and even just double click an attached table and see it.
Then it started giving me fatal connection errors. So I switched to using "SQL Server Native Client 11.0". That seemed to be better, but now when I double-click on a table, I need to manually click on "Trusted Connection". This happens whether or not I use "Yes" in the string above.
Help please!
Code:
ODBC;Driver={SQL Server};Server=SERVER-NAME;Database=DATABASE-NAME;Uid=USER-NAME;Pwd=PASSWORD;Encrypt=No;Trusted_Connection=No
This worked just fine. I could refer to the tables in code, and even just double click an attached table and see it.
Then it started giving me fatal connection errors. So I switched to using "SQL Server Native Client 11.0". That seemed to be better, but now when I double-click on a table, I need to manually click on "Trusted Connection". This happens whether or not I use "Yes" in the string above.
Help please!