odp.net

.Net Application cannot detect ODP.NET 2.111.6.20 in 64bit windows

Hi everyone, We are currently deploying our .net winform application which depends on ODP.NET 2.111.6.20 via xcopy. Installing on 32 bit windows was fine, however, for some reason our applications cannot detect odp.net in a 64bit environment. I would like to ask if there are special build configurations that i have to do in building m...

Usage of Oracle binding variables with LIKE in C#

As part of an effort to stop using dynamic SQL generation and encourage use of bind variables, I am running into some problems. I am querying an Oracle 9i database from an ASP.NET page using Oracle Data Providers for .NET The query is sql = "SELECT somedata FROM sometable WHERE machine = :machineName "; I define the Oracle Paramete...

ODP .NET AQ Getting Exception Messages Queue

How can I dequeue Exception Messages from a Oracle Message Queue using ODP? I'm using the default queue for exceptions. Thanks!! ...

Row count from OracleDataReader

HI, Can any one tell me how to find row count from OracleDataReader in .net 2.0. regards pradeep. ...

nhibernate 3.0 Oracle connection through ODP.NET

Can someone tell me whats wrong with the nhibernate config below? Using the latest ODP.NET version. <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2" > <session-factory> <property name="connection.driver_class">NHibernate.Driver.OracleDataClientDriver</property> <property name="connection.connection_string">DA...

Deploy odp.net 11g application in a 10g IIS server enviroment

I have developed a C# 3.5 Mvc 1.0 application using oracle 11gR2 client which uses odp .net 2.112.1.0. I want to deploy it in my IIS7 server which has oracle client 10g which uses odp.net 2.102.2.20 . I am getting the following error Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicK...