Protocol error in TDS stream
Fred Vreeswijk
When executing a view created in SQL server 6.5 with ISQL/W (Select * from
vwDeelnemers) it retrieves all of the wanted records. When i retrieve the
amount of found records with the string (Select count(*) from vwDeelnemers)
it gives me the right amount of records.
When i execute the select Query in a program, which connects to the SQL
Server with a rdo connection it also retieves the wanted records, BUT when i
execute the query (Select Count(*) from vwDeelnemers) it returns the
following error:
S1000: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
the rdoError object gives me the folowing infomation
rdoError.helpfile = RDO98.CHM
rdoError.context = 2023517
rdoError.number = 9
rdoError.State = S1000
rdoError.Retcode = -1
rdoError.Source = ODBC
Why does this error only occurs when i execute thru the rdo object?
What is a TDS stream?
How can i solve this problem?
Please help!!!!!
Used View:
create view vwDeelnemerSet as
/* Toevoegen parametergroepen welke NIET opsplisbaar zijn */
Select Distinct A.DR_ID, A.MD_ID, E.PP_ID
From DeelnemerSet A,MonsterPar B, Monster C, REL_PP_PP E, ParameterGroep F
Where E.PP_ID in ( Select PP_ID From REL_PP_PP Where PP_GroepID = A.PP_ID)
and A.RO_ID in (select ro_id from tempdisc)
And F.PP_Opsplitsbaar = 0
and E.PP_ID = B.PP_ID
and B.MO_ID = C.MO_ID
and A.MD_ID = C.MD_ID
/* Toevoegen gewone parameters en parametergroepen welke opsplitsbaar zijn
*/
Union Select DISTINCT A.DR_ID, A.MD_ID, A.PP_ID
from Deelnemerset A, MonsterPar B, Monster C
where A.RO_ID = B.RO_ID
and A.PP_ID = B.PP_ID
and B.MO_ID = C.MO_ID
and A.MD_ID = C.MD_ID
and A.RO_ID in (select ro_id from tempdisc)
GO
GRANT SELECT , INSERT , DELETE , UPDATE ON dbo.vwDeelnemerSet TO ROOS
GO
Fred Vreeswijk (Holland)
fred.vr...@kiwaoa.nl
fr...@worldonline.nl
Erland Sommarskog
Fred Vreeswijk (fr...@worldonline.nl) writes:
>When executing a view created in SQL server 6.5 with ISQL/W (Select * from
>vwDeelnemers) it retrieves all of the wanted records. When i retrieve the
>amount of found records with the string (Select count(*) from vwDeelnemers)
>it gives me the right amount of records.
>When i execute the select Query in a program, which connects to the SQL
>Server with a rdo connection it also retieves the wanted records, BUT when
i
>execute the query (Select Count(*) from vwDeelnemers) it returns the
>following error:
>
>S1000: [Microsoft][ODBC SQL Server Driver]Protocol error in TDS stream
>the rdoError object gives me the folowing infomation
>rdoError.helpfile = RDO98.CHM
>rdoError.context = 2023517
>rdoError.number = 9
>rdoError.State = S1000
>rdoError.Retcode = -1
>rdoError.Source = ODBC
>
>Why does this error only occurs when i execute thru the rdo object?
>What is a TDS stream?
>How can i solve this problem?
TDS = Tabular Data Stream is the protocol that the SQL Server speaks
with its clients.
A protocol error is often due to the fact that your server process
faced an untimely death and is no more. You should examine the error
log for SQL Server and see if there is any error messages from
the same point in time as you executed your query.
Why it bombs only frmo RDO I cannot tell, but RDO does a couple of
things behind your back. It performs some SET commands when opening
the connection, and the setting of these SET commands may cause
SQL Server to fail. RDO may also emit extra queries to system tables,
and possibly of these fails in this way.
You could use SQL Trace, to capture the communication from client
to server and then execute that communication from ISQL/w.
Since this is a bug in SQL Server you might consider installing the
most recent service pack. If you already have, you might want to
call your support provider.
--
Erland Sommarskog, Stockholm, som...@algonet.se