Protocol error in TDS stream

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
mig229
Posts: 3
Joined: Thu 11 Sep 2008 13:07

Protocol error in TDS stream

Post by mig229 » Thu 11 Sep 2008 13:30

Hi, I have a problem.
I migrate from 2000 to 2005 ms sql server. Client application write on Delphi 7 Enterprise and use SDAC 3.80. When i run an application i have error message "protocol error in tds stream". I download sdac 4.5 trial, but the problem is not disappear.
ms sql server version - Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 11 Sep 2008 15:52

Please, check that the MSConnection.Options.Provider property is set to prAuto.

mig229
Posts: 3
Joined: Thu 11 Sep 2008 13:07

Post by mig229 » Fri 12 Sep 2008 06:52

When I set MSConnection.Options.Provider property to prAuto I have error message "communication link failure"

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 15 Sep 2008 07:55

SDAC requires OLE DB installed on workstation.
Please check if you can to connect to MS SQL server 2005 using MS SQL Server Management Studio.

mig229
Posts: 3
Joined: Thu 11 Sep 2008 13:07

Post by mig229 » Mon 15 Sep 2008 08:35

I can connect to MS SQL using Managment Studio.

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 16 Sep 2008 11:29

Please give a more detailed description of the problem.
What provider do you use?
Try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Protocol error in TDS stream

Post by Vladimir » Tue 30 Sep 2008 16:14

If you profile, you will notice that prior to whatever SQL statement you execute that causes error, you will see

SET NO_BROWSETABLE ON
some other SQL here.

try to paste that into query analyzer and you will get the same error there.

If this code is stored proc, inside that proc add
SET NO_BROWSETABLE OFF

Get the latest cumulative update for SQL 2005, at least 6
If you execute this on connection, then it will not fail.
DBCC TRACEON(210,-1)

After installing Cumulative Update 6, to make it available every time you start SQL, you have to also set a startup parameter of -T210 or do the following after starting SQL Server.
DBCC TRACEON(210,-1)
Go
hopefully this helps.

In adidtion, this problem seems to be solved in SQL 2008.

Lithium™
Posts: 42
Joined: Wed 23 Jun 2010 06:42

Re: Protocol error in TDS stream

Post by Lithium™ » Thu 26 Apr 2012 13:07

Vladimir wrote: hopefully this helps.
In adidtion, this problem seems to be solved in SQL 2008.
Thanks, it helps me too. In SQL 2008 this problem is not solved.

Post Reply