开发者

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

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