Showing posts with label catalogxxxdata. Show all posts
Showing posts with label catalogxxxdata. Show all posts

Thursday, 8 March 2012

conn string

What is the impact of the differences in the following 2 connection strings:

Initial Catalog=xxx;Data Source=xxxxxx;Trusted_Connection=True;

Driver={SQL Server};Server=xxxxx;database=xxx;Trusted_Connection=yes;

To outline the differences I'm concerned with are

Missing Driver on first string

Difference in Trusted_Connection parameter (true vs. yes)

Initial Catalog vs. database parameter

See my response in the [SQL Server Data Access] forum.

You may also find this url a useful resource: www.connectionstrings.com