[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
|
|
Problem Description:I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot 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 included with QuickBooks Enterprise Edition is Read Only edition, which can only work with QuickBooks Enterprise when using the Desktop Base application. But to work with SSIS, you need to either use QRemote or enable "DCOM Server" in QODBC. When you execute/set the SSIS package to run the scheduled job, it runs as a Service (SQL Server is a 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 the company file, keep QuickBooks window open ) and try connecting. | |
|