Which version of SQL Anywhere are you using?

We have an .net standalone(windows) application which connects to SQL AnyWhere (Sybase) using ODBC connection.

Is there a particular reason that you are not using the ADO.NET driver? It should have better performance for you from .NET:

http://dcx.sybase.com/index.html#sa160/en/dbprogramming/adodotnet-development.html

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 [08001] [Sybase][ODBC Driver][SQL Anywhere]Database server not found.

This will be the message returned back to the database client. Is the database server still running after you receive this error, or did it stop/crash?

On the database server, enable the console log file to record the information when the client gets disconnected: (e.g. dbsrv16 -z -o console.txt ...) to see what happens on the server-side when you receive this error.

First of all Thanks Jeff Albion for your reply. Below 1.We are using sqlanywhere11. 2.And we do have database profiles created in ODBC Administrator that is the reason we are using ODBC. 3.Database server is in running mode when we receive this error i mean its not crashing or stopping.

Please advice

And one more as i said earlier am creating and inserting these tables using flat/tab-delimited text files. Am getting this error for specific tables only. I mean how many times I run the application am getting this database server not found issue for specific tables only. Is this anyway related to the text files or related to the server.

below is the code for inserting data am passing the insert query in sqlstring. if (sqlString != string.Empty) { oDBHelper.ExecuteNonQuery(CommandType.Text, sqlString); sb = new StringBuilder(); sqlString = string.Empty; }

execute non query to open and insert data

public int ExecuteNonQuery(CommandType cmdType, string cmdText) { try {

            EstablishFactoryConnection();
            PrepareCommand(false, cmdType, cmdText);
            int val = oCommand.ExecuteNonQuery();
            return val;

        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (null != oCommand)
                oCommand.Dispose();
            CloseFactoryConnection();
        }
    }

Below is the connection to open database.

public void EstablishFactoryConnection() { / // This check is not required as it will throw "Invalid Provider Exception" on the contructor itself. if (0 == DbProviderFactories.GetFactoryClasses().Select("InvariantName='" + S_PROVIDER + "'").Length) throw new Exception("Invalid Provider"); / oConnection = oFactory.CreateConnection();

        if (oConnection.State == ConnectionState.Closed)
        {
            if (utils != null)
            {
               oConnection.ConnectionString = utils.DBMgr.ConnectionStr;
               oConnection.Open();
               oConnectionState = ConnectionState.Open;
            }
        }
    }