We have an .net standalone(windows) application which connects to SQL AnyWhere (Sybase) using ODBC connection. In this application fist we create temporary tables and then we push the data from these temporary tables to the actual production tables. This is the overview of my application.
We have tab delimited text files using which we create the tables and insert the data to database. I am creating these tables and inserting the data to the tables from .net application(using odbc). what happens is for sometime the application is running perfectly fine its creating the tables and inserting the data to temp tables , but after sometime am getting an error as ERROR  [Sybase][ODBC Driver][SQL Anywhere]Database server not found. This is happening on the production server only. Am not receiving these errors when am testing or running the code locally.
Am really frustrated with this not getting any of the solutions . Please any one of you can guide me on this issue and let me know the possibilities or work around
asked 21 Aug '13, 09:43