Different connection strings. What to use? -- dotnet faqs

R.A.
3/25/2004 11:26:44 AM

I think that the first uses DSN and the second uses direct SQL server
connection. In the first you have to create the DSN name on the machine, and
on the second you just need to point to the SQL server name. I prefer the
second one.

Regards

[quoted text, click to view]

Erik Cruz
3/25/2004 12:06:34 PM

Hi.

I have seen ado.net samples using two different connection strings for sql
server:

"data source=local;initial catalog=northwind;integrated security=sspi"

or

"server=(localhost);database=northwind;trusted_connection=true"

I can see that they do the same things, but what are the real differences
between them? Is it recommended to use the former or the later?

TIA,
Erik Cruz

dotnet faqs : Different connection strings. What to use?