ODP.NET migration

[Erik Cruz]

Hi.

As I could not find material regarding this issue on Oracle newsgroups, I
would like to try your help.

I have an ASP.NET application that uses ODP.NET version 9.2.0.7 to access an
Oracle 10g database. The application works ok, but now we are considering to
migrate to version 10.1.0.4 of ODP.NET in order to use some of the new
features. I know that the 10.1 version has a DLL to allow applications to
switch through ODP.NET installed versions, but could not find any article on
how to use that. Had anyone experienced this kind of migration?

Any kind of help is greatly appreciated )

Regards,
Erik Cruz

 

[Frans Bouma [C# MVP]]

Hi.

As I could not find material regarding this issue on Oracle
newsgroups, I would like to try your help.

I have an ASP.NET application that uses ODP.NET version 9.2.0.7 to
access an Oracle 10g database. The application works ok, but now we
are considering to migrate to version 10.1.0.4 of ODP.NET in order to
use some of the new features. I know that the 10.1 version has a DLL
to allow applications to switch through ODP.NET installed versions,
but could not find any article on how to use that. Had anyone
experienced this kind of migration?

Just install ODP.NET 10.1.0.4, and your app can use 10g. It then also
can use 9i as ODP.NET 10 contains a policy file which redirects
references to 9.x to 10.1

Of course, if you want to utilize new features like xml support, you
have to reference the 10g ODP.NET, however you then still can access
the 9i db. You just from then on have to install the 10g ODP.NET
version, instead of 9.2.0.7.

It's my experience that's in general better to use the 10g version
instead of the 9i version for 9i as well, as the 9.2.0.x codebase seems
to be buggier than the 10.1.0.4 codebase.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[Erik Cruz]

Hi Frans.

Thanks for the info. I have two more questions, if you don`t mind...

Is this redirection from 9x to 10g automatic or do I need to configure
something on the policy files? Do I need to install the 10g client or can I
keep using the 9x client with ODP.NET 10x?

Regards,
Erik Cruz

 

[Frans Bouma [C# MVP]]

Hi Frans.

Thanks for the info. I have two more questions, if you don`t mind...

Is this redirection from 9x to 10g automatic or do I need to
configure something on the policy files?

Automatic, ODP.NET 10 installs a policy file which redirects all
references to the 10.1 assembly (and thus client).

Do I need to install the 10g
client or can I keep using the 9x client with ODP.NET 10x?

ODP.NET comes with the client, so you should use the client installed
with ODP.NET. This thus means that you just need to install ODP.NET
10.x, and can remove everything else.

FB

Regards,
Erik Cruz


to >> use some of the new features. I know that the 10.1 version has
a DLL >> to allow applications to switch through ODP.NET installed
versions, >> but could not find any article on how to use that. Had
anyone >> experienced this kind of migration?

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------