Hi Geraldo,

How is DB server?
Has table Table any date/datetime column?
How is set of SET SYSFORMATS?
How is set of SET DATE?

MartinJ

>Hi,
>
>
>When I execute the CursorFill method of a CursorAdapter in VFP9 I get the following error message:
>

>"Microsoft Cursor Engine : Data provider or other service returned an E_FAIL status."
>

>
>Using the same CursorAdapter, changing only the SelectCMD propperty the error can occur or no.
>if this.SelectCMD = "Select * from Table1" && the error doesn't occur
>if this.SelectCMD = "Select * from Table2" && the error occurs
>
>I reindex the tabela, mas but it don't solution.
>
>- accessing the table by CursorAdapter the error occurs
>- accessing the table by SQL PassThru (SQLExec) the error doesn't occur
>- accessing the table by nativamente do VFP the error doesn't occur