SQLSTATE = 22005 [Oracle][ODBC][Ora]ORA-01722: invalid number

environment:

• clients pc: windows XP sp2/sp3
• oracle 11g
• powerbuilder 9 
• connection use ODBC to oracle server

some users use windows XP have error message as below:
SQLSTATE = 22005
[Oracle][ODBC][Ora]ORA-01722: invalid number
No changes made to database.

when changes value use combo box

below step to solve at clients PC:

• please unisntall previous oracle clients at their PC,
• remove ODBC setting and environment DLL for powerbuilder
• reinstall oracle again and 
• re setting path DLL files for powerbuilder in environment variabel.

transaction not connected on oracle and PowerBuilder 9

sometime we got message when develop login form use Powerbuilder 9 and oracle11g database:
At this issue: the PC installed Oracle11g & PB9 both.
open lgin form from PB is ok , but when open application file (exe file). Got message:

"Transaction not connected"

no detail information about it;
please check below:
(1) make sure that PB...90.DLL not double in that PC.
(2) if have double PB...90.DLL please going to control panel - system - environment - path
(3) then check the path only pointed to ONE LOCATION of PB...90. DLL

hope this help you

he he he