cannot access QuickBooks 14 data

107 Views

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.