Welcome! and rules
Joel on Software
What is the ODBC DSN counterpart in .NET?
What offers ADO.NET to use instead of ODBC DSN?
I stopped using DSN's a while ago even in classic ASP sites.
Assuming you've downloaded the ODBC ADO.NET provider, there are several ways to specify what ODBC data source to use. The docs list them all. I use the DSN. For example, I have a connection string of the form:
Unless you are locked into using a data source that doesn't provide OLE DB or a native provider for .NET, you should probably at all cost avoid ODBC. All it will do is add a couple more layers of code to run through before it reaches your database. When going with the SQL provider for example, it is basically Your App -> SQL Provider -> Sql Server. With ODBC it would be Your App -> ODBC Provider -> SQL ODBC Driver -> Sql Server. Omph.
Tip: for a convenient list of typical ADO.NET connection strings, go to
Bernard Vander Beken
Fog Creek Home