c# | create connection to oracle database odbc c#

Just a Web Code Solution

Step 1. Your question relates to:

Step 2. Type a keyword:

how do I create a connection to oracle database with odbc using C# ?

156

using System;
using System.Windows.Forms;
using System.Data.Odbc;

namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
string connetionString = null;
OdbcConnection cnn ;
connetionString = "Driver={Oracle in OraClient12Home1};Dbq=xxx;Uid=xxx;Pwd=xxx";
// or connetionString = "Driver={Oracle in OraClient12Home1_32bit};Dbq=xxx;Uid=xxx;Pwd=xxx";
cnn = new OdbcConnection(connetionString);
try
{
cnn.Open();
MessageBox.Show ("The connection is open!");
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show("The connection is refused!");
}
}
}
}