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 : qbXMLRPeInteractive & qbXMLRP2eInteractive NOT loadableSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 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 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-31 10:01:04
Try the procedure outlined at: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP?  

  Top 
  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?
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.
 

  Top 
  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.
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.

 

  Top 
  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. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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). 

  Top 
  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. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-06-01 11:27:25
Please use a local session (at the server's keyboard and screen) and follow the procedure outlined at: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? again. 

  Top 
  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? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.

 

  Top 
  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? 

  Top 
  Anonymous 
  
 Group: Unknow 
 Posts: Unknow 
 Joined: Unknow 
 Profile
 Posted : 2006-06-02 10:27:48

Ok, if you're prepared to test on a test server, then why not try a Windows XP Pro notebook as it's a little easier using the procedure outlined at: How can I see QuickBooks data in a Internet Explorer Browser using Windows XP? again. 

You will also need to make sure IIS is installed in Windows XP Pro as it's not installed by default.

 

  Top 
  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). 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.

 

  Top 
  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?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-06-03 12:11:24

Ok, use the our automatic tool found at: How do I automatically setup the QODBC DCOM Servers?  then reboot the server and check the DCOM Settings as per How do I manually setup the QODBC DCOM Servers on Windows XP Pro and Windows 2003 Server? .

Make sure everyting is checked in the Security tab for qbXMLRPeInteractive and qbXMLRP2eInteractive:

and finally the Interactive identity:

 

 

  Top 
  Mike 
  
 Group: Members 
 Posts: 12 
 Joined: 2006-05-31 
 Profile
 Posted : 2006-06-03 15:06:16
Tried. No luck.
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to