I have successfully set up ODBC connection strings from my C# application to a DB2 database and to excel spreadsheet using DSN
DB2 connection string= "DSN=MyDSNname; UID=Myname; PWD=Mypassword;"
EXCEL Connection string = "DSN= MyDSNName; Data Source=C:\MySpreadSheet.xls; HDR=yes; Format=xls;"
I now need to create an ODBC connection to a MS SQL 2010 database using a DSN. Can anyone please tell me the format of this connection string ?