I'm running Sybase IQ client on an AIX 5.3 machine which connects to a Sybase IQ server running on an AIX 6.1 machine.

I am able to connect using isql and using Perl DBI.

My problem is that sometimes even my simple SELECT queries fail with the below error messages in the DBI trace log file.

Surprisingly my connection to the server remains active and idle. I have to manually terminate the process or else it just sits there doing nothing for a long period of time.

I've been given to believe that this may be related to the Sybase IQ configuration or the network configuration but I'm not sure where to look for the problem or what the solution would be. Any thoughts, anyone?

OpenClient error message below:


Message String: ct_results(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.
' (err#0)
<- execute= undef at TableDef.pm line 266
-> DESTROY for DBD :: Sybase :: st (DBI::st=HASH(0x30948b38)~INNER)
ERROR: 50 'OpenClient message: LAYER = (4) ORIGIN = (1) SEVERITY = (5) NUMBER = (28)
Server bhedw_dev, database
Message String: ct_results(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.
OpenClient message: LAYER = (1) ORIGIN = (1) SEVERITY = (1) NUMBER = (50)
Server bhedw_dev, database
Message String: ct_cmd_drop(): user api layer: external error: The connection has been marked dead.