Choosing the right Oracle Client

dotnet framework

    Sponsored Links


  • 1. GetEntryAssembly problem
    Hello! I have a problem with the Assembly.GetEntryAssembly() method. I get an exception when the method is invoked saying: "Object reference not set to an instance of an object". What could cause this problem? Does it have something to do with the AssemblyInfo file? Thanks Linus Rstad
  • 2. System.Reflection.TargetInvocationException
    Hi, I have a windows application which uses reflection and factory pattern. The code in the factory class to create an instance of an assembly is: dim assemblyInstance as [Assembly] = [Assembly].LoadFrom(pAssembly) dim typeInstance as Type = assemblyInstance.GetType(pType) Dim obj As Object = Activator.CreateInstance(typeInstance) where pAssembly is the path of the .dll and the pType is the type of the assembly. When running the application, the above code will be invoked twice for two different assemblies. For the first one, it works perfect. But for the second one, the CreateInstance statement throws System.Reflection.TargetInvocationException. The innerException is System.InvalidCastException with message "Specified cast is not valid." What's wrong? Thanks.
  • 3. .Net Framework 1.1 and 2.0 beta
    Hi, I recently installed the 2.0 beta along with express and somehow I can't seem to get my web applications that was developed in version 1.1 to work properly. Is there a way to make my web applications to work without uninstalling one of the version? Thanks, Reas

Choosing the right Oracle Client

Postby Bora » Tue, 27 Dec 2005 20:49:44 GMT

There are two different Oracle Client installed on my computer. And
i'have an application that have to access Oracle. But it chooses the
wrong Oracle Client while it's executing. How can i set the right
Oracle Client for .Net Framework. 
Can anyone help me.


Re: Choosing the right Oracle Client

Postby Christopher Reed » Tue, 27 Dec 2005 22:54:40 GMT

Try changing your Path environmental variable by switching the placements of 
your Oracle client paths.
Christopher A. Reed
"The oxen are slow, but the earth is patient."

Re: Choosing the right Oracle Client

Postby Bora » Wed, 28 Dec 2005 00:05:23 GMT

Actually there is only one Oracle Client path in environmental variable
Path. But it's also intaresting that in the registery the values that
shows Oracle dll's shows the old ones. Does installing the last version
of MDAC be the solution?

Re: Choosing the right Oracle Client

Postby Christopher Reed » Wed, 28 Dec 2005 06:05:00 GMT

Unfortunately, Oracle installations can be messy to get rid of.  What 
version of Oracle client do you have installed that is active? 
Additionally, what other versions of Oracle have you had on the machine in 
Christopher A. Reed
"The oxen are slow, but the earth is patient."

Re: Choosing the right Oracle Client

Postby Frans Bouma [C# MVP] » Wed, 28 Dec 2005 17:45:46 GMT

	Only if you need to connect to 8i do you need 2 clients on your
machine. Otherwise install the 10g client and you can connect to 9i and
10g. You can switch the oracle home as Christopher says:change the
placements in the path.


Get LLBLGen Pro, productive O/R mapping for .NET:  http://www.**--****.com/ 
My .NET blog:  http://www.**--****.com/ 
Microsoft MVP (C#) 

Similar Threads:

1.Pass an array to an Oracle stored procedure using Microsoft's client for Oracle


Does anyone know how to use an array as a parameter for a stored
procedure using Microsoft's client for Oracle?

I know that Oracle's client for .net has property you can set to
declare it as an array:
param.CollectionType = OracleCollectionType.PLSQLAssociativeArray;


2.Problems connecting to Oracle 9i database with Oracle 10g Client and Win XP x64

Dell Precision 490 with Intel Xeon 64 bit processor running MS Windows XP 
Professional x64 Edition Version 2003 Service pack 1.
Visual Studio .NET 2005
Oracle 10g Client

I am trying to run my ASP.NET application from the above mentioned computer 
that connects to an Oracle 9i database on another machine on the network, 
but get the following error when using the OLEDB provider for Oracle:

Oracle client and networking components were not found. These components are 
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or 
later client software installation.
Provider is unable to function until these components are installed.

I have tried setting the correct permissions on the Oracle Home folder 
without any success.

I get the same error if I'm just trying to connect to that same database 
using the Server Explorer and the .NET Framework Data Provider for OLE DB.

When I try to use the .NET Framework Data Provider for Oracle, I get the 
following error:

Attempt to load Oracle client libraries threw BadImageFormatException. This 
problem will occur when running in 64 bit mode with the 32 bit Oracle client 
components installed.

How do you actually install the 64 bit Oracle client components? During the 
install of the Oracle 10g Client I was nver presented with an option to 
either install 64 bit or 32 bit components.

All this worked fine before I upgraded my computer and was still able to run 
the Oracle 9i client.
Any suggestions that might help connect to my database again are 
appreciated. Surely I'm not the first person that has this problem, but I 
haven't found any solutions out there yet.


3.Oracle provider: oracle client can't be found

I am using System.Data.OracleClient to access my Oracle 
data source. I downloaded and installed Oracle9i client 
software on my machine. But still, when I ran my VB.Net 
code, I got an error that says "System.Data.OracleClient 
requires Oracle client software version 8.1.7 or greater." 
What's up with that? As I meantioned, I already have the 
client software installed. Does that mean that I need to 
add some COM dlls to the project's reference? If so, which 
one? (I see quite a few Oracle dlls in the reference list 
that's available for adding).

Could someone shed some light on this?

Thanks in advance!


4.Exception thrown while accessing Oracle through oracle client

Hi Everyone
                   I am trying to acces Oracle using oracle client classes 
provided by .net in an asp .net application. But I keep on getting following 
"System.Data.OracleClient requires Oracle client software version 8.1.7 "

All the solutions mentioned to this problem on various newsgroups indicate a 
setting in security permission. I have given all sorts of permission to the 
oracle and ora92 folder including everyone-full control.  But it is still not 
working. But if I try to access it through an exe I don't get that error.
Can anyone please help me?


5.error while connecting to Oracle using Microsoft .NEt oracle client

6. Multiple oracle homes - need to choose

7. Choosing the right platform

8. advice on choosing right control

Return to dotnet framework


Who is online

Users browsing this forum: No registered users and 30 guest