How to use EZCONNECT format without sqlnet.ora file for deployment

Question

I have developed a windows forms Application which talks to an Oracle Server. I am using ODP.net and deploying using the bare minimum dlls, as given in the solution to this Question

I wish to connect using teh connection string in EZCONNECT format, but I can't use it unless the method is present in sqlnet.ora file(As documented here) But given my deployment, I don't have the oracle client installed, or an Oracle home. How do I enable EZCONNECT format?

Or is there some other way to connect when deploying ODP.net applcations?

Seems like I was mistaken in assuming that it doesn't work. The documentation I had linked to was incorrect. It does work, when you use the EZCONNECT format, out of the box!! — Devdatta Tengshe
– Devdatta Tengshe, Commented Jun 23, 2011 at 15:17

DCookie · Accepted Answer · 2011-06-17 18:51:17Z

1

Specify the directory location of your sqlnet.ora file in an environment variable named TNS_ADMIN. The location does not have to be in an "oracle home" per se.

edited Jun 17, 2011 at 18:51

answered Jun 17, 2011 at 12:47

DCookie

43.7k11 gold badges88 silver badges93 bronze badges

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

Comments

Christian Shay · Accepted Answer · 2014-03-07 20:31:33Z

0

The doc isn't exactly wrong, it just does not specify that it means "the SQLNET.ORA in the Database Oracle Home". It is not referring to the ODP.NET oracle home on the client side.

answered Mar 7, 2014 at 20:31

Christian Shay

2,63315 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to use EZCONNECT format without sqlnet.ora file for deployment

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related