Re: question on Asp.net and Oracle

From: SHAWN DEB ECKLEY (s.eckley_at_verizon.net)
Date: 07/09/04


Date: Fri, 9 Jul 2004 10:58:01 -0400

I have already reboot the machine since i nstalled the oracle client. i have
even made sure the oracle home is in PATH. and i t still doesn't work.

"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:uI$y4IcZEHA.716@TK2MSFTNGP11.phx.gbl...
>
> "SHAWN DEB ECKLEY" <s.eckley@verizon.net> wrote in message
> news:OHv9y1bZEHA.524@TK2MSFTNGP09.phx.gbl...
> > Hi i'm wondering if anyone can tell me where i'm going wrong.
> > first off i'm using vb.net 2003 to access an oracle 9i (9.2.0.1)
> > i have created a class library that allows me to access an oracle
> database.
> > i have it working in conjunction with a desktop application. however
when
> i
> > use it with a web application i continue to get error message saying
that
> > "Could not create an environment: OCIEnvCreate returned -1"
> >
> > I have then gone back and created a 'fileDSN' which uses the Oracle
client
> > to access the database. i then connected the class library to the
fileDSN
> > and used it in the affore mentioned desktop app. it returned the data in
a
> > split second. then next step i took was to use the library in the web
> > application. i then ran it. when it goes to connect to the database it
> seems
> > to hang. after 10 minute it had not a thing.
> >
>
> The OracleClient is a bunch of DLL's in the [ORACLE HOME]\BIN directory.
> The identity running your web app must have access to the [ORACLE HOME],
and
> [ORACLE HOME]\bin must be in the path. If you installed the OracleClient
> since your last reboot, you will need to reboot for services to see this
> change.
>
> David
>
>



Relevant Pages

  • ORA-27101: shared memory realm does not exist
    ... I installed OracleExpress on a windows 2003 server. ... I was able to create and use a database. ... Now, after a third reboot, this trick doesn't ... ORA-01034: ORACLE not available ...
    (comp.databases.oracle.misc)
  • Re: tnsnames not working. tnsping picks sqlnet.ora
    ... My oracle client has been working fine till today. ... I triend to tnsping the new database and any other old database and I ... configuration assistant) to add the entry again. ...
    (comp.databases.oracle.misc)
  • Re: Fast roll-back
    ... Why, where a roll back occurred, it is faster to reboot the database ... I find the term "reboot" very objectionable. ... let me reply to your question: If you "reboot" the database (I assume ... There is a significant difference in speed on Oracle 9i and much ...
    (comp.databases.oracle.server)
  • Re: MS Oracle Data Provider BUG: Data corrupt after 16 rows with O
    ... Unicode into a UTF8 database, when you insert Unicode data it inserts ... True Unicode providers like odp.net and the oracle managed ... provider will instead return the "garbage". ... >> It is really strange that both ODP.NET and the Oracle Client managed ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Apparent DBD::Oracle 1.16 unicode regression
    ... >> I suspect an oracle client version mismatch with the server. ... database, and from a 9.2 client to a 9.2 database. ... oracle client software or OLDER versions of oracle on the database side. ... Since you say this breaks _every_ one of your customers, however, I find ...
    (perl.dbi.users)