Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > can't load OCI.DLL

Reply
Thread Tools

can't load OCI.DLL

 
 
news.microsoft.com
Guest
Posts: n/a
 
      06-30-2004
Hello,

Another issue has risen after installing Visual Studio 2005. When I use
OracleClient with ASP.NET v1.1 I receive an error stating it can't load
OCI.DLL.

This has never been a issue before so I assume that it is a result of the
new version of VS. Doe's anyone know a fix for this problem?

Thanks,
Bryan


 
Reply With Quote
 
 
 
 
Ken Cox [Microsoft MVP]
Guest
Posts: n/a
 
      07-01-2004
That's usually a problem with the Oracle client or permissions.

1. Make sure the ASPNET account has sufficient permissions in the Oracle
folder.
2. Confirm the version of the Oracle client is 8.1.7 or later.
3. Check the connection string is correct.

Use Oracle With ADO.NET
Access Oracle databases from your .NET apps.
http://www.fawcette.com/vsm/2003_01/...es/beauchemin/

Here's a quote:

"Once you install the .NET data provider of your choice and an Oracle client
if
necessary, you need to ensure that the current user has access to
directories
where the client software resides. Later versions of the Oracle client
protect
the client libraries with a discretionary access control list (DACL). If
you're
using ASP.NET, you must also ensure that the appropriate "Web server users"
(usually the user named ASPNET who runs the ASP.NET worker process) can
access
the client. Because ASPNET has only ordinary user privileges and not
administrator privileges, you need to add ASPNET to the Access Control List.
If
the ASPNET user doesn't have access, you'll receive a message such as
"Cannot
load OCI.dll" or "ORA-12154 TNS: could not resolve service name."


use that DLL.
"news.microsoft.com" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hello,
>
> Another issue has risen after installing Visual Studio 2005. When I use
> OracleClient with ASP.NET v1.1 I receive an error stating it can't load
> OCI.DLL.
>
> This has never been a issue before so I assume that it is a result of the
> new version of VS. Doe's anyone know a fix for this problem?
>
> Thanks,
> Bryan
>
>


 
Reply With Quote
 
 
 
 
sluggy
Guest
Posts: n/a
 
      07-01-2004
Bryan,
as Ken said, make sure the ASPNET user has sufficient rights. We have found that you need to assign
the rights from the root Oracle folder, just doing the /bin folder will not do the trick, obviously
oci.dll loads stuff from outside the bin folder. If you get really keen you could use depends.exe to
examine the imports of oci.dll, and determine what it is loading and from where.

HTH,
sluggy


On Wed, 30 Jun 2004 16:20:47 -0700, "news.microsoft.com" <(E-Mail Removed)> wrote:

>Hello,
>
>Another issue has risen after installing Visual Studio 2005. When I use
>OracleClient with ASP.NET v1.1 I receive an error stating it can't load
>OCI.DLL.
>
>This has never been a issue before so I assume that it is a result of the
>new version of VS. Doe's anyone know a fix for this problem?
>
>Thanks,
>Bryan
>


 
Reply With Quote
 
news.microsoft.com
Guest
Posts: n/a
 
      07-01-2004

In response to your suggestions

1. Make sure the ASPNET account has sufficient permissions in the Oracle
folder.
I gave the account full permissions and then I receive the following
error.
"Could not create an environment: OCIEnvCreate returned -1"

2. Confirm the version of the Oracle client is 8.1.7 or later.
I am using Oracle client 9.2

3. Check the connection string is correct.
The connection string works with a WinForms app that connects to Oracle.

I checked all of this before posting. I wasn't sure where to go from there
that is why I posted it to the newsgroup.

Thanks,
Bryan


