Problems connecting to Oracle using Oracle Provider for .Net Framwork

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
Wed Aug 13 16:09:44 CDT 2003

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



--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


"RDF" <ryan.flatters@krcc.on.ca> wrote in message
news:0fe201c361de$a69df6b0$a001280a@phx.gbl...
> 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()
>
>
>