Problem:

I have a customer who does their invoicing with an ASP.NET application, and it flows into QuickBooks. I created the interface with QODBC, and it works with no problem except that sometimes the processes will lock up, and I have to remote into their web server and physically kill the processes (QBXMLR~1, QBServerUtilityMgr). What would cause these processes to lock them up? Could it be that more than one person is invoicing at the same time? At the end of my save routine, I even force a kill off the processes if they haven't ended.

I have "Use DCOM Servers" checked. Here is all the QODBCLOG.TXT says.

IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 800706be, Unknown error.

Begin Session errors can be caused when running ASP or other system services and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector."

Every morning I have to kill the processes, and I also have to do it throughout the day. I've checked everything, and I cannot solve this problem.

Solution:

The error is saying, "The remote procedure call failed," which leads me to believe you have a broken error recovery table in the company file.

Usually, corruption is caused by sending many requests in one message set or not clearing the error table between message sets.

To overcome this error, you must reinstall QODBC or upgrade to QODBC's latest version.