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 : QODBC/IIS/ASP QBXMLRP2EQODBCInteractive.exe ErrorSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v9 Forum

 New Topic 
 
 Post Reply 
[1]  
 QODBC/IIS/ASP QBXMLRP2EQODBCInteractive.exe Error 
 Author   Message 
  Dan Lockwood 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-12-25 
 Profile
 Posted : 2008-12-25 12:24:26
I'm evaluating QODBC and trying to get the samples up and running.  When I execute testdcom.asp I get the following errors:

QODBC ASP DCOM Access Test Page
QB2002 QB2003 QB2004 DCOM COM Object Name Status
• •   •   QBXMLRPEQODBCInteractive.exe Error:
• •     • QBXMLRP.dll Success
    • •   QBXMLRP2EQODBCInteractive.exe Error:
    •   • QBXMLRP2.dll Success
• • •   • XERCES-COM.dll Success

I've looked through the forums and this seems to indicate some sort of permission problem on the dcom objects.  The only thing different about my setup as compared to the tutorials is that we require basic authentication to our website (interanet site) as opposed to anonymous access using the IUSR system account.  I've substituted in our authorized users security group everywhere I see the IUSR account listed in the tutorial but continue to receive the above errors.

I have executed the vbdemo.exe program without issues.  Additionally when I execute qbcust.asp the script seems to hang and I must restart w3svc to get the web server back.

Some general questions as well.  I had to install full blown QB onto the server to create the initial connection with QODBC, but am I correct in understanding that QB must be up and running with the company file loaded on the server in order for my ASP pages to get access to the data in QB?  If so this seems very limiting.

Any points of clarification are very much appreciated.  Thanks! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-12-26 11:17:01
As per How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? , you need to give read and write rights to the QuickBooks application folder (normally C:\Program Files\QODBC Driver for QuickBooks\) to the Anonymous web user IUSR_servername, ASPNET user and INTERACTIVE and your case each user. 

  Top 
  Dan Lockwood 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-12-25 
 Profile
 Posted : 2008-12-27 04:17:31
Thanks for the reply.  What about "Some general questions as well.  I had to install full blown QB onto the server to create the initial connection with QODBC, but am I correct in understanding that QB must be up and running with the company file loaded on the server in order for my ASP pages to get access to the data in QB?  If so this seems very limiting."  Thanks!
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-12-27 10:39:48

QODBC talks to QuickBooks and QuickBooks talks to the company file, so QODBC must find a full version of QuickBooks and with all Windows Services or applications that call through a Windows Service, unattended mode access is used as per: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? as explained in How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? .

Because you are not using the anonymous IUSR_servername user, see also : Permissions Issue with IIS using AUTHENTICATED USERS 

 

  Top 
  Dan Lockwood 
  
 Group: Members 
 Posts: 3 
 Joined: 2008-12-25 
 Profile
 Posted : 2009-01-05 10:47:39
I've been wrestling with this problem off and on for about a week now.  I installed a program called filemon.exe on the server.  This problem shows realtime filesystem access and also the account used and resulting security action (i.e. permit, deny, etc.).  I see that access to all files is permitted.  So I went back to square one.  If I login with the administrator account I still receive the same error:

Current Logged on User is: TEAMONE\administrator
Authenticated user is: TEAMONE\administrator

 

 

QODBC ASP DCOM Access Test Page
QB2002 QB2003 QB2004 DCOM COM Object Name Status
• •   •   QBXMLRPEQODBCInteractive.exe Error:
• •     • QBXMLRP.dll Success
    • •   QBXMLRP2EQODBCInteractive.exe Error:
    •   • QBXMLRP2.dll Success
• • •   • XERCES-COM.dll Success

At this point i'm very confused how this could be a permission issue if I can't even get this test to execute using the administrator account.  Does anyone have any additional thoughts or do I just need to scrap this?  Thanks. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-05 11:29:30
Try looking at: How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server?. Because you are not using the anonymous IUSR_servername user, see also : Permissions Issue with IIS using AUTHENTICATED USERS and you must reboot the server after configuring the DCOMs! 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to