Free Programming Tutorials & Source Code

Function to connect to an Oracle server using C#.

Add the Odbc Namespace:

using System.Data.Odbc;

        protected void connect_to_oracle()
        {
            string strConn= @"server = myServer;uid = user;password = tiger;";

            OdbcConnection conn = new OdbcConnection(strConn);
            try
            {
                conn.Open();
                MessageBox.Show("Connection opened.");
              
 
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                         }
            finally
            {
                conn.Close();
                MessageBox.Show("Connection Closed");
            }


        }