how to use DSN to connect database in C#?

Dear Friend,

Thanks for your reply...... I'll work out that...

Regards

Dinusha

Hi, First you need to create DSN which connects to SQL Server and use that DSN in your C# application.

System DSN uses ODBC which is a wrapper for OLE DB, means a lot of unnecessary overhead. The .Net System.Data.SqlClient classes talk directly to the SQL Server, without having to use OLE DB OR ODBC. Instead, you need to figure out how to build your Connection correctly.
    If you want to connect to DB2 database by using DSN see: http://msdn2.microsoft.com/en-us/library/ms945575.aspx