4

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.

Fen Ignacio
  • 111
  • 1
  • 1
  • 7
  • are you using a TNSNames file at all? – Simon Price Sep 25 '17 at 14:48
  • 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 Sep 25 '17 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 Sep 25 '17 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 Sep 25 '17 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 https://www.connectionstrings.com/oracle/. – MarkL Sep 25 '17 at 15:01
  • @MarkL sorry, that was a typo. I've been trying to do the strings in the oracle reference since this morning, but no luck. – Fen Ignacio Sep 25 '17 at 16:00

1 Answers1

4

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

Fen Ignacio
  • 111
  • 1
  • 1
  • 7