1

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?

Community
  • 1
  • 1
Devdatta Tengshe
  • 4,015
  • 10
  • 46
  • 59
  • 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 Jun 23 '11 at 15:17

2 Answers2

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.

DCookie
  • 42,630
  • 11
  • 83
  • 92
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.

Christian Shay
  • 2,570
  • 14
  • 24