commands out of sync problem (c++ builder)

Largowww · #1 28-May-2005, 03:40

I’m stuck on a problem and I just can’t find a solution. I’m writing a simple multi-tier DB (mysql) application in a windows environment using DBexpress and soap. The client application is just performing a ping to a remote server and when the reply arrives I want to store the ping information in a DB, but I always get the error ‘commands out of sync: you can’t run this command now’.

Here’s the code when I receive the ping reply:

CPP / C++ / C Code:

void __fastcall TForm1::IdIcmpClient1Reply(TComponent *ASender,
      const TReplyStatus &AReplyStatus)
{
    static int ID = 0;
    int pingtime;

    if (AReplyStatus.ReplyStatusType == rsTimeOut)
      pingtime = 5000;
    else pingtime = AReplyStatus.MsRoundTripTime;

    // now call the server to store the data
    pingDataSet->AppendRecord(ARRAYOFCONST((ID, configDataSetIPaddress->Value, pingtime)));
    if(pingDataSet->ChangeCount > 0)
       pingDataSet->ApplyUpdates(0);   <---- Here I get the error

    ID++;
}

Now I’ve been looking for this problem in google, I didn’t find any solution, but what I saw is that several people had this problem and it could have something to do with the used version of mysql and the used dll’s. I’m using MySQL 4.1.11, dbexpmysql.dll of 91kb and libmysql.dll of 228kb. I’ve tried several other versions of libmysql.dll, but then I always get the ‘unable to load libmysql.dll’ error.

Anyone any ideas how to solve this?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Graphic problem in Unreal Tournament 2004	zerox	Computer Software Forum - Games	10	09-Oct-2005 12:31
Problem with moving a Form (C++ Builder)	OvedBZ	MS Visual C++ / MFC Forum	1	26-May-2005 07:38
String problem	vaha	C Programming Language	3	24-May-2005 18:21
File Serialize's problem	stanely	MS Visual C++ / MFC Forum	2	08-Dec-2004 09:54
Another FX 5600 problem (but with details that might shed light on this)	BobDaDuck	Computer Hardware Forum	2	16-Apr-2004 07:53