SQL Server 2005 Connection Strings.....Some Important Queries

[vijay victory]

Hi Experts, I m using SQL Server 2005. I have some queries..PLEASE HELP I m using following Connection String

strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");

My Queries are : 1> What is the Actual use of "Provider"?? 2> What is the difference between "Provider" and "Driver"?? 3> I can connect to Database with using Provider or Driver. By using only "Data Source/ Server" and other parameters then Why to use Provider or Driver? 4> IF I Different Provider like 'SQL Native Client' then Can this increase my SQL Server Connection performance?? Please HELP.. ITs Urgent for Me..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

[Lost User]

A list of providers[^] can be found here[^]. As you see, both ODBC and OleDb are providers. You can connect to SQL Server using these providers because they speak SQL Servers' dialect. These two providers are "generic", and they can handle multiple database-formats. The native SQL Client provider was written specific for SQL Server. Yes, this should be somewhat faster :)

I are Troll :suss: