Devart Forums

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)

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

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

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.

I can connect to MS SQL using Managment Studio.

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.

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.

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.