Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : PHP / IIS crash during install (web server edition)Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 PHP / IIS crash during install (web server edition) 
 Author   Message 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-12 06:15:14

Hi
I follow the instructions written here :
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=33
But when comes the time to test the DCOM setup with a ASP PHP or CF, I'm not able to do it.
The web page gives :

"Server Error, unable to connect to fastcgi server."

In the application event logs, I've got this message (nothing else in the others event log category) :

Faulting application php.exe, version 4.4.4.4, faulting module php4ts.dll, version 4.4.4.4, fault address 0x000bc6b8.

The problem is that this web server is running for our web app and no error occured until this one.
I've respected all the read/write permissions needed, all the steps to install the drivers.

I just would like to be able to test. Any help would be really appreciated.
Thanks.

Php 4.4.4.4 / IIS 6 / W2k3 Srv Enterprise Edition

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-12 11:31:54

What happens when you run the qbcust example shown in: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP?  instead?

http://localhost/qbcust.asp

 

 

  Top 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-12 23:35:45
When I run the qbcust.asp :

QODBC Customer Web List Demo Page
Preparing to Create Connection Object
ADO Connection Created
ADO Recordset Created - Opening QuickBooks Sample Company File
...
and I wait about 20 minutes the page to load, and it doesn't ...


When I run the TestDCOM.asp (not the TestDCOM.php as I did before) :

QODBC ASP DCOM Access Test Page
QB2002 QB2003 QB2004 QB2005 DCOM COM Object Name Status
      QBXMLRPEQODBCInteractive.exe Error:
      QBXMLRP.dll Success
      QBXMLRP2EQODBCInteractive.exe Error:
      QBXMLRP2.dll Success
  XERCES-COM.dll Success
Current Logged on User is:
Authenticated user is:



I suppose the error status for the QBXMLRP* dcom could be the problem ... 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-13 08:29:48

If the QODBC DCOM Server connection fails, the error message is usually instant. There's no waiting 20 minutes.

As far as the DCOMs are concerned, try looking at: How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server?  

qbcust.asp uses a connection to:

oConnection.Open "QuickBooks Data"

I don't know whether this DSN is the one you are using and whether you have confirgured auto-login mode yet. See: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

 

  Top 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-14 07:19:38
I had soon configured the both QODBC DCOM objects with the good permissions, and to auto-login.
I double-checked each steps of installation, and everithing is ok.
I've decided to upgrade my php version from php4 to php5... and I triple-checked again each steps of installation.
As a big part of the kernel of php5 is new, I thought it was for working .... but now it gives :

Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `QBXMLRPEQODBCInteractive.RequestProcessor': The server process could not be started because the configured identity is incorrect. Check the username and password. ' in C:\Inetpub\wwwroot\test_odbc\TestDCOM.php:58 Stack trace: #0 C:\Inetpub\wwwroot\test_odbc\TestDCOM.php(58): com->com('QBXMLRPEQODBCIn...') #1 {main} thrown in C:\Inetpub\wwwroot\test_odbc\TestDCOM.php on line 58
QODBC PHP DCOM Access Test Page
QB2002 QB2003 QB2004 QB2005 DCOM COM Object Name Status
      QBXMLRPEQODBCInteractive.exe


It's like if there was a problem ........ 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-14 07:32:28

The QBXMLRPEQODBCInteractive.exe and QBXMLRP2EQODBCInteractive.exe DCOMs are not configured correctly. Try using:

Automatic DCOM Configuration
Click here: qodbcSetDCOM.zip to download the following automated tools:-

bullet Dcpinst.exe is an installation setup for the automated DCOM configuration object. This needs to be run first and only once.
bullet QODBCSetDCOM.VBS is a VB script that uses the installed configuration object to setup the DCOM Servers. It will reset and automatically add all necessary security each time it is run. The script can be edited if you need to change the Accounts it is configuring.
bullet The new settings will not take affect until the DCOM servers (qbXMLRPeQODBCInteractive.exe and qbXMLRP2eQODBCInteractive.exe) are removed from memory. Rebooting is the simplest way to accomplish this, but running the Windows Task Manager and Ending Process on any running copies will also work.
bullet Test your DCOM setup using one of the following:-
bullet IIS users download: TestDCOM.ASP

 

  Top 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-17 00:14:05
I've got exactly the same messages after running (once more) Dcpinst.exe and QODBCSetDCOM.VBS.
With TestDCOM.ASP :

QODBC ASP DCOM Access Test Page
QB2002 QB2003 QB2004 QB2005 DCOM COM Object Name Status
      QBXMLRPEQODBCInteractive.exe Error:
      QBXMLRP.dll Success
      QBXMLRP2EQODBCInteractive.exe Error:
      QBXMLRP2.dll Success
  XERCES-COM.dll Success
Current Logged on User is:
Authenticated user is:
Current Logged on User is:
Authenticated user is:


And with TestDCOM.PHP :
Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `QBXMLRPEQODBCInteractive.RequestProcessor': The server process could not be started because the configured identity is incorrect. Check the username and password. ' in C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php:58 Stack trace: #0 C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php(58): com->com('QBXMLRPEQODBCIn...') #1 {main} thrown in C:\Inetpub\wwwroot\Sites WEB\Clients\travaux\test odbc\TestDCOM.php on line 58

QODBC PHP DCOM Access Test Page
QB2002 QB2003 QB2004 QB2005 DCOM COM Object Name Status
      QBXMLRPEQODBCInteractive.exe

For the fun, I've started manually both files QBXMLRPEQODBCInteractive.exe and QBXMLRP2EQODBCInteractive.exe from "c:\program files\QODBC Drivers for Quickbooks" with my username on the web server but I obtained the same results.

But as you can see with the ASP test, the login and the password to connect the QODBC are empty ... and the message from the PHP test says it's not the good login/password. Maybe there's something in this way.

ps: I need PHP to work, even if I'm using IIS and even if I could use ASP. 

  Top 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-17 02:06:16

Ok, after many and many manipulations, I found the property of the both objects (with dcomconfig.exe), in the identity tab, the user account used to tun the application MUST be the launching user. (I did not found this information in all the installation guide, and the faq. It's possible that I've not well searched.)

And I've got all the tests success :

QODBC PHP DCOM Access Test Page
QB2002QB2003QB2004QB2005DCOMCOMObject NameStatus
      QBXMLRPEQODBCInteractive.exe Success
      QBXMLRP.dll Success
      QBXMLRP2EQODBCInteractive.exe Success
      QBXMLRP2.dll Success
  XERCES-COM.dll Success
Current Logged on User is:
Authenticated user is:
PHP Current Logged on User is: ?????
Current Logged on User is:
Authenticated user is:
PHP Current Logged on User is: ?????


The only one probem was the "run application using the launching user".
Thanks for your help, I'm watching further now to test if everything is ok before to buy it. 

  Top 
  Vincent 
  
 Group: Members 
 Posts: 6 
 Joined: 2006-10-12 
 Profile
 Posted : 2006-10-18 00:12:58
Ok it's not over.
I've tried again the qbcust.asp file. I've got the same result I had before (see the post created on 2006-10-12 23:35:45)
Then I tried the DisplaySQL.php test file without success.
I wait but nothing occurs..
When I check the process running on the web server, I do not see any Quickbooks instance nor Quickbooks driver nor Quickbooks connection.
But the w3wp.exe (World Wild Web Publishing service) is growing as soon as I launch a test file.

Any help would be welcome. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-18 08:19:07
Do other .asp pages with VBScript run ok on your server? Are you running QuickBooks on the server console (local session) logged in as administrator? 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to