Re: Question on Posting data in ADODataSet

From: Henrik (henrikinderarbeit_at_web.de)
Date: 12/05/03 

Date: Fri, 5 Dec 2003 07:51:33 +0100

Try:

Persist Security Info=True;

ciao,

henrik

"Sunny" <sunny@yahoo.com> schrieb im Newsbeitrag
news:3fc6ff7a@newsgroups.borland.com...
> 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