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.

Urgent! - SYJ native interface and SQL return codes

2 posts in General Discussion (old) Last posting was on 2000-03-10 15:04:57.0Z
Andre Solstrand Posted on 2000-03-09 22:02:23.0Z
Newsgroups: sybase.public.easerver
From: "Andre Solstrand" <asolstra@online.no>
Subject: Urgent! - SYJ native interface and SQL return codes
Date: Thu, 9 Mar 2000 23:02:23 +0100
Lines: 42
Organization: BBS
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: ti01a68-0045.dialup.online.no 130.67.11.45
Message-ID: <347_qqlJiQhi$GA.71@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26745
Article PK: 157734

Hi!

I'm using PB 7.0.2 build(8017) and Jaguar 3.5 with EBF1.

I have personally reportet this bug to sybase support before:

When my app submit incorrect syntax to ASE or call stored procedure/triggers
that raise
errors, the SQLCA.Sqlcode and SQLCA.sqldbcode are still valued to 0. Error
messages are logged into the srv.log file of Jaguar correctly but I can't
detect
the error in the code.

Support told me that the problem should be fixed by uppgrading to
Jaguar 3.5 with EBF1 and PB 7.02 build 8011 or higher.

We have uppgraded and know the PB-klient "crashed" and we recieve the
following errorcode!
PB-runtime error: invalid reference at line 1 (R 0002).....(Tried using
both native interface and ODBC)
We are using PB-NVO on Jaguar CTS.

My company is starting systemtest on monday 13.3.2000 and if we not have the
solution to this problem by tomorrow we are stuck with PB 7.0.1 and EAS 3.01
using ODBC to connect to an SYBASE ADAPTIVE SERVER ENTERPRISE DATABASE
(Hm....)

Because EAS 3.01 and ODBC have no problem with detecting errors from
triggers/stored procedure.

Can anyone help us with this problem! I willl also contact support tomorrow,
but because of short time left i hope that somebody else have expirenced
this problem and know the solution to the problem.

Because og all the problems we have experienced with jaguar and dynamo, we
will not risking uppgrading EAS 3.01 after starting the system test.

Andre Solstrand
BBS
Norway


Ashish Mahajan Posted on 2000-03-10 15:04:57.0Z
Newsgroups: sybase.public.easerver
From: "Ashish Mahajan" <ash@NOSPAM.com>
Subject: Re: Urgent! - SYJ native interface and SQL return codes
Date: Fri, 10 Mar 2000 10:04:57 -0500
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: pikachu.sybase.com 204.167.42.191
Message-ID: <347_z#AmNKqi$GA.201@forums.sybase.com>
References: <347_qqlJiQhi$GA.71@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26688
Article PK: 157687

The problem with SQLCA not reporting errors has been fixed recently. I
assume that support gave you the correct build no.s
With the upgrade you are facing new problems... To me it looks like the
client proxies need to be regenerated... See if that works

-Ashish

"Andre Solstrand" <asolstra@online.no> wrote in message
news:qqlJiQhi$GA.71@forums.sybase.com...
> Hi!
>
> I'm using PB 7.0.2 build(8017) and Jaguar 3.5 with EBF1.
>
> I have personally reportet this bug to sybase support before:
>
> When my app submit incorrect syntax to ASE or call stored
procedure/triggers
> that raise
> errors, the SQLCA.Sqlcode and SQLCA.sqldbcode are still valued to 0. Error
> messages are logged into the srv.log file of Jaguar correctly but I can't
> detect
> the error in the code.
>
> Support told me that the problem should be fixed by uppgrading to
> Jaguar 3.5 with EBF1 and PB 7.02 build 8011 or higher.
>
> We have uppgraded and know the PB-klient "crashed" and we recieve the
> following errorcode!
> PB-runtime error: invalid reference at line 1 (R 0002).....(Tried using
> both native interface and ODBC)
> We are using PB-NVO on Jaguar CTS.
>
> My company is starting systemtest on monday 13.3.2000 and if we not have
the
> solution to this problem by tomorrow we are stuck with PB 7.0.1 and EAS
3.01
> using ODBC to connect to an SYBASE ADAPTIVE SERVER ENTERPRISE DATABASE
> (Hm....)
>
> Because EAS 3.01 and ODBC have no problem with detecting errors from
> triggers/stored procedure.
>
> Can anyone help us with this problem! I willl also contact support
tomorrow,
> but because of short time left i hope that somebody else have expirenced
> this problem and know the solution to the problem.
>
> Because og all the problems we have experienced with jaguar and dynamo, we
> will not risking uppgrading EAS 3.01 after starting the system test.
>
> Andre Solstrand
> BBS
> Norway
>
>