Re: Oracle Probs with ADO.NET

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 07/10/04 

Date: Fri, 9 Jul 2004 21:41:09 -0400

Jy,

At a command prompt, type the command path, and examine the output.
specifically, what are the entries with ???\bin, where ??? has the keyword
Oracle in it?

Do a find file for oci.dll, searching from the root path - how many entries
does does it return. For each, what is the size of the file.

For the oci.dll files that you find (hopefully there will be just one), run
the Depends utility, and see if the OCIEnvCreate function is exported - if
so, what is the ordinal value?

I hope this helps a bit, if nothing else, it may add a bit of structure to
the debugging process.

The solution to these kinds of problems is usually trivial, its the
discovery that causes the big headaches :)

regards
roy fine

"Jy Saghbini" <JySaghbini@discussions.microsoft.com> wrote in message
news:32C2335A-BEF1-4D47-87B4-0FEA2936F24B@microsoft.com...
> hi Roy,
> The thing i dont get is that i only have one version of Oracle installed
on my PC, and its the 8.1.7.0.0. I got the version from the SQL plus and
there was no previous installation of Oracle on my machine.
>
> What do u suggest me to do?
>
> Thanks
>
>
> "Roy Fine" wrote:
>
> >
> > "Miha Markic [MVP C#]" <miha at rthand com> wrote in message
> > news:%23ZiGbCMZEHA.808@tk2msftngp13.phx.gbl...
> > > Hi Jy,
> > >
> > > Is there a particular reason you don't ues managed provider?
> > > Is this an asp.net application?
> > > Do you have more than one oracle home?
> > > What about c:\orant\bin folder permissions?
> > >
> >
> > As someone with 10+ years of heavy OCI development experience, I offer
the
> > following:
> >
> > The OP is able to load the oci.dll, so it is not a permissions issue at
all.
> > Rather it is a version issue - the oci.dll does not have the function
> > OCIEnvCreate exported. OCIEnvCreate was first introduced in Oracle 8i,
> > specifically Oracle 8.1.5, replacing OCIInitialize from Oracle 8.0 and
olog
> > from Oracle OCI 7.x. So instead, it would appear that the OP does not
have
> > Oracle Client 8.1.7 as reported, rather has something prior to Oracle
Client
> > 8.0 - or at least has a prior version of Oracle Home\bin at the head of
the
> > default path environment setting.
> >
> > I suggest that the OP verify environment variable path setting, then the
> > client version before proceeding...
> > ..
> > regards
> > roy fine
> >
> >
> > > --
> > > Miha Markic [MVP C#] - RightHand .NET consulting & development
> > > miha at rthand com
> > > www.rthand.com
> > >
> > > "Jy Saghbini" <JySaghbini@discussions.microsoft.com> wrote in message
> > > news:3801B826-0B67-433D-A502-EEB406C46B21@microsoft.com...
> > > > Hi,
> > > > I'm using Oracle Client 8.1.7 with VB.NET DotNet 2003. I'm trying to
> > > connect to an Oracle DB using Microsoft OLE DB Provider for Oracle.
I'm
> > > being able to create the Data Connection but when i try to create the
> > > OracleConnection and the OracleDataAdapter, i'm getting the folowing
> > > message:
> > > >
> > > > Unable to find an entry point named OCIEnvCreate in DLL oci.dll
> > > >
> > > > I checked the permission on the Oracle Home folder (c:\orant) but it
is
> > > set to full control for everyone. I tried to add authenticated users
and
> > set
> > > their permissions for read and execute but it didnt work.
> > > >
> > > > Can you help me please?
> > > >
> > > > Thanks
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: ORA-27101: shared memory realm does not exist
    ... Heap size 2208K exceeds notification threshold ... open a command prompt and enter the following: ... The path should include the Oracle home bin folder, ... make certain that the spfile is in the expected location: ...
    (comp.databases.oracle.misc)
  • NIS+ and NFS Problems
    ... I installed oracle database on one of my NIS+ clients. ... I did make entries into the dfstab to allow it to be NFS mounted. ... All the persmissions exactly look the same on the host where actually ...
    (comp.unix.solaris)
  • Re: Work with SQL*Plus through command prompt windows
    ... a backup and recovery of an Oracle9i database. ... No listener"...and accessing using SQL*Plus through command prompt I ... Oracle database through SQL*Plus tell us why we should take our time ... I apologize....this is my first day as a real DBA after I finished ...
    (comp.databases.oracle.server)
  • Re: Newbie: Oracle join issue, too many entries for a join
    ... I have 2 tables with each hundert ... thousands of entries. ... normally my client and server is getting out of memory. ... Could you please verify you are actually running Oracle, ...
    (comp.databases.oracle.misc)
  • Problem with command prompt SqlPlus/Imp
    ... I'm having problem connecting to my Oracle 10g database using the ... But using MyUser/MyPassword@MyTNS in command prompt sqlplus or imp get ... Oracle SqlDeveloper: 1.0.0.15.57 ...
    (comp.databases.oracle.server)