Question on Posting data in ADODataSet

Question on Posting data in ADODataSet

Post by Sunn » Sat, 29 Nov 2003 17:00:58


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
 
 
 

Question on Posting data in ADODataSet

Post by Henri » Sat, 06 Dec 2003 15:51:33

Try:

Persist Security Info=True;

ciao,

henrik

"Sunny" < XXXX@XXXXX.COM > schrieb im Newsbeitrag

there
Tables;UID=;SourceDB=c:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Col