SoapException when connecting to Oracle

[sidney]

I cannot open the connection to Oracle and got this error
message regarding the OCIEnvCreate. Any clues?


Additional information:
System.Web.Services.Protocols.SoapException: Server was
unable to process request. ---> System.Exception: Could
not create an environment: OCIEnvCreate returned -1.
at System.Data.OracleClient.DBObjectPool.GetObject
(Object owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnectionPoolManager.GetPo
oledConnection(String encryptedConnectionString,
OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInternal
(OracleConnectionString parsedConnectionString, Object
transact)
at System.Data.OracleClient.OracleConnection.Open()
at AA.AAMedical.DataRead..ctor() in
c:\data\dotnetworks\oracledatatier\dataaareport\dataread.c
s:line 21
at GetEmployees.Service1.RetrieveEmployee(Int32
p_empNum) in
c:\inetpub\wwwroot\getemployees\service1.asmx.cs:line 70
--- End of inner exception stack trace ---

 

[Miha Markic]

Hi sidney,

Check out previous thread started by anon:
can not open oracle connection with web seb service

I think the solution would be the same - give aspnet user ntfs privileges to
Oracle's bin folder.

 

[sidney]

ASPNET has been granted full privleges to Oracle \bin
folder but problem is still happening.

 

[Miha Markic]

Hi sidney,

Do all folders in path to bin have all enough privileges?
Make sure that the read privilege is granted to ORACLE_HOME\Network|Admin

 

[sidney]

Miha: I did as you said, granting aspnet privlages all
the way down the folder and it works. Thanks. You are a
genius!