DSN Connection

However, you can connect to an sqlserver using an OdbcConnection instead of an SqlConnection.
You simply create the connetion like this :

OdbcConnection connection = new OdbcCOnnection("DSN=the_name_of_your_dsn")

can u pls pass any examples/Sample code???

public DataSet SelectOdbcSrvRows(DataSet dataset,string connection,string query)
{
    OdbcConnection conn = new OdbcConnection(connection);
    OdbcDataAdapter adapter = new OdbcDataAdapter();
    adapter.SelectCommand = new OdbcCommand(query, conn);
    adapter.Fill(dataset);
    return dataset;
}

public void ReadMyData(string myConnString) {
   string mySelectQuery = "SELECT OrderID, CustomerID FROM Orders";
   OdbcConnection myConnection = new OdbcConnection(myConnString);
   OdbcCommand myCommand = new OdbcCommand(mySelectQuery,myConnection);
   myConnection.Open();
   OdbcDataReader myReader;
   myReader = myCommand.ExecuteReader();
   // Always call Read before accessing data.
   while (myReader.Read()) {
      Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
   }
   // always call Close when done reading.
   myReader.Close();
   // Close the connection when done with it.
   myConnection.Close();
}

These are all from the .NET Reference Documentation in the System.Data.Odbc section.

can u pls send me the url if u hv???? u told that ".NET Framework reference documentation"

"From the .NET Framework reference documentation :

Note   The .NET Framework Data Provider for SQL Server uses its own protocol to communicate with SQL Server. Therefore, it does not support the use of an ODBC data source name (DSN) when connecting to SQL Server because it does not add an ODBC layer."

If you have the .NET SDK installed then you alreday have this documentation on your computer.
To open the documentation check your start menu (assuming you are using a version of windows that has one and that you have .NET 1.1) :

Start -> All Programs -> MS .NET SDK 1.1 -> Documentation

If you don't have this, check :

c:\Program Files\Common Files\Microsoft Shared\Help\dexplore.exe

You can run it from a command line like this :

c:\Program Files\Common Files\Microsoft Shared\Help\dexplore.exe /helpcol ms-help://MS.NETFrameworkSDKv1.1/sdkstart/html/sdkstart.htm

If ytou do not have the .NET SDK installed I seriously recommend that you get it :

http://www.microsoft.com/downloads/details.aspx?FamilyId=9B3A2CA6-3647-4070-9F41-A333C6B9181D&displaylang=en

It is quite a big download.

If you can't get all that right now, the whole of the reference documentation is available online :

Here is a link to System.Data.Odbc :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataOdbc.asp?frame=true

Please grade this question.

Please grade this question.