Connection String Question - SQL Server 2005

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

Hi MA2005:

I think the following information probably can help you:

http://www.connectionstrings.com/?carrier=sqlserver2005

Some connection string key words may have many equivalents though they produece the same result.

|||

The default driver is SQL Server -not necessary to state the driver when access a SQL Server.

[Initial Catalog] and Server mean virtually the same thing.
[Data Source] and Database mean virtually the same thing.
Trusted_Connection and [Integrated Security] mean virtually the same thing.
[True] and [Yes] in some context are symnomous.

|||Thanks for the input, but in what scenarios do we specify the driver? or not? Although you mentioned that specifying true or yes are symnomous, where do they differ? The link you provided has different conn string types, but doesnt give more in depth details on the different scenarios? Thanks in advance.|||

What are the differences in using the following connection types for SQL Server access?

1) SQL Native Client ODBC Driver

2) SQL Native Client OLE DB Driver

3) SQLConnection (.NET)

|||

Perhaps these sources will help you with your questions:

What's in an ADO Connection String?
http://www.asp101.com/articles/john/connstring/default.asp

ADO Connection Strings
http://www.sqlmag.com/Article/ArticleID/39603/sql_server_39603.html