[QODBC-Desktop] Troubleshooting: Cannot connect to QuickBooks through SSIS using QODBC Error = 80040408, Could not start QuickBooks
Posted by Rajendra Dewani (QODBC Support) on 26 December 2013 09:23 AM
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 included with QuickBooks Enterprise Edition is Read Only edition and it can only work with QuickBooks Enterprise when using with Desktop Base application.
But to work with SSIS, you need to either use QRemote or enable “DCOM Server” in QODBC.
When you execute/set SSIS package to run the scheduled job, it runs as a Service (SQL Server is the service-based application).
QODBC Server Edition License is required to work with a service-based application.
Please Note: QODBC Read-Only Edition for QuickBooks Enterprise does not include QRemote License.
"Could not start QuickBooks": Keep QuickBooks running ( No need to login to company file, just keep QuickBooks window open ) and try connecting