PowerBuilder 9.0.2 native Oracle driver for Oracle 10g database
We are migrating from Oracle 8i to 10g. The PowerBuilder
9.0.2 application is extremely slow using PowerBuilder
Oracle 8.4 or 9.0 native driver to connect to Oracle 10g
database, We had to use 7.3 driver. After using trace we
found that the SQL scripts with index hint cause slow down,
but they are working ok using Oracle 8.4 driver with Oracle
8i database. Any suggestion which is best way to connect
from PowerBuilder 9.0.2 to Oracle 10g database? We have
tried the Oracle 8.1.7 client and Oracle 9.0 client.
I found a solved case on Sybase support web site, but we do
not have support...PowerBuilder 9.0.1: Connect to Oracle Using the PowerBuilder Native Driver
Could anyone please email me this Solved Cases? It may be
related to our production issue.
Thanks in advance,
The first one only affects the development environment, and the second
one is only applicable to datawindows build with the old PBDBMS
What problems are you having?
On 12 Oct 2004 08:56:32 -0700, John Shi wrote:
>Could anyone please email me this Solved Cases? It may be
>related to our production i...Powerbuilder 9.0 Migration from powerbuilder 7.0.3 problem
i was trying an migrate an powerbuilder 7.0.3 application to powerbuilder
9.0(PFC BASED APPLICATION (PFC objects version PB 6.5) ) during migration i am
getting this error.
tcmborrower.pbl(w_cursor_check).w_cursor_check.open.2: Error C0163: The
definition of referenced global variable sqlca was improperly compiled in object
Did anybody faced this kind of error?
---== Posted via the PFCGuide Web Newsreader ==---
First error message which i got during the migration is :
tcmappl.pb...PowerBuilder 9.0 and PowerBuilder 10.0
Hello NG ,,,
I have a strange problem , installed both versions of PowerBuilder on the
same machine having Windows XP.
under Program files\Sybase9 - > PB9.0 was installed .
under Program files\Sybase10- > PB10.0 was installed,
I was working on XML workspace in PB9.0 where in the library list
PBDOM90.PBD was included. By mistake , I opened the same workspace in PB10.0
and the application was migrated completed.
Later coming back to PB9.0 and opening the same workspace , found that , in
the system tree PDB files has zero object, It is not showing anything and
the appl...hints expression oracle 9.0 in Powerbuilder 9.0
Hello cheers to all.
I got this sql from Orable 9.0, we need to put a hint expression in this sql
to improve the performance on the execution of the sql, well i dont know if
this run fine in sql embeded, because this expression use /* */ operator,
like the following example. In powerbuilde these operators are used to
put comments in the script..
SELECT /* + INDEX ("CB_MOV_PAG" "CB_MOV_PAG1") */
WHERE ( "CB_MOV_DET"."COD_CIA"...Where can I get native PB drivers for ( Oracle Version 22.214.171.124) with Oracle Net Client Version 7.3.3
( Oracle Version 126.96.36.199) 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 188.8.131.52) with Oracle Net Client Version 7.3.3 with SQL
> *Net version 2...Powerbuilder 8.0.3 AND Oracle 9
We're migrating existing Powerbuilder 6.5 apps to Powerbuilder 8.0.3. What
kind of databases are supported by PB 8.0.3? We would like to use an
Oracle 9 database.
Can we connect to an Oracle 9 database using PB 8.0.3???
Thanks for your help!!!
<MattC> wrote in message
> We're migrating existing Powerbuilder 6.5 apps to Powerbuilder 8.0.3.
> kind of databases are supported by PB 8.0.3? We would like to use an
...Powerbuilder 9.0 vs. Powerbuilder 8.0
What is the difference in Powerbilder 9.0 and 8.0?
I would like to point out that the Appeon newsgroup is monitored by Sybase
and Appeon engineering staff who are very knowledgeable about Appeon issues.
Question that are purely PowerBuilder-related are best answered by the staff
and users of the PowerBuilder newsgroup: sybase.public.powerbuilder.XXXX.
Please post to the appropriate newsgroup so you receive the help you desire.
<email@example.com> wrote in message
> What is the diffe...PowerBuilder Oracle Driver for Oracle 8.0.4 and 8.0.5
You may now register for the beta program for the PowerBuilder O84 native
driver at the following URL
Has anyone been using this? Any comments?
On Mon, 14 Dec 1998 11:32:31 -0500,
Dan Skibba <firstname.lastname@example.org> wrote:
>You may now register for the beta program for the PowerBuilder O84 native
>driver at the following URL
One of the things you do when you sign up for a beta ...Powerbuilder 10.0 Microsoft Native Database Driver...
I installed Powerbuilder 10.0 but couldn't find Microsoft Native
Database Driver for SQL Server...I tried even Custom option but still
didn't see anywhere...
Am I missing something or is it in different place ??
Native for MS SQL Server is OLE_DB(MSSQLDB) or ADO.NET
PB's MSS driver is based on db-lib. MS has announced that it will no longer
provide db-lib on future SQL server releases.
MS has recommended other driver options for several years, namely ole-db and
db-lib was not Unicode compliant
"Verticent" <support@verticent...Issues with Powerbuilder 8.0.3 and Oracle 8i
We have application on powerbuilder 8.0.
We have applied 8.0.3 patch since then we are getting problem with computed
columns in datawindow. On computed columns with alias name and there is no
space between name and '' then pb gives ora-00904 invalid column name error.
Powerbuilder is putting "" quotes around the computed column with oracle.
Same datawindow works fine with SQL Server 2000 and sybase databases. It
used to work fine with PB8.0. In tace fine we saw the column is like this
"''address_title". We add space between column alias name ''...Powerbuilder 6.0
I am looking for oracle 8i native (NOT ODBC) driver for powerbuilder 6.0. Can
some one point me to the right place or provide me information on this. Thank
---== Posted via the PFCGuide Web Newsreader ==---
There is no native 8i driver in PB6 which has been end of lifed since Sept
2001. Oracle 8i support was introduced in PB7. You can however, use the
Oracle native driver for 8.0.4 for connectivity but you will not have access
to 8i features.
"Giri Vidapanakal" <email@example.com> wrote in m...Strange Oracle Issue with 184.108.40.206 and 220.127.116.11
I wonder if anyone has seen this issue ...
We have a successfully compiled DBD 1.12 and 1.14 running on a RedHat
7.2 server -- when setting RowCacheSize to a number more that 1000 we
garbled data -- Also using the -1000 value does the same. I have seen a
few tidbits of data on the net and Oracle's Metalink talking about a
possible bug with >= 18.104.22.168 Oracle but to patches and no bugs reported.
The problem disappears with setting RowCacheSize to something small like
100 or 0. Also the problem is not seen <= 22.214.171.124 Oracle Client. I am
about to write up a TAR on this with Ora...PowerBuilder 9.0.3 and Oracle 10 64bit client
We are trying to connect PowerBuilder 9.0.3 app to Oracle 10
64bit client on terminal server.
Are there any known issues?
When app launches, error appears saying OCI cannot be
Installing 32bit oracle client works fine.
Does Oracle support this? It would require them to have a 'thunking'
layer to handle the 32-bit to 64-bit translation. Presuming Oracle
can make the 64-bit client behave in a 32-bit mode, I would think
you'd be ok, but this is definitely not a configuration that we test
On 9 Oct 2006 05:58:27 -0700, Uro...