Protocol error in TDS stream

mig229 · 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 · Post by **Dimon** » Thu 11 Sep 2008 15:52

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

mig229 · 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 · 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 · Post by **mig229** » Mon 15 Sep 2008 08:35

I can connect to MS SQL using Managment Studio.

Dimon · 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 · 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™ · 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.

Devart Forums