QuickBook ODBC "invalid cursor state" error

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wbroyles10
Posts: 6
Joined: Tue 21 Aug 2012 00:56

QuickBook ODBC "invalid cursor state" error

Post by wbroyles10 » Sun 16 Oct 2016 16:39

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: QuickBook ODBC "invalid cursor state" error

Post by MaximG » Wed 19 Oct 2016 12:57

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.

devfun80
Posts: 1
Joined: Tue 09 Aug 2022 04:53
Contact:

Re: QuickBook ODBC "invalid cursor state" error

Post by devfun80 » Tue 09 Aug 2022 04:57

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

peterparkerrbu
Posts: 1
Joined: Tue 23 Aug 2022 08:34

Re: QuickBook ODBC "invalid cursor state" error

Post by peterparkerrbu » Tue 23 Aug 2022 08:35

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

Post Reply