I have a Linux box using adodb and php_odbtp connected to a Windows MS SQL Server box using ODBTP. Normally everything is working fine. Occasionally i get this error messages:
ODBTPERR: [ODBTPERR][0]Unable to send to server (Broken pipe) -----
ODBTPERR: [ODBTPERR][0]Disconnected from server -----
I would be grateful if someone could help by answering a few questions:
a. Are these messages coming from php (e.g. the network between Linux box and Windows SQL Server is bad), or is the error message coming from the odbtp service on the Windows server (e.g. the ODBC connection to SQL Server is bad).
b. Any possible workaround or tuning parameter i can set (e.g. timeouts, etc)
Thank you, John Lim
(author of adodb)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This error normally occurs when the server closes the connection because the client took too long to make another request. The default for this timeout is 180 seconds. You cna change it with the ReadTimeout parameter in the odbtpsrv.ini. Note: You will need to restart the service after the value is changed.
-- bob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have a Linux box using adodb and php_odbtp connected to a Windows MS SQL Server box using ODBTP. Normally everything is working fine. Occasionally i get this error messages:
ODBTPERR: [ODBTPERR][0]Unable to send to server (Broken pipe) -----
ODBTPERR: [ODBTPERR][0]Disconnected from server -----
I would be grateful if someone could help by answering a few questions:
a. Are these messages coming from php (e.g. the network between Linux box and Windows SQL Server is bad), or is the error message coming from the odbtp service on the Windows server (e.g. the ODBC connection to SQL Server is bad).
b. Any possible workaround or tuning parameter i can set (e.g. timeouts, etc)
Thank you, John Lim
(author of adodb)
This error normally occurs when the server closes the connection because the client took too long to make another request. The default for this timeout is 180 seconds. You cna change it with the ReadTimeout parameter in the odbtpsrv.ini. Note: You will need to restart the service after the value is changed.
-- bob
Thanks bob, will try it out. - John