Does System.Data.OracleClient support oracle 11g? If yes which version? The .Net appplication is presently running on 32bit server. We will be upgrading to 64 bit. Will System.Data.OracleClient support 64 bit too? Version of System.Data.OracleClient in use at present 2.0.0.0 with oracle 9i.
A:
Difficult question, according to this link it does not and it will not in the future either. However, I'm currently using System.Data.OracleClient to connect to an 64bit 11g server and I've got Oracle's 11g client tools installed and I have no problems.
ho1
2010-06-01 14:57:54
What are you using oracle client for? Are you sure you are not using ODP.Net
Prithis
2010-06-01 16:56:37
@Prithis - I probably wrote that a bit confusingly. I use MS client, but I also have ODP.Net and the rest of Oracle's 11g client tools installed. I just mentioned it for completeness.
ho1
2010-06-01 17:13:57
I can confirm that System.Data.OracleClient works with oracle 11g. I have version 2.0 of the dll. But as Daniel has correctly suggested looking forward we should use ODP.net.
Prithis
2010-06-03 12:57:20
+1
A:
System.Data.OracleClient will be depricated soon. If you think about future you better go on this one Oracle Data Provider for .NET
Daniel Bern
2010-06-01 14:58:18
Also I remember that there was some update of .net 3.5 sp1 that must resolve this problem.
Daniel Bern
2010-06-01 15:00:04