Connect with OraOLEDB.Oracle and ASP.NET
Hi,
I try to connect to an Oracle DB V. 9.2 from an ASP.NET
program. I tried it with 3 different providers, but if I
open the connection (myConnection.Open() ), I get the
following error:
a.) With Oracle Provider from Microsoft (V. 2.70)
(MSDAORA):
This gives me an "Unspecified error: E-FAIL (0x80004005)"
b.) With Oracle Provider for OLEDB Release 9.2 from
Oracle (OraOLEDB.Oracle):
This gives me an error "access denied".
c.) With Managed Oracle Provider (downloaded yesterday):
This gives me an error "Could not create an environment:
OCIEnvCreate returned -1"
This all happens, if I'm working with ASP.NET. If I do
the same with a .NET Windows program it works fine. Also
it is no problem working against an SQLServer or Access
DB with this program.
I tried granting read access on your Oracle 9.2 home directory to the IIS
anonymous account and restarting IIS, but it didn't help.
Also I uninstalled oracle client and installed again, without success.
Thanks for your help
Ferdi
.