How to connect to ORACLE DB without oracle client or tnsname

c# oracle console-application tnsnames dbconnection
jen123 picture jen123 · Nov 4, 2015 · Viewed 8.1k times · Source

Is there any way to connect to Oracle DB without installing oracle client or using tnsname ? The application needs to be deployed on client machine ,hence want it to be INDEPENDENT.

Answer

Hambone picture Hambone · Nov 4, 2015

To clarify on my comment, this is possible with the Managed ODP.net from Oracle, which does not require the client machine to have any Oracle clients/drivers installed. It's perfect for Windows or console applications where you can't control the software that's installed on the target machines.

To download the managed client, you can get it from nuget using the Library Package Manager (https://www.nuget.org/packages/odp.net.managed/):

PM> Install-Package odp.net.managed

With regards to TNSnames (since that is also a client dependency), if you use Oracle's EZ Connect, you can bypass TNSnames completely. To do this, you simply format your data source as server-name:port/sid. I actually stopped using TNSnames completely ever since this became available.

Here is an example of how you can do this with Managed ODP.net:

OracleConnectionStringBuilder sb = new OracleConnectionStringBuilder();
sb.DataSource = "MyOracle.MyCompany.com:1521/MySid"; // EZ Connect -- no TNS Names!
sb.UserID = "luke";
sb.Password = "Jedi4Eva";

OracleConnection conn = new OracleConnection(sb.ToString());
conn.Open();

OracleCommand cmd = new OracleCommand("select * from dual", conn);
object o = cmd.ExecuteScalar();

conn.Close();

Related questions

The provider is not compatible with the version of Oracle client

I'm trying to use the Oracle ODP.NET 11g (11.1.0.6.20) Instant Client on my ASP.net project as a Data Provider but when I run the aspx page I get a "The provider is not compatible with the version of Oracle …

Read More
How to execute an .SQL script file using c#

I'm sure this question has been answered already, however I was unable to find an answer using the search tool. Using c# I'd like to run a .sql file. The sql file contains multiple sql statements, some of which are …

Read More
this is error ORA-12154: TNS:could not resolve the connect identifier specified?

I've this code : OracleConnection con = new OracleConnection("data source=localhost;user id=fastecit;password=fastecit"); con.Open(); string sql="Select userId from tblusers"; OracleCommand cmd = new OracleCommand(sql, con); OracleDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { messageBox.Show(dr[0].Tostring()); } …

Read More