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 a开发者_开发知识库n Oracle home. How do I enable EZCONNECT format?
Or is there some other way to connect when deploying ODP.net applcations?
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.
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.
精彩评论