Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Text Column Error while retrieving through READTEXT

21 views
Skip to first unread message

Sam

unread,
Jul 1, 2009, 5:36:10 AM7/1/09
to
ASE server is terminating when I reposition the starting
column in Sybase 15 version. Execution 1, executes well and
returning row, but execution 2 does not executes and end up
with the error ASE server is terminating.

Execution 1: Not getting any errors
[
DECLARE @ptr varbinary(16)
SELECT @ptr=TEXTPTR(doc_text) FROM ttextdoc
READTEXT ttextdoc.doc_text @ptr 1 2000
]

Execution 2: Getting error when repositioning
[
DECLARE @ptr varbinary(16)
SELECT @ptr=TEXTPTR(doc_text) FROM ttextdoc


READTEXT ttextdoc.doc_text @ptr 2001 2000
]

Error: �08:14:52.023 DBMS IRLD3R301V15 -- Layer
(5), Origin (2), Severity (7), Number (12) ct_send():
network packet layer: internal Client Library error: State
error: trying to write when connection is expecting a
read.â�


Please help.
Thanks in advance

Rob V [Sybase]

unread,
Jul 1, 2009, 7:08:06 AM7/1/09
to
<Sam> wrote in message news:4a4b2e0a.7be...@sybase.com...

ASE server is terminating when I reposition the starting
column in Sybase 15 version. Execution 1, executes well and
returning row, but execution 2 does not executes and end up
with the error ASE server is terminating.

Execution 1: Not getting any errors
[
DECLARE @ptr varbinary(16)
SELECT @ptr=TEXTPTR(doc_text) FROM ttextdoc
READTEXT ttextdoc.doc_text @ptr 1 2000
]

Execution 2: Getting error when repositioning
[
DECLARE @ptr varbinary(16)
SELECT @ptr=TEXTPTR(doc_text) FROM ttextdoc


READTEXT ttextdoc.doc_text @ptr 2001 2000
]

Error: �?o08:14:52.023 DBMS IRLD3R301V15 -- Layer


(5), Origin (2), Severity (7), Number (12) ct_send():
network packet layer: internal Client Library error: State
error: trying to write when connection is expecting a

read.�?�


Please help.
Thanks in advance

This topic has nothing to do with product futures, which is what this
newsgroup is for.
Please post in an approriate newsgroup, like sybase.public.ase.general.

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------


0 new messages