0

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?

Travis Heseman
  • 11,359
  • 8
  • 37
  • 46

2 Answers2

1

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

Does your app pool identity have network logon rights?

Matthew Abbott
  • 60,571
  • 9
  • 104
  • 129
  • Have you tested this with ODP.NET? See http://stackoverflow.com/questions/4950897/odp-net-integrated-security-invalid-connection-string-argument – Travis Heseman Mar 07 '11 at 17:38
  • If my app pool identity didn't have logon rights.. I'd be getting errors instead of successful, but slow, page loads. – Travis Heseman Mar 07 '11 at 17:41
0

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?

Uwe Keim
  • 39,551
  • 56
  • 175
  • 291