This article describes when an Excel workbook file gets an error message when trying to reload/refresh. This Excel workbook file was connected to the SQL Database and accessed via WAN.
Error message received:
‘[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation’.
‘[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv())’.
Scope
FortiGate.
Solution
The error message were appearing only when security profile IPS was enabled on the firewall policy.
Step 1: Run debug flow on the FortiGate CLI console.
diag debug reset diag debug disable diag debug flow sho fun en diag debug flow sho iprop en diag debug flow filter saddr x.x.x.x diag debug flow filter daddr y.y.y.y diag debug flow trace start 99999999 diag debug en
Step 2: Review the debug flow result and find if there is a log message msg=”anti-replay check fails, drop”.
Step 3: If there is a log message msg=”anti-replay check fails, drop” disable the anti-replay on the firewall policy.
config firewall policy edit x set anti-replay disable end
Step 4: Once anti-replay is disabled on the firewall policy, the Excel file can now reload/refresh without any error.