10004-[QODBC] Error

[Judy Brenneke]

Could not create local cache for data from your Database. Your Database reported the following error:
Database API Specific Error
Your database has returned the following error code and description to Alpha Five. COnsult your database documentation for further information.

10004-[QODBC] Error
SQL state is: 42S00 while converting ResultSet to DBF table.

Help! I just downloaded the tool and was doing demo and can't get past this error. Have linked data and refreshed but this same error.

[ELQRBMO44056]

Judy,
Was just curious if you found your answer? I receive the same message when I try to connect a couple different times when I don't set a parameter. Please let me know if you found anything out.
Thanks!

Could not create local cache for data from your Database. Your Database reported the following error:
Database API Specific Error
Your database has returned the following error code and description to Alpha Five. COnsult your database documentation for further information.

10004-[QODBC] Error
SQL state is: 42S00 while converting ResultSet to DBF table.

Help! I just downloaded the tool and was doing demo and can't get past this error. Have linked data and refreshed but this same error.

[Al Buchholz]

Judy

Somehow I missed your posting.... Sorry about that. :( ( don't let us get away with that - ask again.. or at least until we answer.)

Elizabeth

Sounds like you are refreshing from a QB report. Some of those reports require a parameter to operate - just like they do when you run them from QB. ie - PL Budget vs Actual needs to know the budget year that you are looking at.

I typically setup the report and when I get to the part about parameters I press preview data and reset parameters until I get the data that I want.

[EGartin]

Judy

Somehow I missed your posting.... Sorry about that. :( ( don't let us get away with that - ask again.. or at least until we answer.)

Elizabeth

Sounds like you are refreshing from a QB report. Some of those reports require a parameter to operate - just like they do when you run them from QB. ie - PL Budget vs Actual needs to know the budget year that you are looking at.

I typically setup the report and when I get to the part about parameters I press preview data and reset parameters until I get the data that I want.

Hi Al,

The report we worked on a couple years ago is having this issue now. They upgraded to QB 2014, and it worked for February and now it won't refresh properly and they get this same error. They don't put in any parameters to do the refresh. It's all hard coded in.

I also sent you an email, a response in either location would be great. Thank you!

[Al Buchholz]

Hi Al,

The report we worked on a couple years ago is having this issue now. They upgraded to QB 2014, and it worked for February and now it won't refresh properly and they get this same error. They don't put in any parameters to do the refresh. It's all hard coded in.

I also sent you an email, a response in either location would be great. Thank you!

Running against QB 2014 requires the appropriate QODBC driver and using a full or runtime version of Alpha.

A QODBC driver newer than 2011 won't work with QRB.

I also rest the optimizer file when I change QODBC versions. It's a button on the optimizer tab of the QODBC setup.

[Jimmyc8]

I am having the same problem. I have 2 reports that we run monthly. In April they ran fine but now I get : 10004-[QODBC] Error
SQL state is: 42S00 while converting ResultSet to DBF table. when trying to refresh the invoice table. Has there been any progress on this problem?
Thanks!

[Al Buchholz]

I am having the same problem. I have 2 reports that we run monthly. In April they ran fine but now I get : 10004-[QODBC] Error
SQL state is: 42S00 while converting ResultSet to DBF table. when trying to refresh the invoice table. Has there been any progress on this problem?
Thanks!

Did you change versions of quickbooks?

What edition of Quickbooks and what table is generating the error?

[Jimmyc8]

Hi Al, We have not made any changes to Quickbooks. We are running QB Enterprise 13 and QODBC version 13 . It's the Invoice table that gives the error. The reports use the Customer and Invoice tables. The Customer table refreshes just fine. Could the Invoice table be too large?
Thanks!

[Al Buchholz]

Hi Al, We have not made any changes to Quickbooks. We are running QB Enterprise 13 and QODBC version 13 . It's the Invoice table that gives the error. The reports use the Customer and Invoice tables. The Customer table refreshes just fine. Could the Invoice table be too large?
Thanks!

The invoice table probably isn't too big. From QB press F2 to get the stats on list tables and how many transactions you have.

2 areas to check.

1. Run a verify from QB utilities to check the company file. Rebuild if needed.

2. Reset/delete the QODBC optimizer file. I don't remember if v13 has a reset on the QODBC setup screen. Otherwise find the <companyfile>.opt file in a hidden directory of My Documents/User (xp or win 7) and delete it. It'll rebuild automagically.