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...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 <email@example.com> wrote in message
> ( Oracle Version 220.127.116.11) with Oracle Net Client Version 7.3.3 with SQL
> *Net version 2....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...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
...Error: Can't load '/cygdrive/c/Oracle/Ora81/bin/Oracle' for module DBD::Oracle...
Here is what's going on:=20
1. I am running the latest release of CygWin on a Windows XP
machine. I am not running ActiveState Perl.
2. I installed DBI and tested it. Looks like it's working fine. I
perl -MDBI -e 0
at the ...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...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...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...Getting Error Message "Can't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll" While Connecting to Oracle
Content-Type: text/plain; charset=iso-8859-1
I am trying to configure an Oracle connection from Perl running on a Window=
s 7 desktop to an Oracle 11g database running on Linux; however the databas=
e connection step is failing.=0A=0AThe following line of perl code fails:=
=0A=0A=A0 =A0use DBD::Oracle;=0A=0ABelow is the full error message:=0A=0ACa=
n't load 'C:/Perl64/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle:=
load_file:%1 is not a valid Win32 application at C:/Perl64/lib/D...how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can i use membership and roles with Oracle 10g & VS 2.0
Hi all, Can any one tell me how to implement login module using Oracle 10g database (logic & Oracle 10g Queries) and how can I use membership and roles with Oracle 10g & vs 2.0. , for implement this is it compulsory to install oracle 10g server on the same machine on which I'm implementing this task or otherwise i can use other system as a server (like remote login or client server)
Hi,You should have the Oracle 10g Server or Client In your machine.In Case Client is in your Machine then Server Must be somewhere,that is enough to use.I hope then we ...Restore
I'm trying to restore a 12.x database taken from one environment into
another. I'm getting the following error (names changed to protect the
1> use master
1> load database foo from "/tmp/foo"
Backup Server session id is: 67. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 18.104.22.168: Dumpfile name 'portal0303010542 ' section number 1
mounted on disk file '/tmp/foo
Msg 3223, Level 20, Sta...oracle RAC and Oracle 11gR2 installation with oracle ASM
how to perform oracle RAC 11gR2 and Oracle Database 11gR2 installation
with oracle ASM on open SUSE 11.1 x86_64??
what short of package to find for oracle ASM and OCFS??
You need to download the rac and asmlib stuff from oracle.
You then need to present san storage to each node.
You will then need to stamp each asm lun with
/etc/init.d/oracleasm createdisk NAME /dev/sandevice.
------------------------------------------------------------------------...Can DBD::Oracle connect to various versions of Oracle?
I've been wondering. We support a number of clients running various
versions of Oracle and I'd like to have just one copy of DBD::Oracle that
would be able to connect to them all. We currently have some custom Pro*C
apps and to hear the developers talk about it, they have to be compiled
alot differently for each version of Oracle they want it to run against.
Is it possible to have one copy of DBD::Oracle that'll work with Oracle 7, 8
and maybe even 9?
David Good David.Good@stratasource.com
This space inte...Replicating Oracle to Oracle
How do I use replication server to replicate between two oracle databases
when some of the tables to be replicated has no primary key or unique index
We'll apreciate your contributions.
Covenant Visions Int'l
In Sybase, you can create clustered index on the unique key in the table and
use the unique key as your primary key in the replication definition. It should
work in oracle as well since that functionalilty is built in repserver and not
Femi Olumofin wrote:
> How do I use replication server to re...