Oracle Probs with ADO.NET

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

Miha
Thu Jul 08 02:53:03 CDT 2004

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?

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

JySaghbini
Thu Jul 08 04:57:01 CDT 2004

What do u mean by managed provider? Is there another provider for Oracle than the one i'm using?
The problem i encountered is in VB.NET application.
I have one Oracle Home
I checked the permissions on orant/bin. Same as orant. Full permission for everyone.

Thanks

"Miha Markic [MVP C#]" wrote:

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

Miha
Thu Jul 08 05:44:20 CDT 2004

Hi Jy,

"Jy Saghbini" <JySaghbini@discussions.microsoft.com> wrote in message
news:D2974B9C-E5D7-47E9-8530-2E2962B379DF@microsoft.com...
> What do u mean by managed provider? Is there another provider for Oracle
than the one i'm using?

There is also Oracle's own managed provider. However this works only with
higher version clients, so it is not usefull in your case. (you are using
the right one).

> The problem i encountered is in VB.NET application.
> I have one Oracle Home
> I checked the permissions on orant/bin. Same as orant. Full permission for
everyone.

That's strange. Does your Oracle client work from other applications?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

JySaghbini
Thu Jul 08 05:55:01 CDT 2004

Actually, what i have to do is to migrate an application from Oracle Developer to VB.NET. The application itself runs very well, but the application uses Oracle Forms, so its logical that it works. I haven't try to connect from another application. From what other application can i try it?

"Miha Markic [MVP C#]" wrote:

> Hi Jy,
>
> "Jy Saghbini" <JySaghbini@discussions.microsoft.com> wrote in message
> news:D2974B9C-E5D7-47E9-8530-2E2962B379DF@microsoft.com...
> > What do u mean by managed provider? Is there another provider for Oracle
> than the one i'm using?
>
> There is also Oracle's own managed provider. However this works only with
> higher version clients, so it is not usefull in your case. (you are using
> the right one).
>
> > The problem i encountered is in VB.NET application.
> > I have one Oracle Home
> > I checked the permissions on orant/bin. Same as orant. Full permission for
> everyone.
>
> That's strange. Does your Oracle client work from other applications?
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> miha at rthand com
> www.rthand.com
>
>
>

Paul
Thu Jul 08 13:32:45 CDT 2004

On Thu, 8 Jul 2004 03:55:01 -0700, "Jy Saghbini" <JySaghbini@discussions.microsoft.com> wrote:

¤ Actually, what i have to do is to migrate an application from Oracle Developer to VB.NET. The application itself runs very well, but the application uses Oracle Forms, so its logical that it works. I haven't try to connect from another application. From what other application can i try it?
¤

Can you connect and query the database with SQL Plus?


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Roy
Thu Jul 08 21:54:48 CDT 2004


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

Miha
Fri Jul 09 01:35:58 CDT 2004

Roy, good idea.

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

JySaghbini
Fri Jul 09 02:01:01 CDT 2004

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