Invalid character value for cast specification

[lelanordquist]

Hello!
Using PB 9.0.1 build 6533, SQL Server 2000. I usually work
with DB2 dbs so perhaps this is i cinch to solve... I've
tried to create a datawindow based on a procedure but get
"cannot create datawindow, invalid character value for cast
specification". The procedure has 2 in params, both
varchar(8) in the proc and so both ret args in PB are type
string.
I can create the datawindow based on SQL select but the
first retrieve is so slow the app nearly hangs itself so I
need to use a stored proc. Do I need to adjust the settings
of the db profile in PB? Haven't changed the default values.
The strings are actually numbers so I've even tried using
int for the in-params in the proc and then convert to
varchar(8) and number for the ret args in PB but get the
same message. What am I doing wrong?

[Lela]

FOUND THE ANSWER MYSELF (while skimming through other
problems in this newgroup - CallEscape should not be used!).
THANKS JUST THE SAME!

[Sanjiv Das [TeamSybase]]

Lela,

Are you using ODBC to connect to SQL Server 2000 ? Have you tried the OLE DB
database driver ? If you are building an app that needs to work with
multiple DBMSs, then ODBC may be a good approach. If all you need is SQL
Server, you might want to try a native driver using OLE DB.

Sanjiv.

<Lela> wrote in message news:4153d06b.630...@sybase.com...