Visual Studio project to read from Oracle 10 and 11?

Question

I have a project that needs to extract data from Oracle. Problem is that some data comes from Oracle 10 and other's from Oracle 11.

I'm currently including Oracle.DataAccess.dll to my project, but this DLL have to correspond to the version of Oracle.

So can I have 2 Oracle DLL's with the same name to my project? How can I specify which DLL should be used during each Oracle read?

http://stackoverflow.com/questions/5916855/using-multiple-versions-of-the-same-dll Anyway, are you sure that the latest version of the dll doesn't offer retrocompatibility? I'm currently using Oracle.DataAccess.dll shipped with Oracle client 12.1.0 to access Oracle 11.2.0.2 Database — Matteo Umili, Aug 27 '15 at 08:10

score 2 · Accepted Answer · answered Aug 27 '15 at 07:59

2

No, you dont need to have two libraries. The latest version are backward compatible and works fine with Oracle <= 11.

answered Aug 27 '15 at 07:59

Stawros

Thanks - I will give it a try soon. I'll give the answer the accepted thumbs up if it works! – Cameron Castillo Aug 27 '15 at 08:06
You can also connect with Oracle.DataAccess.dll Version 10 to an Oracle Database of version 11g (or 12c) – Wernfried Domscheit Aug 27 '15 at 08:11

1 Answers1