Re: Oracle Probs with ADO.NET

From: Jy Saghbini (JySaghbini_at_discussions.microsoft.com)
Date: 07/09/04

  • Next message: Jerry Pisk: "Re: PHP and ASP.NET go HEAD to HEAD" 
    Date: Fri, 9 Jul 2004 00:01:01 -0700

    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
    > >
    > >
    >
    >
    >

  • Next message: Jerry Pisk: "Re: PHP and ASP.NET go HEAD to HEAD"

    Relevant Pages

    • RE: Oracle DBD runtime error
      ... Did you also *just* install the Oracle client? ... sqlplus scott/tiger@DWHDEVR1 ... My guess is that the Oracle installer set the permissions on the Oracle ...
      (perl.dbi.users)
    • 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: 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)
    • 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)