Problems connecting to Oracle using Oracle Provider for .Net Framwork

[RDF]

Hello,

Trying to use .Net oracle provider, but am getting
the following error. I am using Oracle 9i client to
Oracle 9i. Any ideas?

Could not create an environment: OCIEnvCreate returned -
1.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details: System.Exception: Could not create an
environment: OCIEnvCreate returned -1.

Source Error:


Line 27: Dim myConnection As OracleConnection =
New OracleConnection(strConn)
Line 28:
Line 29: myConnection.Open()
Line 30:
Line 31: myConnection.close()


Source File:
c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb Line:
29

Stack Trace:


[Exception: Could not create an environment: OCIEnvCreate
returned -1.]
System.Data.OracleClient.DBObjectPool.GetObject
(Boolean& isInTransaction)

System.Data.OracleClient.OracleConnectionPoolManager.GetPo
oledConnection(String encryptedConnectionString,
OracleConnectionString options, Boolean& isInTransaction)
System.Data.OracleClient.OracleConnection.OpenInternal
(OracleConnectionString parsedConnectionString, Object
transact)
System.Data.OracleClient.OracleConnection.Open()
HL7Delete.HL7Delete.getConfirmation() in
c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:29
HL7Delete.HL7Delete.Page_Load(Object sender, EventArgs
e) in c:\inetpub\wwwroot\HL7Delete\HL7Delete.aspx.vb:23
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

 

[Angel Saenz-Badillos[MS]]

The problem is probably related to the permissions on the Oracle home
directory, you can use filemon to verify this.

Take a look at this thread in the Oracle forums for more information:

http://www.oracle.com/forums/thread.jsp?forum=146&thread=67364