I am having trouble getting the ODP.NEt library to work with the .NET DBProviderFactories. I am getting the following error with this code: _DBFactory = DbProviderFactories.GetFactory(providerName); An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value ...
Hi, I have an web application which uses Oracle.DataAccess.dll to communicate with and Oracle db. The web application deployed on 32 bit windows system works but not on windows server 2008 64 bit. I installed 10204_vista_win2k8_x64_production_db package, referenced the installed dll (version 2.102.4.0) from the project but I get the fol...
I am looking for a free linq provider for oracle. I dont need advanced features. What all I need is CRUD operations + ability to generate model from oracle db. I would like to use this on production web site(using ASP.NET & Silverlight). Any pointers & suggestions will be appreciated. ...
I followed the directions here: http://splinter.com.au/blog/?p=156 in an attempt to use a newer version of ODP.NET without installing the Oracle 11g client. I followed everything, so far, except for restarting IIS. However, this has caused some problems and I'm really curious as to why. If I try to use ODP.NET I'm met with a blank excep...
Since the System.Data.OracleClient library has been deprecated, we are in the process of migrating our code base to use Oracle Data Provider for .NET (ODP.NET) instead. One of the issues that we have encountered is that the System.Data.OracleClient uses parameter name binding as opposed to binding by position and all of the code directly...
Hello, I want to my app to work for target machines where the Oracle client could be 10 or 11. Is it possible to do it with ODP? If in my app I reference Oracle.DataAccess.dll from my dev machine (i have ORA client11) - my app works only on target machines with client 11... If I reference ODP from my client 10 - the app works only for...
Hi. I would like to know whether there is a difference in functionality between ODP.net for .net 1.1 and ODP.net for .net 2.0 or higher. Are there any performance differencies? ...
I'm experiencing some terrible performance with reading data off the OracleDataReader object compared to MS SQL Server. It is almost 10 times slower, which is unacceptable. Below is some sample test code that both tests use. What's the most optimum way to read data from OracleDataReader, is there a better way than shown below? I'm h...
Hay, My system needs to execute several major SQL`s (on Oracle DB) using the same connection (asynchronous). What`s the best practice for this issue? 1. open single connection and execute every SQL statement on different thread (does it thread safe?) 2. create new connection and “open + close” it for every SQL statement Thanks, Hec ...
What is the maximum size for the OracleParameterCollection that can be used in a query? ...
Hello, I'm currently developping to application, one using the ODP.Net 9.2 and the other one should use the ODP.Net 11. I'm using the Server Explorer from VS2008 to add a new connection but failed each time with the error "ORA-12154: TNS: Could not resolve the connect identifier specified". I'm not able to debug which ODP VS2008 is usin...
I'm running a program that creates a table and then inserts some data. This is the only program that accesses the database. I'm getting ORA-08177 randomly. Actual code is somewhat complex, but I've written a simple program that reproduces this behavior. using System; using System.Data; using Oracle.DataAccess.Client; namespace orabug...
Just stumbled across the new ClientId (aka client_identifier) variable that is available in Oracle 10g onwards, and would love to incorporate that into an app to assist with audit trails. The app is using a generated Enterprise Library DAAB based layer (netTiers) that is wired to use the ODP.NET drivers with EntLibContrib, so CRUD funct...
Hello guys! I have built a common app that works with PostgreSQL and should work on Oracle. However i'm getting strange errors when inserting records through a parametrized query. My formatted query looks like this: "INSERT INTO layer_mapping VALUES (@lm_id,@lm_layer_name,@lm_layer_file);" Unlike Npgsql which documents how to use th...
SQL Server is able to return the results of multiple queries in a single round-trip, e.g: select a, b, c from y; select d, e, f from z; Oracle doesn't like this syntax. It is possible to use reference cursors, like this: begin open :1 for select count(*) from a; open :2 for select count(*) from b; end; However, you incur a ...
Hello: Some months ago, a colleague of mine installed ODAC 11.106.21 in a server using XCOPY and then he developed many applications that use this client without problems (in test and production windows servers). Past week, I developed an application under ODAC 11.1.07.20. When I asked him to install these new ODAC version using XCOPY ...
I use Oracle's specific data provider (11g), not the Microsoft provider that is being discontinued. The thing I've found about ODP.NET is how picky it is with data types. Where JDBC and other ADO providers just convert and make things work, ODP.NET will throw an invalid cast exception unless you get it exactly right. Consider this code:...
Converting to ODB.NET from System.Data.OracleClient and need help converting my connection string. Here is what I use with System.Data.OracleClient. SERVER=(DESCRIPTION_LIST=(LOAD_BALANCE=yes)(FAILOVER=ON)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.80)(PORT=9960))(ADDRESS=(PROTOCOL=TCP)(HOST=172.26.140.81)(POR...
Hello, due to the lack of an testing environment I need to know if the following scenario will work: I have installed the Oracle Data Provider for .Net version 9.2.0.4. In production I'll have to communicate from my C# application with two Databases, an Oracle 8i and 9i. Does Oracle 8i support Bind Variables in this scenario? I'm li...
We have ASP.NET framework 3.5 hosted in Windows 2003 Server 32-bits. Database: Oracle 10gR2 in Windows 2003 Server 64-bits We should use ODP.NET 10.2.0.3. Questions: - Is ODP.NET 10.2.0.3 made to connect to a 32bit or 64bit Oracle database? - Is the same for Oracle Client? ...