Connecting with Oracle Database fails

Question

Code:

private void Button_Click_6(object sender, RoutedEventArgs e)
{
    TimerView tobj = new TimerView();
    tobj.Show();
    string OracleServer = "Data Source=(DESCRIPTION="
+ "(ADDRESS=(PROTOCOL=TCP)(HOST=DLDT-0897.nectechnologies.in)(PORT=1521))"
+ "(CONNECT_DATA=(SERVICE_NAME=XE)));"
+ "User ID=system;Password=abc@1234;";
     public bool Open()
{
    try
    {
        conn = new OracleConnection(OracleServer);
        conn.Open();
        return true;
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
    return false;
}

Error in conn.Open():

Warning 1 There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "Oracle.DataAccess, Version=4.112.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342, processorArchitecture=AMD64", "AMD64". This mismatch may cause runtime failures. Please consider changing the targeted processor architecture of your project through the Configuration Manager so as to align the processor architectures between your project and references, or take a dependency on references with a processor architecture that matches the targeted processor architecture of your project. WpfApplication

sounds like the 2 projects are configured for different architecture. Your app appears to be x86, while the oracle reference is x64 — Takarii
Please check your code's formatting. Currently it makes it hard to read. There also seems to be a compiler error regarding the Open method within the click handler. — Stefan

Patrick Hofman Patrick Hofman · Accepted Answer · 2016-09-21T06:59:19

The ODP.NET package comes in two flavors: one for 32 bits programs and one for 64 bit programs. You have to pick one when you compile since else you might end up in trouble when running the program. So you have to switch from MSIL to 32-bits mode preferably (to support both processor architectures). You need to include the 32-bits version of ODP.NET then (now you are using 64-bits).

A better option might be to use the managed ODP.NET library, which supports both processor architectures since it doesn't depend on OCI any more. You can find the latest version here.

Connecting with Oracle Database fails

1 Answers