Oracle Connectivity Data

1. Source Code

String connstring = "User Id=scott; Password=yanhong;data source= (DESCRIPTION = (address_list= (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)) (C Onnect_data = (service_name = yanhong))) ";
OracleConnection conn = new OracleConnection (connstring);
Try
{
Conn. Open ();
OracleCommand com=new OracleCommand ("SELECT * from EMP", conn);
DataSet ds=new DataSet ();
OracleDataAdapter ODA = new OracleDataAdapter (COM);
Oda. Fill (DS);
Datagridview1.datasource = ds. Tables[0];
MessageBox.Show (Conn. State.tostring ());
}
catch (Exception ex)
{
MessageBox.Show (ex. Message.tostring ());
}
Finally
{
Conn. Close ();
}

2. "BadImageFormatException is raised when attempting to load the Oracle client library." This problem occurs if you are running in 64-bit mode with the 32-bit Oracle client component installed. Problem

Workaround:

Change the target platform for project properties to 64-bit

Oracle Connectivity Data