Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Unattended QuickBooks Login on Server 2003 when not logged into Windows |
Author |
Message |
|
Posted : 2006-11-04 13:24:40 |
Hi,
I'm have been running QODBC 2005 with QuickBooks Enterprise 2005 and PHP/Apache on Server 2003 for about 18 months now, successfully.
In the 2005 setup, I had the DCOM set to run as the "Launching user", which for PHP is "System". QuickBooks (QBW32.exe) would run in the background as System when called by PHP, regardless of whether anyone was logged into the console or not.
I am testing QuickBooks 2007 with QODBC Server 2007 in the same configuration, looking at upgrading, and am having trouble replicating the same setup.
I can't get PHP to connect at all with the DCOM set to "Launching User" in 2007. It throws a "8004041C Internal QuickBooks Error" in all situations. Logged in as admin, or a regular user, or not logged in at all, and with QuickBooks running or not. The QBXML2...exe process launches as System in the process list, but QBW32.exe never gets going and the PHP odbc_connect() call fails with that error.
It does work with the DCOM set to run as the Interactive user, I can get PHP to connect, as long as I am logged into the console as an Administrator. QuickBooks (QBW32.exe) launches in the background as the current logged in user. It doesn't matter whether QuickBooks is running on the console or not. If a non-admin user is logged in, it again fails with 8004041C. If no one is logged in, PHP fails with a "8000401a DCOM instance error".
Since I could get QuickBooks to run in the background before as system, hopefully it can do so again. It feels very close, maybe more of a issue with the way Windows behaves, than a QODBC configuration problem?
-I'm running QODBC Ver: 7.00.00.199 -Gave "Full Control" of files to "Everyone" on C: drive, which has both the QB files and QB installation -Installed QuickBooks via the console, uninstalled the QB supplied QODBC via add/remove programs, then reinstalled the latest version from your website, and entered my CD key. -Created a brand new test QuickBooks .qbw file to try and access, although the issue is the same with my upgraded 2005 file too.
Gone through all the relevant posts here I think, and tried the suggestions:
"How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? " "80070005 error on server 2003 SBS for non admin user " "DCOM Instance Error 8000401a on Windows 2003 Server (WebEdition) " "How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? "
Any ideas? Should QODBC be able to run (as anyone?) in the background?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-04 17:52:20 |
Basically QODBC is a single user product. The Server Edition is designed to run on the local console of the server and to be called by or through a system service. It's not designed to be accessed by multiple users. Multi-user systems like Terminal Services require the use of the Remote Connector to connect each user to the console session, which pretty much sounds like where you have it now.
It might be useful to try connecting QODBC v7 to your QuickBooks 2005 setup instead of QuickBooks 2007, as things have changed on the QuickBooks backend too. Let me know what happens with QuickBooks 2005. |
|
|
|
|
Posted : 2006-11-07 07:54:10 |
I downgraded to QuickBooks 2005 Enterprise keeping QODBC 2007, and I was able to select "the launching user" or enter the Administrator as "this user" for the DCOM server, and have QuickBooks run in the background from PHP without being logged into the console. I reinstalled QB 2007 and it is back to only running via the Interactive User when I am logged into the console as administrator.
So the problem is definitely attributable to a change in QuickBooks with the new version....but I don't know enough to about windows/quickbooks to speculate why.
There will only ever be one user accessing the file at a time, with the webserver and the QuickBooks file on the same machine, so I think the DCOM server is the right solution, not the Report Connector?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-07 10:53:48 |
You can try using the Remote Connector, it's just going to be slower. |
|
|
|
|