Page 1 of 1

AD Authentication to Oracle

Posted: Wed 06 Oct 2010 16:50
by Emily
I can't seem to connect my application that runs on Windows Server that is accessed via the web (ASP.NET MVC) to an Oracle instance that runs on Linux.

I have the following in the web.config:

Code: Select all

<add name="ProjectEntities" connectionString="metadata=res://*/XModel.csdl|res://*/XModel.ssdl|res://*/XModel.msl; provider=Devart.Data.Oracle; provider connection string='Server=PROD;Persist Security Info=True'" providerName="System.Data.EntityClient" />
<authentication mode="Windows" /> 
I also disabled Anonymous Access on ISS and checked Windows Authentication.

I even tried trying to set and kept on getting 'provider failed to open' message.

My application works if I include credentials in the connection string. I can even log onto that server and use SQL*Plus to try /@PROD and that works.

Am I able to do this with your Oracle dotConnect?

Posted: Thu 07 Oct 2010 17:08
by Shalex
OS Authentication in the OCI mode of dotConnect for Oracle should work. We will investigate the issue.
1. Is there any internal exception?
2. Please try connecting to Oracle using OS Authentication via OracleConnection class (create a simple console application, create the OracleConnection class, set its connection string as "Server=PROD;", and call Open()). Does it work?