Question on Posting data in ADODataSet

From: Sunny (sunny_at_yahoo.com)
Date: 11/28/03 

Date: Fri, 28 Nov 2003 16:00:58 +0800

Hi all,

I use ADODataSet for connecting to a free table of Foxpro(dbf). The OLE DB
Provider is "Microsoft OLE DB Provider for ODBC Drivers' I found that there
will be an error when I continue to post data to the dataset.

adoConnection.ConnectionString :=
'Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties="DSN=Visual FoxPro
Tables;UID=;SourceDB=c:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Col
late=Machine;Null=Yes;Deleted=Yes;"';

eg.
i := 0;
While i <2000 do begin
    adoDataSet.Append;
    adoDataSet['Field']:=Value;
    adoDataSet.Post
end;

The error message is the following :
[Microsoft][ODBC Visual FoxPro Driver] Variable 'Q709P25' is not found'.

The error occurs when i > 980. I'm not sure if it is related to the memory
allocated.

Is there a way to solve this problem?

Thanks in advance,

Sunny

Relevant Pages