datawindow procedure sql2000

[Rottdpogs]

please advice. im having "data-conversion resulted overflow" eror, im creating a datawindow (stored procedure). thanks in advance.

 

[mbalent]

Are you using any non-Powerbuilder supported datatypes in the result set?

Matt

"Nature forges everything on the anvil of time

 

[Rottdpogs]

mbalent, im not using any non-powerbuilder supported datatypes. actually if i use adaptive server anywhere database engine, it works fine. but if switch to sql server 2000 im receiving "data-conversion resulted overflow" error. im creating datawindow using a stored procedure. please advice, thanks in advance.

 

[pullesj]

Rottdpogs,

Can you call the SQL Server stored procedure via MS Query Analyzer passing the exact same data parameters to the query? MS SQL Server may be encountering a data conversion problem which has nothing to do with PB.

Good Luck.