I am synching a Palm application using Sybase Ultralite with SQL 2k Server. I am not sure how many people are aware of the Ultralite technology, so ..the scenario is:
Palm clients connect to IIS server over HTTP, IIS redirects the call to Sybase Mobilink Server running on the server machine within the firewall, Mobilink connects to the SQL Server using DSN to complete the Database transaction for sending data to and from the Palm device client. As the connection with the server is over http, all data is not sent in one shot but in batches. The Mobilink server is responsible for completing the transaction and db clean-ups.
Ocassionally, the Mobilink server shuts down on its own with the following message in the log:
ODBC: [Microsoft][ODBC SQL Server Driver]Timeout expired (ODBC State
= HYT00, Native error code = 0)
I did read up some articles (even on dbforums) on the time-out error but each article suggests a different thing and I am confused.
Please help me with identifying and solving this time-out issue.