| Author |
PB10.2 component gets weird Oracle errors
|
|
| Roland Smith 2005-11-15, 1:24 pm |
| Our production components are all PB8 running on EAServer 4.2 and working
fine.
I am trying to create a new component with PB10.2 and EAServer 5.2. Our
Oracle server is 10g and the Oracle client I have is 9.2.
When my component tries to retrieve a datastore it gets error number 900
with SqlErrText -
Select Error: ????????????????
I try a simple select into in script and it gets error number 24333 and the
SqlErrText is all squares.
Here is the sql statement from the datastore:
select dist_num, dist_name from dist_names
Of course the datawindow runs fine with the dw painter.
Roland
| |
| Jim Egan 2005-11-15, 1:24 pm |
| rsmith@cvps.com wrote...
> Our production components are all PB8 running on EAServer 4.2 and working
> fine.
>
> I am trying to create a new component with PB10.2 and EAServer 5.2. Our
> Oracle server is 10g and the Oracle client I have is 9.2.
>
> When my component tries to retrieve a datastore it gets error number 900
> with SqlErrText -
> Select Error: ????????????????
>
> I try a simple select into in script and it gets error number 24333 and the
> SqlErrText is all squares.
>
> Here is the sql statement from the datastore:
>
> select dist_num, dist_name from dist_names
>
> Of course the datawindow runs fine with the dw painter.
I suspect this is a character set configuration problem.
--
Jim Egan [TeamSybase]
Sybase product enhancement requests:
http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
| |
| Roland Smith 2005-11-15, 8:25 pm |
| The character set in EAServer is iso_1. Should I chaneg it to something
else?
"Jim Egan" < eganjp_nospam@compus
erve.com> wrote in message
news:437a3710$1@foru
ms-1-dub...
> rsmith@cvps.com wrote...
>
> I suspect this is a character set configuration problem.
> --
> Jim Egan [TeamSybase]
> Sybase product enhancement requests:
> http://www.isug.com/cgi-bin/ISUG2/submit_enhancement
| |
| Carson Hager 2005-11-15, 8:25 pm |
| Switch the connection cache type to the unicode version.
Carson
____________________
____________________
____
Carson Hager
Cynergy Systems, Inc.
http://www.cynergysystems.com
Email: carson. hager@cynergysystems
.com
Office: 866-CYNERGY ext. 89
Mobile: 1.703.489.6466
Take PowerBuilder to the Web with EAF 4.0
http://www.cynergysystems.com/public/products/eaf
"Roland Smith" <rsmith@cvps.com> wrote in message
news:437a3ce7@forums
-1-dub...
> The character set in EAServer is iso_1. Should I chaneg it to something
> else?
>
> "Jim Egan" < eganjp_nospam@compus
erve.com> wrote in message
> news:437a3710$1@foru
ms-1-dub...
>
>
|
|
|
|