qbXMLRPeInteractive & qbXMLRP2eInteractive NOT loadable |
Author |
Message |
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-05-31 03:27:36 |
I am using Windows Server 2003. I've followed the installation guides on the website to install QODBC. When testing the connection to QB (in the QODBC Setup Screen) it returns as successful with no errors. I have tried setting up the DCOMs using the automatic tool, and by following the manual instructions for Server 2003. I cannot get qbXMLRPeInteractive.exe OR qbXMLRP2eInteractive.exe to show a status of "success" when running TestDCOM.asp. After running the automatic setup, TestDCOM.asp shows "Error: Permission denied" for these two executables. If I manually add in a "Internet Guest Account" (the automatic tool does not create one) to the Launch/Access Permissions for these executables (and check "allow" for all checkboxes available), and run TestDCOM.asp again, I get an error with no description. I changed the file to produce the error code, and this is what it returns as an error code after I add that guest account: "-2147467238"
I have tried all all sorts of things to get the permissions set correctly, but I cannot get these files to load. Therefore, TestDCOM.asp is producing errors, and DisplaySQL.asp just hangs and produces no output. Even after I ran the automatic DCOM setup script, those executables were supposed to be in memory (according to the site). Using Ctrl+Alt+Del to see what was running showed that those executables were not even loaded and I didn't need to "end the process" on them. I'm not sure if that's normal.
Has anyone else had this issue? Is there something I can do to fix this problem and get up and running? Any help would be appreciated. Thanks!
Mike |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-31 10:01:04 |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-05-31 14:59:23 |
Thanks. I gave that a shot and still nothing. I get the same permission errors. Even on loading the sample file in the server still hangs and doesnt load past this:
QODBC Customer Web List Demo Page Preparing to Create Connection Object ADO Connection Created ADO Recordset Created - Opening QuickBooks Sample Company File
The data does not display. What could be the problem? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-31 15:41:43 |
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. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-05-31 19:08:01 |
I gave that a shot also. Even completely removed the component "Enhanced Security Configuration for Internet Explorer" but the DCOM test still fails and the sample scipts hang. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-31 22:58:42 |
I doubt this is a DCOM issue, but something higher up. Have you given 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 should be getting an error when you run qbcust.asp. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-01 05:04:30 |
I gave that a shot also. Gave full permission to all the security objects listed for that folder. DCOM still fails. QBcust.asp just hangs after it says it's going to display the data. It does not give an error. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-01 08:26:26 |
Please outline your QuickBooks version and whether or not you're running Terminal Server, Citrix or attempting to configure this using a remote desktop? For qbcust.asp to work QuickBooks must be installed on the server console and a local session running (ie: you must be logged in as administrator on the server). |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-01 11:15:54 |
I am using Quickbooks 6.0 Enterprise Edition. I have a dedicated server (Win Server 2003) which I log into via remote desktop. I'm using the sample file that comes with QB, have the permissions set to allow Flex to access it (within QB). It is set to multi-user. I login to the server as administrator and have installed and set permissions using this admin account. I remain logged in while trying to access the test files. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-01 11:27:25 |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-01 11:29:26 |
I don't have access to the physical server. It is a dedicated server purchased with GoDaddy. Logged in as administrator via remote desktop should be the same as sitting in front of the computer, no? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-01 13:24:30 |
Well not really, you will need to co-ordinate this issue and address any security settings with GoDaddy staff directly. There may be other Active X , port settings and router settings that may be causing your problems. Most hosting companies are pretty tight on the security settings on all the servers in their server farms. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-02 10:10:07 |
I tried setting everything up again on a different server (Win Server 2003 - not on GoDaddy). I still have the exact same problems. The VBDemo apllication works just fine. I monitored the task manager while running it, and QBXMLRP2EQODBCInteractive.exe loads without a problem. It seems the webserver is just not able to create this object when the ASP file requests it. It just displays "Error:" in TestDCOM.asp - with no error description. Is there anything I'm missing that would prevent the webserver from being able to run QBXMLRP2EQODBCInteractive.exe and produce the data on the webpage? I've tried so many things, even granting administrator (or "full control") rights to all the required security objects for all files that I have been told about including: c\windows\system32\fqqbc32.exe, c\windows\system32\fqqb32.dll, c\windows\system32\I9K4UQLW.ocx, c\windows\odbc.ini, and c\windows\odbcinst.ini. Also, of course, modified the security settings of the two DCOM objects using the automated tool. I don't know what else to try. Any thoughts? |
|
|
|
|
Posted : 2006-06-02 10:27:48 |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-02 19:25:07 |
I just tried it on my local XP Pro machine and everything worked just fine. The problem is I can't change the operating system of the dedicated servers to XP, they only allow Server 2003. I can't run two operating systems on the machine because I'm not physically at the computer during boot up to select XP as my OS. Any thoughts on this? Know where I could get a dedicated server with WinXP Pro as the OS?
Also, once I have it all set up correctly....will the remote connector allow the employees in my office to load their local version of quickbooks 6.0 enterprise on their machines, but all be using the one and only company file that is located across the internet on the dedicated server? (i.e. There is one company filed shared among everyone in my office, and that file is located on the dedicated server and not within the office LAN). |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-02 20:51:23 |
Now you have seen how it works, it should be easier to work on your test Windows Server 2003 you have. On the server console (local session) make sure that IIS and the Anonymous web user IUSR_machinename works correctly with a test ASP page first.
As I said earier, for you not to get any error message means it's not even getting to the QODBC DCOM servers. You have to make sure that VB Demo can do a "Select * from Customer" using the QuickBooks Data System DSN without QuickBooks running. Then make sure the DCOM servers are turned on in the QODBC Setup and permissions are set and go back to playing with qbcust.asp.
Don't forget to look at the IWAN settings on the server also. |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-03 02:36:13 |
I still get the following error in qbcust.asp for Win Server2k3:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[QODBC] QB Open Connection Failed. Create DCOM Instance Error = 8000401a, Unknown error.. Created qbXMLRP2 OK.
/qbcust.asp, line 30
VBDemo works just fine, even when QB is closed. Regular ASP files run without problem. QODBC is set to Server Mode (DCOM). Where are these IWAN settings I'm supposed to check? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-06-03 12:11:24 |
|
|
|
Mike |
|
Group | : Members |
Posts | : 12 |
Joined | : 2006-05-31 |
|
Profile |
|
Posted : 2006-06-03 15:06:16 |
Tried. No luck. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-21 10:25:41 |
The difference between Windows XP and Windows Server 2003 is security. Try giving the Internet Guest Account (<IUSR_<machine_name>), ASP.NET Machine Account (ASPNET) and INTERACTIVE accounts all rights to the C:\Program Files\QODBC Driver for QuickBooks\ folder and the following file in your System32 directory, I9K4UQLW.ocx. It may be a hidden, system file.
If you must use your remote Desktop, use this line to connect to the Foreground console on your Windows 2003 server:
mstsc /v:servername /console |
|
|
|