Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODP.NET OracleClient and NHibernate

516343Nov 14 2007 — edited Mar 4 2008
Hello forum, I've developed an application with Oracle. In the machine client I've installed an Oracle Client, and it's well configured and runs correctly.

However, when I want to use my installed application, it doesn't run correctly. What is the best configuration in order to use in a machine that has installed an OracleClient (using ODP.NET or direct access to OracleClient?)

If I use ODP.NET --> Oracle.DataAccess.dll must to be accessible from my program, and i must be compatible with Oracle version.

Other question --> If I use Oracle.DataAcess.dll (ODP.NET), Has Oracle Client to be installed in final user machine?

I'm using NHibernate using ODP.NET (Oracle.DataAccess.dll) and it crashes -->

NHibernate.ADOException: could not execute query
[ SELECT this_.FAMILIA as FAMILIA4_0_, this_.CODI as CODI4_0_, this_.NOM as NOM4_0_, this_.DESCRIPCIO as DESCRIPCIO4_0_, this_.OBSOLET as OBSOLET4_0_, this_.PARE as PARE4_0_ FROM APP.FAMILIA this_ WHERE this_.PARE is null ]
[SQL: SELECT this_.FAMILIA as FAMILIA4_0_, this_.CODI as CODI4_0_, this_.NOM as NOM4_0_, this_.DESCRIPCIO as DESCRIPCIO4_0_, this_.OBSOLET as OBSOLET4_0_, this_.PARE as PARE4_0_ FROM APP.FAMILIA this_ WHERE this_.PARE is null] ---> System.Reflection.TargetInvocationException: Se inició una excepción en el destino de la invocación. ---> Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize()
at Oracle.DataAccess.Client.OracleInit.Initialize()
at Oracle.DataAccess.Client.OracleCommand..ctor()
at Oracle.DataAccess.Client.OracleCommand..ctor()
....

Can you help me please.
Thanks for all.

Message was edited by:
jeusdi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2008
Added on Nov 14 2007
2 comments
4,107 views