I am receiving the same error message, however it is not consistent. :
QODBC] QB Open Connection Failed. Errored trying to Create IBiz QuickBooks Integration Object
I have the following architecture:
Windows XP pro running Quick books 2006 Pro with QODBC configured as a DCOM Server. This machine is also set up as Remote Connector Host.
Windows Server 2003 running QODBC as a client Remote Connector to facilate IIS 6. 0 running classic asp.
Can I use the QODBC remote connector this way? In other words is running a web server using a remote connector supported? If not what alternatives do I have? I have to assume a web server and quick books on different machines.
I'm not sure what causes the error (described above) but I have found that running iisreset from the command line fixes the problem. This is disturbing to me and I worry about having to reset iis every 30 minutes to fix the problem.
Also, I have been attempting to get asp.net to work with no successs on the Windows Xp Pro machine. As soon as I set up the remote connector and ran the asp.net page on remote client everything worked fine. No connection errors under this architecure, except occasionally the IBiz error described above.
|