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.

ODBC error 999 - accessing DB/400 database

2 posts in Database Last posting was on 1999-05-11 15:39:51.0Z
toto Posted on 1999-05-11 09:17:56.0Z
Newsgroups: sybase.public.powerbuilder.database
From: "toto" <toto@titi.com>
Subject: ODBC error 999 - accessing DB/400 database
Date: Tue, 11 May 1999 11:17:56 +0200
Lines: 13
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <356_$jdEk14m#GA.263@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:13440
Article PK: 305837

Hi everyone,
I use client access and powerbuilder 6.5 and I have an ODBC
error when I try to access to my data in a library on our AS400 server
via a datawindow.
The error message is "Error 999 (rc-1) : An error occured, yet no message
was returned by the database driver"
This problem only appen where I generate
a run-time of my app and my datawindow works fine in "preview" mode. Did
anyone experience such a problem ?
Thanks for your help.


Jim O'Neil [Sybase] Posted on 1999-05-11 15:39:51.0Z
Newsgroups: sybase.public.powerbuilder.database
Date: Tue, 11 May 1999 08:39:51 -0700
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: ODBC error 999 - accessing DB/400 database
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 30
Message-ID: <356_37384F47.9CF86389@sybase.com>
References: <356_$jdEk14m#GA.263@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.database:13438
Article PK: 305835

That message means that a previous call that PowerBuilder made to the driver
resulted in the associated ODBC API call returning with an error code. The
next thing that PowerBuilder does is try to get specifics on the error
(SQLCode, error text, etc.). The 999 comes about when the driver responds to
PowerBuilder's request for error information with the equivalent of "what
error, I didn't see an error!" To get to the bottom of this, you'll need to
run an ODBC trace (NOT a PB Trace) and take a look for where the SQLError
statement is issued - right above that there should be a better indication of
what really happened.

Jim O'Neil
Sybase Technical Support
joneil@sybase.com

toto wrote:

> Hi everyone,
> I use client access and powerbuilder 6.5 and I have an ODBC
> error when I try to access to my data in a library on our AS400 server
> via a datawindow.
> The error message is "Error 999 (rc-1) : An error occured, yet no message
> was returned by the database driver"
> This problem only appen where I generate
> a run-time of my app and my datawindow works fine in "preview" mode. Did
> anyone experience such a problem ?
> Thanks for your help.