Solved! Go to Solution.
using Oracle.DataAccess.Client; internal void Main() { //CREATE QUERY string sql = BuildSQL(); //CREATE A SQL COMMAND OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; OracleConnection conn = new OracleConnection(); try { //OPEN THE CONNECTION conn.ConnectionString = "Data Source=<network alias>;User Id={0};Password={1}"; conn.Open(); //ASSIGN THE CONNECTION TO THE COMMAND cmd.Connection = conn; //SET THE DATA ADAPTER FOR THE COMMAND AND FILL A DATASET OracleDataAdapter da = new OracleDataAdapter(cmd); Dataset _dataset = new DataSet(); da.Fill(_dataset); //DO SOMETHING WITH THE DATASET } catch (OracleException ex) // Catch Oracle errors { switch (ex.Number) { case 12545: MessageBox.Show(@"The database is unavailable"); break; case 1017: MessageBox.Show(@"ORA-1017:" + Environment.NewLine + @"Invalid username/password; logon denied"); break; case 01013: MessageBox.Show(@"Query cancelled by user."); break; default: MessageBox.Show(@"Database error: " + ex.Message); break; } } catch (Exception ex) { MessageBox.Show(ex.ToString); } finally { //CLEAN UP conn.Close(); conn.Dispose(); }
internal bool VerifyOracleClient() { try { Assembly.Load("Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"); return true; } catch (Exception) { MessageBox.Show(@"Your computer must have Oracle Client installed in order to use this application." + Environment.NewLine + @"Click OK to exit.", @"My Add-In"); return false; } }