Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Text Column Error while retrieving through READTEXT
0 views
Skip to first unread message
Sam
Jul 1, 2009, 5:26:19 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.
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
0 new messages