Error connecting to Oracle

[Robin9876]

Using some .Net code to connect to Oracle the follow error message is
now being displayed

File or assembly name Oracle.DataAccess, or one of its dependencies,
was not found.
Exception Details: System.IO.FileNotFoundException: File or assembly
name Oracle.DataAccess, or one of its dependencies, was not found.


This section of code has not been changed and the a test ODBC
connection can be successfully made from the web server. In the
Windows path is the folder containing the dll as the first folder
location.

Does anybody know why this error is occurring and how to resolve it?

 

[Mary Chipman [MSFT]]

Which OracleClient provider are you using? Version of Oracle? I'd do a
web search to troubleshoot - there's too many possibilities for anyone
to be able to say off the top of their head.

--Mary

 

[Robin9876]

I have since found that the development and live servers have slighlty
different build numbers for the Oracle.DataAccess.DLL , the
development server has v9.2.0.700 and the live server has v9.2.0.401

As these are both v9.2.0.N drivers I would assume that the code should
still work. If not how can you find which version of the v9.2 Oracle
drivers these are and download them from?

 

[Robin9876]

I have since found that there is a slightly different version build
between development and production servers. The development server has
Oracle.DataAccess.dll v9.2.0.700 and the production server has
v9.2.0.401 , would this Oracle dll version have this imapct on the
system if the code has since been compiled and deployed?

 

[Mary Chipman [MSFT]]

I don't know much about Oracle - let me check into it and I'll get
back to you.

--Mary

 

[Mary Chipman [MSFT]]

Here's the advice from someone who knows about Oracle:

"Based on the exception message, it sounds like .NET is unable to load
Oracle's .NET provider rather than being a connectivity issue. I'm
not sure what would cause that problem, but I'd suggest looking at the
account and permissions that's running the code. Where is the
assembly and can that account find it via the File I/O classes?

There was an Oracle release where their client software was installed
in such a way that non-admins could not see the main client .dll that
System.Data.OracleClient and Oracle.DataAccess.Client needed to load,
which caused problems for people running ASP.NET applications because
the ASP.NET account was non-admin. This issue sounds mildly related.
It might be worth doing a search using your favorite search engine to
see if the problem you're seeing is related. If I remember correctly,
using the following keywords should yield hits on the issue -
OracleClient "oci.dll" "requires Oracle client" authenticated."

HTH,
Mary

 

[Robin9876]

I have got it to work now by using the later Oracle drivers.

Here's the advice from someone who knows about Oracle:

"Based on the exception message, it sounds like .NET is unable to load
Oracle's .NET provider rather than being a connectivity issue. I'm
not sure what would cause that problem, but I'd suggest looking at the
account and permissions that's running the code. Where is the
assembly and can that account find it via the File I/O classes?

There was an Oracle release where their client software was installed
in such a way that non-admins could not see the main client .dll that
System.Data.OracleClient and Oracle.DataAccess.Client needed to load,
which caused problems for people running ASP.NET applications because
the ASP.NET account was non-admin. This issue sounds mildly related.
It might be worth doing a search using your favorite search engine to
see if the problem you're seeing is related. If I remember correctly,
using the following keywords should yield hits on the issue -
OracleClient "oci.dll" "requires Oracle client" authenticated."

HTH,
Mary

I don't know much about Oracle - let me check into it and I'll get
back to you.

--Mary

On Wed, 13 Feb 2008 09:09:30 -0800 (PST), Robin9876

I have since found that there is a slightly different version build
between development and production servers. The development server has
Oracle.DataAccess.dll v9.2.0.700 and the production server has
v9.2.0.401 , would this Oracle dll version have this imapct on the
system if the code has since been compiled and deployed?
On 12 Feb, 14:56, "Mary Chipman [MSFT]" <[email protected]>
wrote:
Which OracleClient provider are you using? Version of Oracle? I'd do a
web search to troubleshoot - there's too many possibilities for anyone
to be able to say off the top of their head.
--Mary
On Fri, 8 Feb 2008 08:37:17 -0800 (PST), Robin9876
Using some .Net code to connect to Oracle the follow error message is
now being displayed
File or assembly name Oracle.DataAccess, or one of its dependencies,
was not found.
Exception Details: System.IO.FileNotFoundException: File or assembly
name Oracle.DataAccess, or one of its dependencies, was not found.
This section of code has not been changed and the a test ODBC
connection can be successfully made from the web server. In the
Windows path is the folder containing the dll as the first folder
location.
Does anybody know why this error is occurring and how to resolve it?