Where can I get native PB drivers for ( Oracle Version 220.127.116.11) with Oracle Net Client Version 7.3.3
( Oracle Version 18.104.22.168) 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 22.214.171.124) with Oracle Net Client Version 7.3.3 with SQL
> *Net version 2...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...Connecting PB 5.0.03 to Oracle 8 (NT) through SQL Net v2 with driver for Oracle 7.3 of PB
Can anyone assist me on Connecting PB 5.0.03 to Oracle 8 (NT) through
SQL Net v2 with driver for Oracle 7.3 of PB ?
Thank you very much in advance.
Direct +30 94-464225
Senior Systems Engineer
Relational Technology S.A.
In article <34979B76.67A813A8@sybase.com.gr>, email@example.com says...
> Can anyone assist me on Connecting PB 5.0.03 to Oracle 8 (NT) through
> SQL Net v2 with driver for Oracle 7.3 of PB ?
> Thank you very much in advance.
> John Fotiadis
> Direct +30 94-464225
> Senior Systems Enginee....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
...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...DBD::Oracle with Oracle 10.1.3
I have new Oracle version 10.1.3 in sun4-solaries machine. My DBD:Oracle
version is 1.14. My cgi-perl applications were working fine with oracle 9g.
After getting oracle 10g, I changed DBD:Oracle Makefile.pl and run make and
make install commands. Did not have any problem during compilation. But my
cgi-perl applications do not work and I get the following error in log file
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/...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...Connecting to Oracle 7.3 and Oracle 8
We've developed several PB applications that use Oracle 7.3. Now, we're
moving some of the development to Oracle 8. We're trying to figure out how
to set up developers' machines in the interim so that all applications will
We have to decide which version of SQL*Net to use and which PB database
interface for each application. Can we use different SQL*Net and interface
on the same computer? So far, I can only use one version of SQL*Net during
runtime (whichever one comes first in the system path). Also, during
runtime, the PB database interface...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...DBD::Oracle (perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12, Solaris 8) make problems (fprintf)
The only fprintf warning I googled was at
Any suggestions appreciated. I'm assuming since the perl Makefile.PL ran
clean, I'm using kosher Oracle libraries (binaries worked with Perl 5.6.0).
Appended output of (in order):
gcc -c -I/app/oracle/product/8.0.3/rdbms/demo -I/app/oracle/product/8.0.3/rdbms
/public -I/app/oracle/product/8.0.3/plsql/public -I/app/oracle/product/8.0.3/net
work/public -I/app/oracle/product/8.0....Do I need to install both oracle 7.3 and oracle 8 clients to work my PB applications some with ora 7.3 and some ora 8?
My PB5 application uses Oracle 7.3 and PB8 applications uses oracle 8i. Do
I need to install both Oracle 7.3 and Oracle 8 clients to deploy my PB 5
and PB 8 application.
I've answered this elsewhere.
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
<Mulinti> wrote in message
> My PB5 application uses Oracle 7.3 and PB8 applications uses oracle 8i....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: 126.96.36.199: Dumpfile name 'portal0303010542 ' section number 1
mounted on disk file '/tmp/foo
Msg 3223, Level 20, Sta...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...