Hello All,
I am using the CData OBDC driver and Remote Connector to integrate SQL Server with QuickBooks Desktop. I have SLQ stored procedures that query QB as a linked server. I'm using this to query the QB customer list and insert timesheet records. It works great 90% of the time. About 10% of the time QB throws and error "QBW32.EXE - Fatal Application Exit" with an open dialog box on the server which must be manually acknowledged. Everything works fine again once the error is acknowledged.
QuickBooks Desktop along with the QB company file are installed on a server. The CData OBDC driver and Remote Connector are also installed on the same server. This installation of QB desktop is dedicated to the SQL integration. Other users in the company access the QB company file from local installations of QB Desktop on their PC's
There is an external app that triggers the SQL stored procs. It was my intention to run the integration unattended on the server. The Remote Connector will automatically log into QB when SQL calls a query to run. Again, it all works fine most of the time.
I realize the error is most likely a QB issue, but QB tech support has not been overly helpful because it's a 3rd party integration which they don't directly support. All of this has been up and running for almost two years. QB has been updated and reinstalled twice since then. There has been no change in the frequency of this error.
I'm wondering if anyone else has experienced this problem?
Best answer by Elizabeth G
View original