cannot access QuickBooks 14 data

[Former Member]

I had been using Crystal Reports 2008 (version 12.3.0.601) reports against data from QuickBooks V12 and the QODBC driver (from FLEXQuarters) that is used with QuickBooks.

I recently upgraded to QuickBooks V14 and the associated QODBC driver and find that Crystal can no longer get data from QuickBooks.

I downloaded an evaluation copy of Crystal Reports 2013 (version 14.1.1.1036) and have the same issue.

A major difference between QB 14 and QB 12 with QODBC is that now User Access Control must be on in order for the driver and QB to communicate.

When I run one of my Crystal reports, I am asked to log into QuickBooks, whether QuickBooks is running or not, and the login always fails:

The 1st error box message is: Database Connector Error: 'IM006: [Microsoft] [ODBC driver manager] Driver's SQLSetConnectAttr failed [Database vendor code: 10041]'

The 2nd error box message is: Logon failed. Details: 00000 [QODBC] QB begin session failed. Error = 80040408, Could not start QuickBooks. [Database vendor code 10041]'

I am able to use the QODBC driver to access QB via a test VB program that comes with the QODBC driver. I am also able to access QB from OpenOffice Base via the QODBC driver so both vendors are pointing at Crystal as the problem.

Thanks for any suggestions.

[Former Member · Accepted solution]

Several suggestions were made. It appears as if unchecking 'Run as administrator' for crw32.exe solved the issue of not being able to communicate to QuickBooks via the QODBC driver.

If I get additional info later on, I'll post

[former_member183750 · Accepted solution]

Any info, much appreciated Steve

Many thanks,

- Ludek

[former_member183750]

What does your database documentation say about error 10041? Database vendor code 10041

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member]

I have not been able to find what the error code means. I'm working with the driver vendor simultaneously, but their support folks keep pointing to the fact that their test program works so the problem must be elsewhere

[former_member183750]

 their support folks keep pointing to the fact that their test program works so the problem must be elsewhere

Not correct. That error code is being passed through the report engine completely unmodified. So they have to be the ones to tell you what that error means.

Also, try to google the error. I did a quick search and came up with:

http://www.alphasoftware.com/alphaforum/showthread.php?72910-Connecting-to-Quickbooks-the-first-time

So, at minimum the above shows the this is an error coming from QuickBooks. Also see:

http://archive.qodbc.com/forum28e6-2.html

- Ludek

[Former Member]

Thank you.

I've been through all of the initial setup issues that are in the both of the threads you listed and have gotten past those issues.

I'm waiting to hear back from the driver vendor regarding the error codes.

[former_member183750]

Hello Steve

If you get any information on this, be it positive or negative, please do post it here.

- Ludek