Connection to Oracle works through a console application and doesn't work through a web service

I can't connect to an Oracle schema through a asmx web service instead of I can through a console application [x86].

The code:

var conn = new OracleConnection("Data Source=xe;User ID=mySchema;Password=myPass");

The exception:

ORA-12154: TNS:could not resolve the connect identifier specified

The environment: Windows 7 x64 - VS 2008.

Any idea?

kindly ask me for any extra information

Thanks in advance.

Solution

OCI, the Oracle client layer on which ODP (or the native Oracle client layer) is based has a bug that prevents any application located in a folder containing parentheses () from running properly

This bug is very visible since the apparition of the Program Files (x86) folder...

The host running your application (typically IIS) is probably located in the x86 folder, hence the issue. Your console app works fine because it's probably located in a folder that does not have the issue.