CODEWITHSUNDEEP
asp.netoracle-databaseconnection-stringodp.netintegrated-security
Travis Heseman
Travis Heseman

Reputation: 11449

ASP.NET Oracle ODP.NET Integrated Security Slowness

The following results in successful sub-second page loads.

<add name="test" 
    connectionString="Data Source=TEST_ORACLE;User Id=user;Password=password;" />

The following subtle change to use the app pool's custom identity results in successful page loads that are 20+ times slower.

<add name="test" 
    connectionString="Data Source=TEST_ORACLE;User Id=/;" />

It appears that I at least got the trusted connection to work. What am I missing?

Upvotes: 0

Views: 742

Answers (2)

Matthew Abbott
Matthew Abbott

Reputation: 61607

Try Integrated Security=SSPI; instead of User Id=/;

Does your app pool identity have network logon rights?

Upvotes: 1

Uwe Keim
Uwe Keim

Reputation: 40746

The connections strings that I use look like

<add 
    name="myOracleConnection" 
    connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServer)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))); User Id=MyUser; Password=MyPassword;" 
    providerName="system.data.oracleclient"/>

I.e. I do not rely on these external configuration files (were they named .ora? I forgot it).

Maybe you can lower dependencies and side-effects if you also try to make your connection string self-containing with everything included?

Upvotes: 0

Related Questions