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