Hi,
I am running Oracle.ManagedDataAccess, Version=4.121.2.0, and I am trying to use a local tnsnames.ora (i.e. place the file in the working directory of the executable).
This works ok for exe applications, as the tnsnames.ora is picked up successfully. However if running from IIS or IIS express, the tnsnames.ora file is not picked up from the bin folder. I had to place it under C:\Windows\System32\inetsrv to make it work which is not ideal.
I ran ProcMon and it seams that the tnsnames.ora file is found in the bin folder, but the client refuses to use it for some reason, throwing an ORA-12514 error when connecting. Also if I manually point TNS_ADMIN in the web.config to the same bin folder then it works as well, which is more bizarre. I think there must be a bug in the client.
I have checked the machine.config and there is no overriding TNS_ADMIN. I haven't specified any data sources in the web.config either.
Do you guys have any idea?
Thanks