Re: SQR With Sybase 10

[johnk@SUN4.MITI.COM]

     I would suggest getting SQR version 3.0.8 for SCO Unix/Sybase. I would
     doubt that any testing was ever done with V2.4 against a Sybase 10
     database.

     I remember a very old SQR bug with select statements that did not have
     a from table clause, for example: select getdate(). I can't remember
     if the error you are reporting was the same. I would expect it to fail
     on both 4.9 and 10 databases, so it does not appear to be the problem.

     John L. Kellogg
     MITI Technical Support

______________________________ Reply Separator _________________________________
Subject: SQR With Sybase 10
Author:  usa.net!SQR-USERS@netcomsv.netcom.com at Internet
Date:    16/01/96 9:22 AM


I'm trying to compile some SQR scripts using SQR 2.4 for Sybase, on SCO.
The server is Sybase 10 running on Aviion.

Some scripts are compiled OK.

For the others - I get error message similar to this:

Sybase DBCANCEL error in cursor 9:  (20296) Timed out waiting for server to
acknowledge attention.

Cursor 9 is:
  Cursor #9:
    SQL = select getdate()
    Compiles = 1
    Executes = 0
    Rows     = 0


When the server is Sybase 4.9 (Also on Aviion) all the scripts are compiled OK

When the client is Aviion (instead of SCO) running SQR 2.5, and the server is
the same Sybase 10 - it is also OK

Does anyone have any experience using SQR on SCO with Sybase10 as a server?
Does SQR 2.x on SCO CAN work with Sybase 10? What about SQR3?

Any help would be greatly appreciated
- Avi Algazy