"Ken Cox [Microsoft MVP]" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> That's usually a problem with the Oracle client or permissions.
>
> 1. Make sure the ASPNET account has sufficient permissions in the Oracle
> folder.
> 2. Confirm the version of the Oracle client is 8.1.7 or later.
> 3. Check the connection string is correct.
>
> Use Oracle With ADO.NET
> Access Oracle databases from your .NET apps.
> http://www.fawcette.com/vsm/2003_01/...es/beauchemin/
>
> Here's a quote:
>
> "Once you install the .NET data provider of your choice and an Oracle

client
> if
> necessary, you need to ensure that the current user has access to
> directories
> where the client software resides. Later versions of the Oracle client
> protect
> the client libraries with a discretionary access control list (DACL). If
> you're
> using ASP.NET, you must also ensure that the appropriate "Web server

users"
> (usually the user named ASPNET who runs the ASP.NET worker process) can
> access
> the client. Because ASPNET has only ordinary user privileges and not
> administrator privileges, you need to add ASPNET to the Access Control

List.
> If
> the ASPNET user doesn't have access, you'll receive a message such as
> "Cannot
> load OCI.dll" or "ORA-12154 TNS: could not resolve service name."
>
>
> use that DLL.
> "news.microsoft.com" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Hello,
> >
> > Another issue has risen after installing Visual Studio 2005. When I use
> > OracleClient with ASP.NET v1.1 I receive an error stating it can't load
> > OCI.DLL.
> >
> > This has never been a issue before so I assume that it is a result of

the
> > new version of VS. Doe's anyone know a fix for this problem?
> >
> > Thanks,
> > Bryan
> >
> >

>



 
Reply With Quote
 
news.microsoft.com
Guest
Posts: n/a
 
      07-01-2004
That was the problem thanks!!


"sluggy" <(E-Mail Removed) (this is fake, don't use it)> wrote in message
news:(E-Mail Removed)...
> Bryan,
> as Ken said, make sure the ASPNET user has sufficient rights. We have

found that you need to assign
> the rights from the root Oracle folder, just doing the /bin folder will

not do the trick, obviously
> oci.dll loads stuff from outside the bin folder. If you get really keen

you could use depends.exe to
> examine the imports of oci.dll, and determine what it is loading and from

where.
>
> HTH,
> sluggy
>
>
> On Wed, 30 Jun 2004 16:20:47 -0700, "news.microsoft.com"

<(E-Mail Removed)> wrote:
>
> >Hello,
> >
> >Another issue has risen after installing Visual Studio 2005. When I use
> >OracleClient with ASP.NET v1.1 I receive an error stating it can't load
> >OCI.DLL.
> >
> >This has never been a issue before so I assume that it is a result of the
> >new version of VS. Doe's anyone know a fix for this problem?
> >
> >Thanks,
> >Bryan
> >

>



 
Reply With Quote
 
GrahamA GrahamA is offline
Junior Member
Join Date: Aug 2006
Location: Sydney, Australia
Posts: 2
 
      08-07-2006
I thought I replied to this post, maybe there's multiple threads with the same issue?

here it is again in case I didn't hit save before!



I too encountered this issue a couple of times and am not impressed by the lack of "solutions" out here on-line.

Many people have advised that this is a permissions error - as above.

In fact, they're 100% correct. I found that by applying Read/Execute permissions for ASPNET to the Oracle folder, it wasn't applying to ALL of the folders.

Go through the various subfolders and ensure the permissions have been replicated throughout. This solved the problem for me.

Hope this helps.
Graham.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
to load or not to load =?Utf-8?B?cm9kY2hhcg==?= ASP .Net 3 08-30-2006 08:20 AM
Load Balancing / Load Sharing over parallel paths ciscortp@hotmail.com Cisco 1 11-21-2005 03:57 PM
page not load / freeze / long time to load roni ASP .Net 1 08-30-2005 09:15 PM
Page Load and webcontrol page load venky ASP .Net 5 07-11-2005 03:16 PM
beginning page load immediately on postback with a long load time ? Mad Scientist Jr ASP .Net 7 06-30-2004 07:40 PM



Advertisments