Connection string for Oracle using Entity Framework and LDAP

Question

I have an ASP.NET 4.0 application that is using Entity Framework 4.3 to connect to Oracle database. Connection on a development environment is not a problem because we use the standard method. Connection string was generated by Visual Studio.

Problem is that on production and acceptance environments we have to use LDAP. I have verified connection and can connect using the LDAP from Oracle's SQL Developer.

I need a help with the syntax of connection string in the web.config. How it should look like? I was not be able to find any examples and on production and acceptance I don't have Visual Studio to see if it can generate something automatically.

Update:
I need syntax to change this connection string that is connecting to local Oracle Express to connection string that uses LDAP

<connectionStrings>
    <add name="VoccDbContext" connectionString="metadata=res://*/Entities.Vocc.VoccModel.csdl|res://*/Entities.Vocc.VoccModel.ssdl|res://*/Entities.Vocc.VoccModel.msl;provider=Oracle.DataAccess.Client;provider connection string=&quot;DATA SOURCE=localhost:1521;PASSWORD=somePassKey;PERSIST SECURITY INFO=True;USER ID=someUser&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

Do you mean you are using LDAP to do Windows Authentication? Or am I misunderstanding your question. Have you tried "user id=/" and "password=" (no password, and forward slash for user id) — Bob.
– Bob., Commented Jul 18, 2012 at 20:44
I didn't tried anything yet because I has to do this on acceptance env. which is already in use (application connects to SQL Server and Oracle and Oracle part of app is not working) and my time for experimenting is limited. — Robert Vuković
– Robert Vuković, Commented Jul 19, 2012 at 8:33

Robert Vuković · Accepted Answer · 2012-07-27 10:01:20Z

3

To answer if someone else needs it. Solution is relatively simple:

LDAP.ORA file has to be modified with correct LDAP Parameters

DIRECTORY_SERVERS=(tnsnames.somesite.org:389:636)
DEFAULT_ADMIN_CONTEXT="dc=site,dc=com"
DIRECTORY_SERVER_TYPE=OID

and than the connection string is similar to the situation without the LDAP

 <connectionStrings>
    <add name="VoccDbContext" connectionString="metadata=res://*/Entities.Vocc.VoccModel.csdl|res://*/Entities.Vocc.VoccModel.ssdl|&#xD;&#xA;        res://*/Entities.Vocc.VoccModel.msl;provider=Oracle.DataAccess.Client;provider connection string=&quot;DATA SOURCE=sameDbName;PASSWORD=somePass;USER ID=someUser;&quot;"         providerName="System.Data.EntityClient" />
</connectionStrings>

answered Jul 27, 2012 at 10:01

Robert Vuković

4,6986 gold badges34 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bob. Over a year ago

Does setting a username/password in the connection string affect LDAP? Or does it do LDAP then negate the username/password?

Robert Vuković Over a year ago

Because I am connecting to multiple databases test,acc,prod for each I use different password so by my understanding LDAP only maps database name to specific machine/Oracle instance so it is possible to change Oracle machines without the need to update client connection strings.

Sundara Prabu Over a year ago

U also need to have a sqlnet.ora file in the oraclehome folder/network/admin with the following contents.

Community · Accepted Answer · 2017-05-23 11:48:13Z

0

If you use "/" for username and leave password blank, it will change to Windows Authentication.

Here is the MSDN article on Connecting to the Oracle Database Using Windows Authentication and this question addresses a problem where a user cannot connect to the Oracle database using ODP.NET and its fix.

Here's what one of my App.Config connection strings looks like to connect using Windows Authentication:

 <connectionStrings>
      <add name="EntityFrameworkEntities" connectionString="metadata=res://*/EntityFrameworkModel.csdl|res://*/EntityFrameworkModel.ssdl|res://*/EntityFrameworkModel.msl;provider=Oracle.DataAccess.Client;provider connection string=&quot;DATA SOURCE=EntityFrameworkDatabase;PASSWORD=;USER ID=/&quot;" providerName="System.Data.EntityClient"/>
 </connectionStrings>

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Jul 19, 2012 at 11:40

Bob.

4,0026 gold badges49 silver badges80 bronze badges

1 Comment

Robert Vuković Over a year ago

I am not using Windows Authentication. It is some Unix or Oracle LDAP with lots of Oracle databases in it.

Sundara Prabu · Accepted Answer · 2014-11-18 13:46:06Z

0

U also need to have a sqlnet.ora file in the oraclehome folder/network/admin with the following contents

# sqlnet.ora Network Configuration File

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES,EZCONNECT)

and LDAP.ora with following contents

DEFAULT_ADMIN_CONTEXT = "dc=world"
DIRECTORY_SERVERS = (server1.x.com:389:636, server2.x.com:389:636)
DIRECTORY_SERVER_TYPE = OID

Ldap.ora help

answered Nov 18, 2014 at 13:46

Sundara Prabu

2,7991 gold badge23 silver badges20 bronze badges

Collectives™ on Stack Overflow

Connection string for Oracle using Entity Framework and LDAP

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related