I always got this error message when connecting with Management studio.

The below command does not produce the result as expected.

TDSBridge 7777 localhost 1433

sql server is running on port 1433 and ssms as well.
What could be the reason.

It is not working.
No output displays from this application ...

An sql or packet can be rejected according some conditions.

Thank you

If you were to add compression to this, where would you do it? At the payload area, or the full stream itself?

I tried to load my .NET program using login and simple data retrieval. It worked fine until I tried running a module that has a Crystal Report form to get the data from the SQL Server. It froze as the log emitted a closed connection.

The report:

Is there anyway to show the tabularresult coming from the SQL Server?

Maybe it's unrelated to this project, but I'm curious and just want to ask a TDS pro like you.

Is it possible to modify the response data coming from SQL Server?

For example, I have a table contains two columns, but with the proxy I want to clear the second column data when a user queries it.

Thanks in advance.

Hi,

I just did some stress tests and I found it seems to break down when there are large packets (>10,000 bytes)?

I used the following test code to try to insert 100,000 records to the database:

	    List<string> nums = new List<string>();
	    for (int i = 0; i < 1000; i++)
            {
                  nums.Add($"('{i:D10}')");
            }

            var insert = new SqlCommand($@"INSERT INTO TestTable (Str) VALUES {string.Join(",", nums)};", conn) { CommandTimeout = 0 };

            for (int i = 0; i < 100; i++)
            {
                  insert.ExecuteNonQuery();
            }

It will throw a System.Data.SqlClient.SqlException(inner exception: SocketException ID 10054 "An existing connection was forcibly closed by the remote host") on insert.ExecuteNonQuery();. Could you tell me what's the problem? That code works if I don't use TDSBridge.

Here is the log of TDSBridge:

12:01:20.282551|TDSBridge.Common.Packet.TDSPacket[Header=TDSBridge.Common.Header.TDSHeader[Type=SQLBatch;StatusBitMask=4;LengthIncludingHeader=8000;PayloadSize=7992]]
12:01:20.283552|TDSBridge.Common.Packet.TDSPacket[Header=TDSBridge.Common.Header.TDSHeader[Type=48;StatusBitMask=0;LengthIncludingHeader=12544;PayloadSize=12536]]
12:01:20.285551|TDSBridge.Common.Packet.TDSPacket[Header=TDSBridge.Common.Header.TDSHeader[Type=48;StatusBitMask=0;LengthIncludingHeader=12288;PayloadSize=12280]]
12:01:20.753550|Connection BridgeSQL closed (TDSBridge.Common.SocketCouple[ClientBridgeSocket.RemoteEndPoint=127.0.0.1:59996, BridgeSQLSocket.RemoteEndPoint=[fe80::6102:841:e0ce:274%10]:1433])
12:01:20.767549|Connection ClientBridge closed (TDSBridge.Common.SocketCouple[ClientBridgeSocket.RemoteEndPoint=127.0.0.1:59996, BridgeSQLSocket.RemoteEndPoint=[fe80::6102:841:e0ce:274%10]:1433])