Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting: Cannot connect to QuickBooks through SSIS using QODBC
Posted by Jack - QODBC Support on 02 November 2015 12:56 PM

Problem Description:

I am trying to connect to QuickBooks through SSIS using QODBC, but I am unable to connect to QuickBooks.

I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition.

I am getting the error:

“Error = 80040408, Could not start QuickBooks.”

Solution:

QODBC comes from QuickBooks Enterprise is read-only edition and it can only work with QuickBooks Enterprise.

But to work with SSIS, you need to use QRemote.

Please refer: How to use QRemote

Please refer: How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote

Please note SSIS package is running as a Service (SQL Server is a service based application).

If that's the case you may have to either use QRemote or DCOM. ( both requires QODBC Server Edition License)

Please note QODBC Read-only edition for QuickBooks Enterprise does not include QRemote License.

Please refer: QODBC Licensing Information

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).