Devart Forums

While trying to run a simple query we are getting the error "Invalid cursor State". We have tried the following.

1) Using uniMetaData we are able to get a list of tables and fields. Connection is good.
2) Simplified query to one field. Verified name and table is correct. i.e. "Select name from customer"
If we change the table/field name we get a invalid table/field name error.
3) Tried turning unidirectional on/off
4) Tried turning readonly on/off
5) Combinations of 3 and 4
6) Tried different tables. Same Error.

Any suggestions?

Does devart have a odbc driver for Quickbooks desktop version?

Thanks

Wade


Delphi Berlin 10.1
UniDac 9.7.24
ODBC Driver: QRemote by FlexQuarters

We checked the UniDAC behavior when receiving metadata using ODBCUniProvider and found no problems. Try to check the behavior you describe using Devart ODBC Driver for QuickBooks: https://www.devart.com/odbc/quickbooks/download.html. Currently, Devart ODBC driver for QuickBooks is not compatible with the QuickBooks Desktop edition. We plan to add support for this version in the near future.

Hello

Do you still not having support for Quickbooks Desktop versions on your Quickbooks ODBC Driver?

Last answer for this topic is since 2015, I'm facing the same issue now at 2022.

Best Regards

The button click creates a dynamic stored proc, which works as expected. Then it sets the param values on the fixed proc with paramcheck turned off.
word search