V
VSC
I have a problem: I receive a "Microsoft Cursor Engine
error '80004005'
Data provider or other service returned an E_FAIL status."
when querying my Access database. The error identifies
the fp_rs.Movenext (line 4) in the FPDBRGN2.inc file. It
appears the query itself and the
data connection works as some records are returned and
displayed before it dies. I can also eliminate the error
by doing one of two things: I can remove an "order by"
clause in the SQL statement so the results are not sorted
and the error goes away. I can also eliminate the error by
changing the data format of one of the fields in the
database from Memo to text. Presumably this has to do with
the field size being so large for Memo type. The cursor is
coded as "aduseclient" "adopenstatic" by Frontpage and
everything I
have seen on the large text field issues and "order by"
clause says making it client side cursor should solve any
issues. Any suggestions??
..
error '80004005'
Data provider or other service returned an E_FAIL status."
when querying my Access database. The error identifies
the fp_rs.Movenext (line 4) in the FPDBRGN2.inc file. It
appears the query itself and the
data connection works as some records are returned and
displayed before it dies. I can also eliminate the error
by doing one of two things: I can remove an "order by"
clause in the SQL statement so the results are not sorted
and the error goes away. I can also eliminate the error by
changing the data format of one of the fields in the
database from Memo to text. Presumably this has to do with
the field size being so large for Memo type. The cursor is
coded as "aduseclient" "adopenstatic" by Frontpage and
everything I
have seen on the large text field issues and "order by"
clause says making it client side cursor should solve any
issues. Any suggestions??
..