Oracle Connection in C# - connection string

Question

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.

Also, have you hand coded your connection string or have you gone through a wizard to build the connection string up and tested your connection? — Simon Price
– Simon Price, Commented Sep 25, 2017 at 14:48
Add a try catch block around the open() call and resolve the ORA error that shows up in the OracleException — too_cool
– too_cool, Commented Sep 25, 2017 at 14:50
@CodeWarrior I went through the wizard and was actually able to successfully connect to the db. The connection string I'm using is from the db properties in the server explorer. — Fen Ignacio
– Fen Ignacio, Commented Sep 25, 2017 at 15:00
Your string concatenation is going to result in "PERSIST SECURITYINFO=True", which is incorrect and I believe will result in an error, if this isn't just a typo on your post. A correct connection string depends on what provider you are using and which options you are using, see connectionstrings.com/oracle. — MarkL
– MarkL, Commented Sep 25, 2017 at 15:01

Fen Ignacio · Accepted Answer · 2017-09-25 16:32:24Z

5

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

answered Sep 25, 2017 at 16:32

Fen Ignacio

1411 gold badge1 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hồ Thế Trung · Accepted Answer · 2024-01-23 10:19:18Z

1

ConnectionString Oracle : "User Id=userName;Password=...;Data Source= localhost/mypdb"

answered Jan 23, 2024 at 10:19

Hồ Thế Trung

111 bronze badge

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Fernandezaginer · Accepted Answer · 2024-07-05 07:37:37Z

1

I managed to connect with this string:

//using Oracle.DataAccess.Client;
    
OracleConnection con = new OracleConnection("User Id=username;Password=xxxxxxxxxx;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=host.net)));")
        
con.Open();

answered Jul 5, 2024 at 7:37

Fernandezaginer

214 bronze badges

Collectives™ on Stack Overflow

Oracle Connection in C# - connection string

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related