SQLTeam.com | Weblogs | Forums

TDS and SQL Batch


#1

Hello,

I am developing a sample TDS communication from an industrial controller to the SQL Server.
For this I use the TDS protocol.

Already working is PreLogin and Login (I get "LoginAck"). (With an own Login created.)

If I try to execute the example SQL Batch (/msdn.microsoft.com/en-us/library/dd304416.aspx)
the connection is Logged out without the expected response. I also tried other SQL Batch SQL statements with the same result. As soon as I send SQL Batch the Connection is dropped.
I search so much already (permissions, ...) But I have no Idea anymore.

BTW: I monitor that with Wireshark. - That has nothing to complain about that Messanges.

Has anybody an idea what I could have misconfigured or what

I need to configure to get the result to SQL Batch (TDS) ?

Many thanks in advance!

Best regards

Gregor