I have installed 12C clien in my window 7 64 bit developer laptop. Following Alex's vedio presentation for managed code beta release, I can make my web service work successfully with Oracle 10g database. The I deployed the web service to window 2003 64 bits R2 server. The server has no managed code instalation but oracle 10g client. It has no issue to connect to Oracle server and database.
I did following.
1: Has Oracle.ManagedDataAccess.ddl under web service bin directory.
2: Have tnsnames.ora in the same folder as web.config
No addtional set up and service works fine.
But, I do have an issue for the same application in window XP develoer desktop. The machine has Oracle client 11 installed. No managed code installation. I have OracleDataAccess.dll copied to lib folder of the application and refrecne it from VS 2010 project of the web service. I then have the tnsnames.ora file in everywhere of the application, such as under bin, lib, application root, debug, release .. When I run, I got error:
Oracle.ManagedDataAccess.Client.OracleException: Network Transport: Unable to resolve connect hostname ---> OracleInternal.Network.NetworkException: Network Transport: Unable to resolve connect hostname
The issue seems that the app could not locate tns entry but don't know how to fix it.
Alex, any recommendation to resolve this issue?