Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Having trouble with a DW getting the return of a 'raiserror' commnad from a stored proc.

2 posts in DataWindow Last posting was on 2008-12-10 22:58:20.0Z
Vollie Sanders Posted on 2008-12-05 20:56:41.0Z
From: "Vollie Sanders" <vollie.sanders@norstan.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Having trouble with a DW getting the return of a 'raiserror' commnad from a stored proc.
Lines: 883
Organization: Norstan
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49399589@forums-1-dub>
Date: 5 Dec 2008 12:56:41 -0800
X-Trace: forums-1-dub 1228510601 10.22.241.152 (5 Dec 2008 12:56:41 -0800)
X-Original-Trace: 5 Dec 2008 12:56:41 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88320
Article PK: 417579

Not sure if this belongs in Datawindows or Database.
But will start here and can move if need be.
We just migrated from PB10.2 to PB11.2 and have been using MS SQL2000 since
2002 or there abouts.
We have a DW built in our app that uses a Stored Proc as its source.
In the proc if we use the 'raiserror' command returning a error code and a
description.
When ran in PB11 (see attached Doc for version #'s of PowerBuilder and
sqloledb connect dll's.)
We get an entirely different return than when ran from PB10. (see attached
for screen shots and debug research)
Any suggestions or recommendations would be greatly appreciated.


Vollie Sanders Posted on 2008-12-10 22:58:20.0Z
From: "Vollie Sanders" <vollie.sanders@norstan.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49399589@forums-1-dub>
Subject: Re: Having trouble with a DW getting the return of a 'raiserror' commnad from a stored proc.
Lines: 23
Organization: Norstan
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4940498c$1@forums-1-dub>
Date: 10 Dec 2008 14:58:20 -0800
X-Trace: forums-1-dub 1228949900 10.22.241.152 (10 Dec 2008 14:58:20 -0800)
X-Original-Trace: 10 Dec 2008 14:58:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88378
Article PK: 417632

Well Finally had to call a case into Sybase, due to no interest here.
Found out that this was a reported item and was corrected in Build 8616.
Downloaded most current Build 8669 and tried test and it is now corrected.

"Vollie Sanders" <vollie.sanders@norstan.com> wrote in message
news:49399589@forums-1-dub...
> Not sure if this belongs in Datawindows or Database.
> But will start here and can move if need be.
> We just migrated from PB10.2 to PB11.2 and have been using MS SQL2000
> since 2002 or there abouts.
> We have a DW built in our app that uses a Stored Proc as its source.
> In the proc if we use the 'raiserror' command returning a error code and a
> description.
> When ran in PB11 (see attached Doc for version #'s of PowerBuilder and
> sqloledb connect dll's.)
> We get an entirely different return than when ran from PB10. (see attached
> for screen shots and debug research)
> Any suggestions or recommendations would be greatly appreciated.
>
>