Re: Oracle Probs with ADO.NET

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

Date: Thu, 8 Jul 2004 22:54:48 -0400

"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: Oracle Probs with ADO.NET
    ... Is there a particular reason you don't ues managed provider? ... Do you have more than one oracle home? ... > I'm using Oracle Client 8.1.7 with VB.NET DotNet 2003. ... > I checked the permission on the Oracle Home folder but it is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Asp.net / iis / oracle problem - never mind , i think i found
    ... Installed Oracle Client software on Server ... My DBA had to create synonyms for the account used to access the database to ... later client software installation. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Oracle Client and ADO.NET
    ... I was reading thru some documents and it seems that an oracle client ... installation, Rapid App Dev Installation, etc... ... Of course I can use OLEDB/ODBC providers instead if this doesn't ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ok. ... Reinstalled the full Oracle client x64. ... It's as if the Microsoft drivers don't know Oracle is installed, ...
    (microsoft.public.sqlserver.dts)
  • Re: Trying to Connect SSIS to Oracle on x64
    ... Joseph got his package to run. ... I'm trying to get SSIS to connect to Oracle on 64-bit, ... The Oracle client can connect to the server and the connection tests ... String on Microsoft's ODBC drivers. ...
    (microsoft.public.sqlserver.dts)
Loading