Oracle ASP.NET impersonation

[Emily]

Here's my setup: I am using EF v1, dotConnect for Oracle (latest), and ASP.NET. I want to use Integrated Windows Authentication and pass those credentials to Oracle (Linux).

When I first created my EF model, EF threw this into the .config file:

Code: Select all

This is a general account. When I deploy my application, I want to use WIndows Authentication to send over those credentials to Oracle. How can I do that? I'm assuming I have to edit my connectionString?

This works fine if I have Windows Authentication set to off (unchecked) and I can perform all CRUD, but now I want impersonation in place and thus when I turn WIndows Authentication on, my queries fail.

[AndreyR]

In case you have Oracle OS Authentication configured correctly, the only thing you need to get this to work is to remove User Id and Password entries from the connection string, like this:

Code: Select all