[QODBC-Desktop] Troubleshooting: Cannot connect to QuickBooks through SSIS using QODBC
Posted by Jack - QODBC Support on 02 November 2015 12:56 PM
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.”
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 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