Oracle Connection in C# - connection string

19,798

My code is now working. I should've read the Oracle documentation (reference below).

string connString = "DATA SOURCE=10.204.3.1:1521/PROD;" +
"PERSIST SECURITY INFO=True;USER ID=username; password=password; Pooling 
=False;";

OracleConnection conn = new OracleConnection();
conn.ConnectionString = connString;
conn.Open();

Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/appdev/dotnet/Web_version_Fully_Managed_ODPnet_OBE/odpnetmngdrv.html

Share:
19,798
Admin
Author by

Admin

Updated on June 04, 2022

Comments

  • Admin
    Admin almost 2 years

    I'm currently trying to build an application in C# and connecting it to a live db running in Oracle 11g. I have the following connection details

    Host IP: 10.204.1.3 
    Port: 1521
    DB Name: PROD
    

    My source code

    string connString = "DATA SOURCE=10.204.1.3:1521/PROD;PERSIST SECURITY" +
    "INFO=True;USER ID=username; PASSWORD=userpass";
    OracleConnection conn = new OracleConnection(connString);
    conn.Open();
    

    I was able to add a connection in Server Explorer with the Connection String used by VS but is having the error below in conn.Open();

    An unhandled exception of type 'System.NullReferenceException' occurred in 
    Oracle.DataAccess.dll
    

    Sorry if this is a basic question, I'm new in VS, and Oracle and can't find the solution in the other part of the web. Thanks in advance.