ASP.NET Impersonation causes ORA error
I have an ASP.NET Web application that executes queries on an Oracle Database. The queries work fine until we turned impersonation on in ASP.NET and now anytime it tries running the queries it fires an ORA-12638: Credential Retrieval Failed error. When we run a query against a a SQL Server 2000 DB, it runs fine, the only issue is with Oracle. For some reason it seems as if the user in which the query is being executed is making a difference, which doesn't make sense since the only credentials that should matter are the ones passed in the connection strings, which are never changed. Any ideas?