ODP with Instant Client
I am working on a windows application that uses ODP and I also want to use the Oracle 11g ODAC 11.1.0.6.21 with Xcopy Deployment for the clients. I have run the install batch file with the "all" command and used the defaults, then I added the paths to the windows system path varible. I want to use the EZCONNECT connection string. I keep reading the following :
"All you need to do is add/modify this to your sqlnet.ora
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
And now you can use the following syntax to connect
sqlplus user/password@//host:[port]/service name"
but I do not see this in the XCOPY deployment instructions. Am I missing something? Do I need to create this sqlnet.ora file and where does it get put if it is needed. Or is it needed at all?
Can someone please explain to me about this. It would be much appreciated.
Steve Graddy MCP, MCAD.Net
Orgbrat Consulting