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 cannot link 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 a read-only edition, and can only work with QuickBooks Enterprise.

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

Please refer: To how to use QRemote.

Please refer: How to create a 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 use QRemote or DCOM. ( both require 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).