SoapException when connecting to Oracle

  • Thread starter Thread starter sidney
  • Start date Start date
S

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 ---
 
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.
 
ASPNET has been granted full privleges to Oracle \bin
folder but problem is still happening.
 
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
 
Miha: I did as you said, granting aspnet privlages all
the way down the folder and it works. Thanks. You are a
genius!
 
Back
Top