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 : Upgrade to QODBC 2006 and DCOM failsSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Upgrade to QODBC 2006 and DCOM fails 
 Author   Message 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 03:47:24

We have been using QB 2003 and the Server version of QODBC for several years without any trouble.  We upgraded to QB2006 and purchased a new QODBC connector for 2006.  Installation went fine and using the Test Connection everything worked perfecly.  However access now through the web fails.  When using the test DCOM page now the DCOM has permission denied.  I've confirmed the permissions using DCOMCNFG and everything is correct and has not changed.  Any suggestions.

      QBXMLRPEQODBCInteractive.exe Error: Permission denied
      QBXMLRP.dll Success
      QBXMLRP2EQODBCInteractive.exe Error: Permission denied
      QBXMLRP2.dll Success
  XERCES-COM.dll Success

 

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

Using the Windows Explorer Security tab, give read and write rights to the QuickBooks application folder (normally C:\Program Files\QODBC Driver for QuickBooks\) to the Anonymous web user IUSR_machinename, ASPNET user and INTERACTIVE. This allows for creation and update of QODBC trace and message logs and allows access to the DCOM server executables.

You also need to create a auto-login company file, see: How do I setup QODBC to auto-login into QuickBooks and start it if it's not running? 

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 08:49:18
This is already done and I re-confirmed it.  This server previously had the 2003 version of the QODBC web server running for several years using DCOM so the DCOM and permissions had already been set.  The auto-login has also been in place for several years.  As soon as we upgraded to the 2006 version and reset the Use DCOM settings under the Setup Screen this stopped working and the error has started. 

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

While you have said a lot about QODBC v3 and v6, you haven't indicated what version of QuickBooks is now in use? You will need to have QuickBooks 2005 or 2006 and check that auto-login still works for the company file using VB Demo when QuickBooks isn't running already.

See also: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? 

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 09:14:18
We've upgraded QB2003 to QB2006 and upgraded QODBC from v5 to v6 (all on the same server) after purchasing a new QODBC server license earlier today.  

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-05 09:21:17

Thanks, but you didn't confirm that auto-login still works for the company file using VB Demo when QuickBooks ins't running already? This fails for most 2005 company files that have an existing QODBC Integrated Application Connection when they are converted to the new 2006 format by QuickBooks, see: After upgrading to QuickBooks 2006, QODBC "auto-login" unattended mode no longer works? 

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 09:26:14
Auto Login is set and VB Demo works perfectly. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-05 09:54:21

If you are using Windows 2000 Server, you also need to check that IWAM_machinename has access to C:\Program Files\QODBC Driver for QuickBooks\ folder and your Anonymous access settings in IIS.

Otherwise for Windows 2003 Server see: How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? 

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 10:19:09
This has been a Windows 2003 Server for several years and permissions are set for ASP.NET, INTERACTIVE and the IIS Guest Account on that folder since the original installation. Permissions are also set this way for the fpqbb DLL and exe in the WINNT/system32 folder as well as the two odbc  INI files.  Again, up until today we were running QB2003, QODBC Web Server version v5 using DCOM with no problems through IIS.  Once we upgraded to QB2006 and upgraded QODBC to the new Server license for QB2006 it started producing this error.  We have reset the Use DCOM Server and the absolute file path to the QB data file in the Screen Setup. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 10:20:22
Just a thought but are the DCOM interactive services the same from the QODBC version 5 which we acquired in 2004 or have they been upgraded for this latest release?  If so, how do we uninstall the old version and install the newer versions of the DCOM interactive services. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-05 11:57:57

qbXMLRPeQODBCInteractive.exe and qbXMLRP2eQODBCInteractive.exe are still the same. Have you restarted the server? Did you understand that the permissions need to be set for the C:\Program Files\QODBC Driver for QuickBooks\ folder too?

When using Windows 2003 Server you also need to check your "Enhanced Security Configuration for Internet Explorer" settings.

The Enhanced Security Configuration for Internet Explorer typically sets the IE security settings to "high", so QuickBooks throws a warning every time it starts, even for the SYSTEM service, which hangs QODBC while waiting for input.


 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 7 
 Joined: 2006-05-05 
 Profile
 Posted : 2006-05-05 12:00:08
yes, we've rebooted twice 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-06 19:19:05

I have reviewed this again on one of my systems that was working with QODBC v5, and basically it stopped working as soon as I installed QODBC v6. I had to reconfigure the directory permissions and DCOMs again from scratch and reboot to get QODBC v6 going again. So regardless whether your web pages worked using QODBC v5, when you upgrade to QODBC v6 you must go through the whole DCOM setup procedure again just like it's brand new.

Note: It's not possible to run both QuickBooks 2003 and 2006 at the same time and still use QODBC.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to