we are running Baan 5c in WIN Advanced server 2000 ,SQL2000

some times we have this error message "connection with server lost reconnect?"

can any body tell me why we receive this error message

is it SQL Or Baan problem? how can I fix it?

thanks

I think that you must control your login accounts. If there is a problem , there may be connection lost ...

Check it
good lucks

Is SQL running on the same server or another server?
yes.... the SQL running on the same server

More likely to be a network issue if your PC's are losing their connection to the Baan server.

Cheers
Neal

Refer to the following solutions on the BaaN support site. There are lots of parameters that you need to check.

110907: Stopping inactive (idle) bshells using session_timeout mechanism.
19868: Timeout Detect mechanism (ds_timeout_detect, ds_max_wait) in BaanIVb, c, ERP
109807: Termination (Access Violation) of Bshell
109800: Detected Database Server Termination (Errno 32 (Broken pipe) bdb_errno 0)
74454: Does a temporary broken TCP/IP connection shut down BW?
109795: Detected Display Server Termination (Errno 0 bdb_errno 509 (Bad memory c..))
105481: Slow WAN/Modem link, extended latency through network, causing timeouts in BW (err 10053, 10054, 10060,10065), Server communication timeout
110908: Instructions for setting bshell resource variables.

If you are running on Level 2 driver, I know there are some parameters which need to be set differently. We had the same Problem and Baan suggested this.

They said that \baan\lib\defaults\db_resource should have the following parameters:

msql_max_free_cursors:0
msql__retained_cursors:0

This is the explanation they gave.

This controls the number of cursors that the driver will keep open. We ran into some problems with the other 5c customers where the driver would run out of the retained cursors and get a Access Violation on the driver. By setting this to zero, in theory, you are giving it unlimited number of cursors. The driver will handle how many it needs per processes and what to do with them.

Hi,

Can you post the Eventlog when you got this error?

Maxime.