Name: Max Oliveira
Best off the best!!
Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.9.1b3) Gecko/20090305 Firefox/3.1b3
From URL: http://hendrix.mozilla.org/
Note to readers: Hendrix gives no expectation of a response to this feedback
but if you wish to provide one you must BCC (not CC) the sender for them to
...Bad performance with Oracle 9 (PB 8 and 9)
I am with a problem of performance in a application developed in PB8 and
connecting on Oracle 9. The problem occurs in a table that has a field DATE
as key. When generate the WHERE statement, it generates the following
information (Gotten through Trace of the PowerBuilder):
WHERE (EMPCOD = 1) and (CTANUM = 10000017) and (movdat =
TO_TIMESTAMP('1-09-1999 00:00:00', 'dd-MM-YYYY HH24:MI:SS '))
This command is incorrect, therefore if you to use TO_TIMESTAMP to
convert and to compare with a field DATE, the Oracle don't use the index.
The corr...PB 9 or PB 9.01
We have an old PB 6.5 app that we want to (finally) migrate to PB 9.
Should we go to PB 9.00 or PB 9.01 (which seems to generate a fair
number of GPFs from some of the posts we've seen).'
Which of the 2 versions of PB 9 are more stable in your opinion?
We don't need the new features that much, for us stability is the #1
Frankly speaking, we'd keep it on 6.5 if we could, but that old IDE
is so unusable by today's standards that we finally decided to
make the jump to version 9.
thanks in advance,
Stability really depends on your...Patches of ASA9 from 9.0 to 9.01 and 9.01 to 9.02
Anyone know where I can find these?
I installed ASA9 for X64 on my new server and tried to install the latest
EBF and it won't work because it is expecting to find ver. 9.02 and I've get
Thanks for any help,
In article <4c1fa601$1@forums-1-dub>, firstname.lastname@example.org says...
> For X64.
> Anyone know where I can find these?
> I installed ASA9 for X64 on my new server and tried to install the latest
> EBF and it won't work because it is expecting to find ver. 9.02 and I've get
...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"...PB 9.03 vs PB 9.02
What is better to use for already existing large client-server PB app?
In terms of stability, number of unfixed serious bugs, extra features...
We encountered lockup problems on some reports for our application with
9.0.3. I did lots of testing but couldn't pin down the cause, and the users
were getting frustrated. After a while I rolled back to 9.0.2 with EBF
7610, and this seems to be very stable.
Of course, the usual disclaimers apply: your mileage may vary, etc.
"Andrew" <email@example.com> wrote in message
news:4314fe5e@fo...Infomaker 9.0 Database profile in Oracle 9.0.1 interface
When I create a database profile using the Oracle 9.0.1
interface, I can literally specify absolutely any values I
want for Profile Name, Server, Login ID, and Password. I can
just make up anything I want and then connect to it and
Infomaker tells me I have an active database connection,
which seems strange since all of the information entered was
If I play along with it and try to create a new report, say
tabular using quick select, the tool thinks twice about it
and then shuts down, back to desktop. I never know when an
actual database connection is established. Any ideas he...BE 9 or ArcServe 9
OK- I'll open the Pandora's box and ask- ArcServe 9.0 or Backup Exec
For many years I was a die-hard ArcServe user- running it successfully
NetWare 3 up to NetWare 5. Moving to a new company we went ahead with
ArcServe (back in the 6.x days) and had nothing but problems to the
where we could no longer get it to load.
I switched to Veritas Backup Exec 8.5 and in 20 minutes was happily
up my systems. I'm still running that software on a NetWare 5.0
It's been stable as a rock, but I admit that ArcServe always had a
...Build dbd::oracle for both Oracle 8.x And Oracle 9.x
Can I build single dbd::oracle to work with both Oracle 8.1.7 and Oracle
running on the Server (Solaris 8) ? If yes, how ? If not, any other better
means to acheive this.
********** Confidentiality Notice **********
This electronic transmission and any attached documents or other
writings are confidential and are for the sole use of the intended
recipient(s) identified above. This message may contain information
that is privileged, confidential or otherwise protected from disclosure
under applicable law. If the receiver of this informati...DBD:Oracle for Oracle 9.0.2 and 9.2 ?
Currently in a project to convert our existing 7.3.4 and 8.1.7 Databases
to Oracle9i.( Either the 9.0.1 or 9.2 version ) Now I'm having some
problems connecting to some test databases I have setup. Do I need to
upgrade my perl version or Dbi / DBD version to be able to connect? I
keep getting the :=20
DBI->connect(servwhDBMET) failed: ORA-03113: end-of-file on
communication channel (DBD: login failed)
...PB 9/9.1 stability
I've great problems with Power Builder's stability.
I'm working on web application (using EAServer connection under PB) and my
PB is very very unstable.
I mention that it hangs on almost every 5 minutes.
These aren't my first problems with PB stability - in other company, with
other computers and earlier versions of PB I've got the same problems.
Does anybody know the solution? Or maybe it's Sybase PB's nature?
best regards rubikov
All our dynamic web content on our production site is running EAS version 5
with PB 9.0.1 (next ...PB 9 Desktop and ASA 9
As directed, I installed ASA 9 before installing PB 9 Desktop, but have
run into difficulty.
First, I unchecked the option to install ASA 8.01 during the PB install.
The install did not detect ASA 9 and therefore did not install the
demo db and samples (I would like them).
Second, PB does not recognize the ASA 9 databases when I configure PB to
Any help would be appreciated.
...FW: Build dbd::oracle for both Oracle 8.x And Oracle 9.x
I have build DBD::Oracle for 9.2.0 and works good on target Oracle 9.2.0 but
when I try to connect to 8.1.7 I get following error:
DBI connect('','lut',...) failed: ERROR OCIEnvNlsCreate (check ORACLE_HOME
and NLS settings etc.) at
=20dbi8.pl line 11
Help is appreciated.
The script dbi8.pl is as below:
...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...