Question revised:

Hi folks,

I have to connect to an oracle db 9.2 that is on a sun sparc through windows 2003 server. I downloaded all the odbc drivers. I can connect to the database with the oracle client software. However, I need to create a odbc connection in C# to the DB. Anyone can help me or point me to a sample application. I would really appreciate it.


Knowledge is to be shared.

__________________
Knowledge is to be shared.

string connectionString = " "; //Enter the connection string.
System.Data.Odbc.Connection connection = new System.Data.Odbc.OdbcConnection(connectionString);
System.Data.Odbc.OdbcCommand command = new System.Data.Odbc.OdbcCommand;

command.Connection = connection;
System.Data.Odbc.OdbcDataAdapter adapter = new System.Data.Odbc.OdbcDataAdapter(command);
adapter.SelectCommand.CommandText = ""; //enter the sql select command string.
System.Data.DataSet dataSet = new DataSet();
adapter.Fill(dataSet);