I have a dedicated machine with with windows server 2019 installed and sql server 2019. I also have multiple client PCs (Laptops) with access front-end installed and ODBC driver 18 n on them, every thing is connected using ethernet, a router and a ethernet switch. Everything works fine, except for this issue: whenever there is a period of inactivity in the already opened access application, there seems to be a loss of connection between access and sql server, the access application will freeze for a moment, then it will work fine again.
Checking error logs on the server side, I see several 17836 errors "Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: ::1], I guess this is related to my problem.
Any sql server/network expert who can help? is this normal behavious of access? !
Checking error logs on the server side, I see several 17836 errors "Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: ::1], I guess this is related to my problem.
Any sql server/network expert who can help? is this normal behavious of access? !