can't load OCI.DLL

[news.microsoft.com]

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

[Ken Cox [Microsoft MVP]]

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" <re*******@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

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

[sluggy]

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" <re*******@hotmail.com> 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

[news.microsoft.com]

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]" <BA************@sympatico.ca> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

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" <re*******@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

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

[news.microsoft.com]

That was the problem thanks!!
"sluggy" <zz*@hotmail.com (this is fake, don't use it)> wrote in message
news:bd********************************@4ax.com...

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" <re*******@hotmail.com> 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