Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error #10036 - TDS State Machine Error

2 posts in Windows NT Last posting was on 1998-05-01 13:46:47.0Z
Paul Morris Posted on 1998-04-27 05:49:36.0Z
From: pmorris@phoenixint.com (Paul Morris)
Subject: Error #10036 - TDS State Machine Error
X-Newsreader: News Xpress 2.01
Date: Mon, 27 Apr 1998 05:49:36 GMT
Message-ID: <7gZwt7Zc9GA.164@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Lines: 14
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com!pjm
Xref: forums-1-dub sybase.public.sqlserver.nt:5052
Article PK: 1092416

Hi,

I have a program written in Centura that fetches back a result set of about
30,000 rows for updating, after about 4,500 updates I get the following
error:-

"There is a tds state machine error. An illegal tds token sequence was
received."

What causes this, and what do I need to do to avoid it?


Server
---------
SQL Server/11.0.3/P/PC Intel/Windows NT 3.5/2/OPT/Tue Jul 15 1997 16:23:08.22

Client
--------
Windows 95, 32Mb using named pipes


Thanks
Paul Morris
--
Phoenix International AP
Wellington
New Zealand


David Pascuzzi Posted on 1998-05-01 13:46:47.0Z
Message-ID: <3549D247.6011C06E@concentric.net>
Date: Fri, 01 May 1998 07:46:47 -0600
From: David Pascuzzi <pascuzzi@concentric.net>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Paul Morris <pmorris@phoenixint.com>
Subject: Re: Error #10036 - TDS State Machine Error
References: <7gZwt7Zc9GA.164@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5042
Article PK: 1092408

Sounds like an internal error.
You should not be able to get a Tabular Data Steam Error.

You need to open a case on this one.

Paul Morris wrote:

> Hi,
>
> I have a program written in Centura that fetches back a result set of about
> 30,000 rows for updating, after about 4,500 updates I get the following
> error:-
>
> "There is a tds state machine error. An illegal tds token sequence was
> received."
>
> What causes this, and what do I need to do to avoid it?
>
> Server
> ---------
> SQL Server/11.0.3/P/PC Intel/Windows NT 3.5/2/OPT/Tue Jul 15 1997 16:23:08.22
>
> Client
> --------
> Windows 95, 32Mb using named pipes
>
> Thanks
> Paul Morris
> --
> Phoenix International AP
> Wellington
> New Zealand