Connecting to Oracle via Web Services

[Jeff]

Has anyone had any success connecting to an Oracle database from a web
service? We have some Oracle code that works fine when ran directy (i.e.
referencing the DLL directly instead of a web service). However, when we
call the same method from a web service the "Open" fails.

Anyone have any ideas?

--- Thanks, Jeff

[AlexB]

I use oracle all the time in my ASP.NET applications. I
use the OracleClient, which you can download from
Microsoft's OleDB site. I've never used it with a
webservice but I can't imagine why it wouldn't work.

Good luck.

-----Original Message-----
Has anyone had any success connecting to an Oracle database from a webservice? We have some Oracle code that works fine when ran directy (i.e.referencing the DLL directly instead of a web service). However, when wecall the same method from a web service the "Open" fails.

Anyone have any ideas?

--- Thanks, Jeff
.

[Jeff]

> I use oracle all the time in my ASP.NET applications. I

use the OracleClient, which you can download from
Microsoft's OleDB site. I've never used it with a
webservice but I can't imagine why it wouldn't work.

We are using the Oracle Client as well. I was able to solve the problem
based on a suggestion from another post (in the CSharp newsgroup). I added
an impersonation account and configured the "<identity>" tag to read the
encrypted logon credentials from the registry. This resolved the issue.
I'm still not sure why Oracle required this step and MS SQL Server did not
but I'm happy to have it working.

--- Thanks, Jeff