DataAction / AdoNetCore.AseClient

AdoNetCore.AseClient - a .NET Core DB Provider for SAP ASE
Apache License 2.0
106 stars 44 forks source link

Server Packet Size #125

Closed c-j-hughes closed 5 years ago

c-j-hughes commented 5 years ago

The connection string properties EnableServerPacketSize and RestrictMaximumPacketSize should be supported.

According to the docs EnableServerPacketSize=1:

Allows Adaptive Server server versions 15.0 or later to choose the optimal packetsize.

Looking at the code, it seems like we already support the server setting the packet size that it prefers. EnableServerPacketSize=1 is the default.

We would need to support EnableServerPacketSize=0, which disabled the server behaviour, and RestrictMaximumPacketSize=1024. Not sure how this negotiation works but we could do a RIBO profile of the SAP AseClient to suss it out.

The EnableServerPacketSize=0 bit would be set on logon with the NO_SRVPKTSIZE capability bit - I think.