Accessing Oracle Database from C#

Question

I have a C# program that uses System.Data.OracleClient to access an oracle database.

The code uses OracleCommand, OracleDataReader objects. And it uses the TNS names to refer to specific oracle servers (as defined in the tnsnames.ora file).

It runs fine on my computer. And then I copied the binary to another computer, and upon running it encounters the error:

TNS:could not resolve the connect identifier specified.

The other computer has the same version of oracle client installed, and the identical copy of tnsnames.ora dropped in the oracle network/admin folder. And the other computer also has SQLDeveloper installed, and I am able to connect to the oracle servers by using those TNS names from inside its SQLDeveloper.

Why then is the c# program complaining about not able to resolve TNS identifier?

The connection string I use (as hardcoded into my c# program) is ;

"Data Source=TNS Name; User ID=user; Password=pass;"

Thanks

I know this doesn't answer your question, but just as a FYI, System.Data.OracleClient is being deprecated. blogs.msdn.com/adonet/archive/2009/06/15/… — Russ
– Russ, Commented Jun 30, 2009 at 14:06

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Open a command window, type tnsping yourdbname and hit enter, you should get back a bunch of info, but what you want to look for is

Used parameter files:

C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora

Or something similar, this is the "Default" Oracle client on the system, make sure that this is the same path that you have the tnsnames.ora in (in my case we use sqlnet.ora)

Sometimes multiple Oracle product installs make multiple potential ORA_HOMEs, you can at least confirm the "active" client, so that way you are certain the files are in the right spot.

Also, can you connect to the db using SQLPlus?

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 30, 2009 at 14:06

curtisk

20.2k4 gold badges62 silver badges75 bronze badges

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

2 Comments

devio Over a year ago

agree with possibility of multiple homes

Gary.Ray Over a year ago

Great answer! Every time I have run into a similar problem it was either multiple homes in the path, or incorrect settings in sqlnet.ora.

JMarsch · Accepted Answer · 2009-06-30 14:01:51Z

0

Is it failing to locate or load the tnsnames.ora file? Try running ProcessMonitor (http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) and then running your c# program. You can see if it fails to locate the .ora file.

answered Jun 30, 2009 at 14:01

JMarsch

21.8k17 gold badges81 silver badges128 bronze badges

Comments

DCookie · Accepted Answer · 2009-06-30 17:25:43Z

0

You can also force all things Oracle to look in a fixed location for network files by setting the environment variable TNS_ADMIN to the location of your tnsnames.ora and sqlnet.ora files (by default ORACLE_HOME/network/admin).

Then you don't have to worry about guessing which network/admin folder is being used by the particular Oracle process you're running at the moment.

answered Jun 30, 2009 at 17:25

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

Comments

petah · Accepted Answer · 2018-05-14 20:55:50Z

0

Ultimately my issue was that I had multiple instances of Oracle installed on my machine, and needed to update a third tnsnames.ora file that I was not aware of.

For what it's worth, I got a false positive response when running tnsping [dbName]. It was useful information, but it needed further investigation. Only when I went to check Windows Environment Variables did I notice another Oracle path and found the third tnsnames.ora

answered May 14, 2018 at 20:55

petah

3504 silver badges13 bronze badges

Collectives™ on Stack Overflow

Accessing Oracle Database from C#

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related