Quickbooks QODBC Driver Error

Question

Hello,

I am having trouble querying data into Alteryx from a QODBC driver I set up on my desktop. I successfully tested the same QODBC through Excel to confirm that it was specifically an Alteryx issue.

Before running the workflow, I get an error that says "Error: SQLColumn Attribute(Numeric) but then when I run, the error dissapears, and the workflow runs for a very long term and times out (theres almost no data in this Quickbooks file).

I also confirmed that I put my Quickbooks username and password into the input tool to give Alteryx access.

Any help would be appreciated!

- Mark

Ricky_QODBC · Answer

Hi Markedler4,

We want to troubleshoot the issue you are facing.

We need more information about the issue you are facing.

Please raise a support ticket at http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

Please share the below-listed information and files.

Please attach the below-listed files when replying to the ticket.

1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab)

2) Screenshot of the problem you are facing.  (as an attachment)

3) SQL Statement having issue (if any) (an attachment)

4) Screenshot of the application having issue (as an attachment) -Full Screen

5) Sample code (if any) (as an attachment)

Log Files from

6) QODBC Setup Screen -- > Messages -- > Review QODBC Messages (as an attachment)

7) QODBC Setup Screen -- > Messages -- > Review SDK Messages (as an attachment)

😎 Did you upgrade anything?

Please refer to How to take a screenshot: www.qodbc.com/links/screenshot.htm

markedler4 · Answer

Thanks for the input @RishiK As far as I can tell, this is not the issue. I actually was able to successfully load the data into MS Access and then query in Alteryx from there, but I cannot get the direct connection to work.

Even when I select a single empty column in the Visual query builder, the workflow will still not run.

rkapoor · Answer

@markedler4 this usually occurs when there's a data issue. It might be possible that there are some chars in columns which should be int or numeric?