which is shou i use? Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET
Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NETI am confused?Which is better or which one should I use?BTW, I am going to use .net 2.0 with oracle 9. Can anyone tell me what shou I use for working with oracle database?Thanks very much in advance!Justin
Oracle's data provider has more functionality than Microsoft's.If your doing transaction processing you can have SAVEPOINTs, which Microsoft's data provider does not provide.Also, Oracle has PL/SQL Associative Arrays which are very powerful.Oracle also allows you to bind parameters by name and pos...urgent: .NET Provider for Oracle or Oracle Data Provider for .NET
If I want to access Oracle DB in ASP.NET application, and I am using .NET Provider for Oracle or Oracle Data Provider for .NET, should I have to install OracleClient on my .NET server? Is there other choice? Thank you very much.Johnson
Johnson2007:should I have to install OracleClient on my .NET server? You have to options1. install the ODP.NET on your web serverOR2. put the oracle assemblies in your BIN directory
Hi jimmy,Thank you for you reply. Because I could not find a server right now, I should test it first before I agree or disagree with you, as most articles I...Return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle
I am wondering if anyone in this community knows the shorter way to return an Oracle Ref Cursor to a .NET DataReader object by using the .NET Managed Provider for Oracle, something likereturn (IDataReader) SqlHelper.ExecuteReader(ConnectionString, "GET_ACCOUNT", Id);
instead of using the way below (look at the C# code)
Stored Procedure create or replace PROCEDURE "GET_ACCOUNT"
p_ID IN ACCOUNT.ID%type, retCursor OUT SA.MYGEN.sqlcur
OPEN retCursor FOR
ID = p_ID
...Which .Net Provider for Oracle 9i Microsoft or Oracle
Can anyone provide me pros and cons of provider to access Oracle Database ? I am aware of Microsoft Provider and Oracle Provider.
I guess you can use either. But as some post suggests, if both installed, then MS ODP will not work.
I've been using DataDirect Technologies Connect for .Net and Oracle. It's not free, so it depends on your budget.
The speed improvements were great for us, and it's ni....NET Oracle Provider
Hi all,I am using .NET 2.0 Frameworks Oracle provider and it does not have a OracleDbTypes Type for me to use. I would like to create a parameter that is of the Oracle type NVARCHAR, but it seems I can only use DbTypes, which does not have this. If I used DbTypes.String, would this be ok, otherwise, how else can I be more specific about the Oracle Parameter data type?Thanks
can u explain which type of data u r going to storeThank uBaba Thank uBabaPlease remember to click "Mark as Answer" on this post if it helped you.
What's your version of ODP? You have OracleD...Where can I get native PB drivers for ( Oracle Version 188.8.131.52) with Oracle Net Client Version 7.3.3
( Oracle Version 184.108.40.206) with Oracle Net Client Version 7.3.3 with SQL
*Net version 2.x , 32 bit implementation.
All versions of PB Enterprise (5,6,7) have the native O73 driver. If you
have PB Professional, you can only use ODBC to connect to Oracle.
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn
Veena Madhavi <firstname.lastname@example.org> wrote in message
> ( Oracle Version 220.127.116.11) with Oracle Net Client Version 7.3.3 with SQL
> *Net version 2...How call a Oracle Function using Microsoft .Net Oracle Client (System.Data.OracleClient)?
I try to call Oracle Function in .net C# by using System.Data.OracleClient. But i am not successful.
Here is my code
( vten varchar2)
RETURN boolean IS
select monthethao_id into montt_id from TTHAO_MONTHETHAO
where ten = vten;
if montt_id!=-1 then
when others then
I do not know, when I call function TTHAO_MONTT_E...Oracle ODP.net mulitple Oracle Client
To connect to the oracle database using ODP.net, the applicate must add the dll file called Oracle.DataAccess.
There are a lot of version of Oracle.DataAccess. As I know, if the client use Oracle Client 10g Release 2.
If the client use Oracle Client 10g Release 2, the application also have to use the Oracle.DataAccess the come from Oracle Client 10g Release 2.
My question is that there are any method to add more than one Oracle.DataAccess version in my product to support multiple OracleClient.
That should automatically happen for the most part. Oracle's ODP.NET i...DBD::Oracle and oracle client versions
Is anything 'baked-in' from the oracle environment to a DBD:Oracle
install at the time of installation?
I'm having some weird problems involving linked databases that MAY be
related to the oracle client libraries version; can I change the
libraries that DBD:Oracle uses just by changing LD_LIBRRY_PATH and
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
On Wed, Aug 27, 2008 at 11:41 AM, Bruce Johnson
> ...Oracle Spatial support in Devart's ADO.NET Data Provider for Oracle [Edit]
dotConnect for oracle v. 7.3 http://www.devart.com/dotconnect/oracle/ , ADO.NET Provider from Devart, includes support for Oracle Spatial in the projects, using Entity Framework.
Devart Team constantly implements all the available Entity Framework innovations, and shortly after the introduction of DbGeometry and DbGeography classes in Entity Framework 5 has implemented support for Oracle Spatial in the Entity Framework provider for Oracle. Oracle MDSYS.SDO_GEOMETRY object type can now be mapped to DbGeometry and DbGeography classes.
Now dotConnect for Oracle includes new versions of Devar...Version of Oracle ODP.NET client?
Does DW.NET 2.0 require a specific version of the ODP.NET client? I just
installed the latest version from the Oracle site (10.2.02) and I am
getting a strange exception on AdoTrans.BindConnection:
System.InvalidCastException: Unable to cast object of type
'Oracle.DataAccess.Client.OracleConnection' to type
at Sybase.PowerBuilder.Db.Block.OraBlock.GetConnect(Object input,
Dbms& dbms, DBVersion& dbVer, String& user)
at Sybase.PowerBuilder.Db.DbRoutine.GetConnect(DbDrivers type,
Object input, ...Oracle managed provider for .Net 2.0
Does ADO.Net 2.0 comes with Oracle Managed Provider too? If it's so, which is better to use, Oracle Managed Provider developed by Microsoft or by Oracle?
In ADO.Net 2.0 can I use data paging (bring only the ammount of data that will be shown on the actual page instead of bringing all the data every time we change the actual page)? How can I do this using Oracle 10g?Juliano NunesMCAD | MCP | Microsoft Student Partnerhttp://julianonetfox2.spaces.live.com
(Does ADO.Net 2.0 comes with Oracle Managed Provider too? If it's so, which is better to use, Oracle Managed Provider developed by Microso...MS Oracle Data Provider, Oracle Instant Client
I have seen very few posts about this, but I have to believe that it is possible.Does anyone know if you can connect to an Oracle DB using the Oracle Instant Client and the MS Oracle Data Provider? Downloading the Oracle Client can leave quite a large footprint on some servers. Thanks in advance!
Yes it is possible to connect to Oracle using Oracle Instant Client without having Oracle Client on the machine.
Currently Oracle Instant Client doesn't contain ODP.Net, Oracle is planning to release ODP.Net with Oracle Instant Client which in Beta version now.
You can get more in...DBD-Oracle and Oracle versions
From lurking around this mail list over the years,
I've seen numerous items relating to building=20
DBD-Oracle against a specific version of the Oracle
client software on *nix systems. =20
Example: if DBD-Oracle was built using version 9,=20
then the Oracle client is upgraded to 10g;=20
it is necessary to rebuild DBD-Oracle with the 10g client. =20
I have used Perl on HP/UNIX, AIX, Linux and Windows.
On the *nix systems, Perl came with the OS and I have
had to install the DBI and DBD-Oracle modules using=20
the standard make process. On windows, I used=20