ODBC Data source Connection Oracle Database sample

Configuring an ODBC data source
1. Select Microsoft ODBC for Oracle

2. Data Source Name: Connection string name/user name: Database name (SID name)/server name: Database server IP Address

Using System.Data.Odbc;

private void Monitorbatch ()
{
    string contection = ' dsn=dsn_name; Uid=username; Pwd=password; "
    OdbcConnection conn = new OdbcConnection (contection);
    Try
    {
        Conn. Open ();

        String sql = @ "Select Send_date, send_sts from MASTER WHERE send_date < To_char (sysdate, ' YYYYMMDD ') and send_sts = ' 0 ' and ID <? ORDER by send_date ";

        OdbcCommand command = conn. CreateCommand ();
        Command.commandtext = SQL;
        Command. Parameters.Add ("", OdbcType.Int). Value = m;

        OdbcDataReader reader = command. ExecuteReader ();
        if (reader. HasRows)
        {while
            reader. Read ())
            {
                Console.WriteLine (reader). GetString (0) + "" +reader. GetString (1));	
            }
        Command. Dispose ();
        Reader. Close ();
    }
    catch (Exception ex)
    {
	Console.WriteLine (ex. Message)
    } finally {
        conn. Close ();
    }
}