Upgrade to QODBC 2006 and DCOM fails |
Author |
Message |
|
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 |
|
|
|
|
Tom |
|
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? |
|
|
|
|
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. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-05 09:07:10 |
|
|
|
|
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. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-05 09:21:17 |
|
|
|
|
Posted : 2006-05-05 09:26:14 |
Auto Login is set and VB Demo works perfectly. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-05 09:54:21 |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
Tom |
|
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.
|
|
|
|
|
Posted : 2006-05-05 12:00:08 |
yes, we've rebooted twice |
|
|
|
Tom |
|
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. |
|
|
|