Have you recently upgraded to IB6 from IB5.x? This is a sign that you have
the wrong version of GDS32.DLL lurking somewhere. Check your disk and look
at the timestamp of the file.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <bobzirbel@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, February 26, 2001 3:07 PM
Subject: [IBO] Re: SQL error -804 and Win2000


> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > It might help if you included the SQL trace of the error.
> >
>
> Thanks for your reply Jason.
>
> Following is the SQL trace if I execute 'select * from class'.
> 'select code, description from class' works OK.
>
> PREPARE STATEMENT
> TR_HANDLE = 13647736
> STMT_HANDLE = 13646592
> select * from CLASS
> PLAN (CLASS NATURAL)
> FIELDS = [ Version 1 SQLd 3 SQLn 1
> CLASS.CODE = <NIL> ]
> SECONDS = 0.020
> ----*/
> /*---
> EXECUTE STATEMENT
> TR_HANDLE = 13647736
> STMT_HANDLE = 13646592
> PARAMS = [ ]
> SECONDS = 0.010
> ----*/
> /*---
> INTERPRETE BUFFER =
> ERRCODE = 17
> ----*/
> /*---
> INTERPRETE BUFFER = Dynamic SQL Error
> ERRCODE = 21
> ----*/
> /*---
> INTERPRETE BUFFER = SQL error code = -804
> ERRCODE = 39
> ----*/
> /*---
> INTERPRETE BUFFER = Incorrect values within SQLDA structure
> ERRCODE = -1
> ----*/
> /*---
> COMMIT
> TR_HANDLE = 13647736
> ----*/
>
> Thanks for your help.
>
> Bob
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>