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 : This instance of QuickBooks does not support the requested QBXMLVersion.Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 This instance of QuickBooks does not support the requested QBXMLVersion. 
 Author   Message 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-05 04:39:42

I receive the above message in the Remote Connector Logging window when I am trying to connect to a Quickbooks file using Remote Connector from my  localhost instance of PHP using the sample file DisplaySQL.php.   The Visual Basic Demo retrieves data using Remote Connector.

My final intent is to have PHP at a remote site retrieving data from the Quickbooks file located here in our internal network.  From what I've read comparing Remote Connector and DCOM I am trying the simpler solution of Remote Connector because I only need the PHP instance to send queries to the Quickbooks file to create an invoice which will display on the PHP page.  I only need PHP to access Quickbooks, not someone access the Quickbooks data directly.  I am first seeing if it is possible on my localhost PHP server.

I am using a PHP instance on Windows XP Pro.  I have QODBC Desktop Read/Write version 6.00.00.176 installed on the client side and am running Remote Connector on the host side.  The host and client PC both have Quickbooks 2006 v.15.0.0.4004.0.  I've tried this with two different host PCs and receive the same results.  I've used the Quickbooks updates manager to update Quickbooks for all PCs.

I notice there is a previous posting regarding Windows Terminal Server but that environment doesn't seem to apply here.  Is there a further update I need to perform?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-05 08:31:34
See: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? for the proper setup. Basically you just need to set up the host and client on the same computer using localhost. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-05 09:59:11

Thanks for your quick response.  Yes, I followed this document when setting up.  Just now I changed both my client and host to point to localhost for testing.  I received the same following error messages in the logging window of the host:

[6/4/2007 4:07:19 PM - 127.0.0.1] Error: 751: This instance of QuickBooks does not support the requested QBXMLVersion.
[6/4/2007 4:07:19 PM - 127.0.0.1] Client has disconnected.
[6/4/2007 4:07:19 PM - 127.0.0.1] Client has connected.
[6/4/2007 4:07:19 PM - 127.0.0.1] Client has disconnected.
[6/4/2007 4:07:19 PM - 127.0.0.1] Client has connected.
[6/4/2007 4:07:20 PM - 127.0.0.1] Client has disconnected.
[6/4/2007 4:07:20 PM - 127.0.0.1] Client has connected.
[6/4/2007 4:07:20 PM - 127.0.0.1] Client has disconnected.

Earlier while I was testing on my local network I would set the host pc (the one running Quickbooks with IP address 192.168.1.159) to run the Remote Connector service, with Authentication.  Next, I would set the client PC (the one with PHP running on localhost and the QODBC driver) to use the Remote Connector URL as http://192.168.1.159:2080.

Any ideas what I may be missing?  I see upon closer inspection of the above instruction file I need two licenses of  QODBC.  I have one purchase on the client PC and the evaluation copy on the host PC has expired.  Would this explain why I'm getting the above message?

 

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

Please state the exact version of QuickBooks you are using?  For example: QuickBooks 2006 Premier Edition USA version

To use QODBC, your copies of QuickBooks must be registered. A expired QODBC evaluation will no longer work. A QODBC licence is required for each computer QODBC is run on.

 

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-06 02:34:22

QuickBooks Premier Edition 2006 for Canada: Accountant and Bookkeeper.

We have a licenced copy of Quickbooks on the accountant's PC but not registered.  On my PC we have a licenced copy of QODBC which has been extracting and inserting data successfully via the local network from the accountant's Quickbooks copy over the last half year.

Upon further inspection I see the other test host, the accountant's PC, has a non-expired trial version of QODBC and yet the previously mentioned error occurs.  Does it need a licenced copy of QODBC and not the trial version to resolve the error?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-06 09:03:30
Register the copy of QuickBooks and use VB Demo, not PHP, to sort out your connections first. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-06 09:11:45
I will register the copy of QuickBooks but I have already been using VB Demo successfully for 6 months and I tested VB Demo using Remote Connector and that works but my end goal is to use PHP because we need the integration between PHP and Quickbooks for further projects. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-07 03:49:55
I'm just wondering based on the configuration mentioned previously if we'll need the DCOM configuration?  I thought reading the articles on the forum I could make it work with Remote Connector but now I'm not sure. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-07 09:33:23

The QODBC Remote Connector is intended for destop applications only. While it has been found to work with some services, it's not supported and the QODBC Server Edition using DOMs is intended for use with Windows services or applications that call through a Windows Service.

Because you're using the Canada version of QuickBooks you can try forcing 2002 & 2003 support as I've had reports that this needs to be forced on non-USA versions of QuickBooks.

 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-08 09:14:30
OK.  We've decided we will go with the DCOM service.  I've read the documentation but am still unclear as to the following.  Can the Quickbooks file reside on our local network where the accountant will work with local network speed and the PHP server be at a remote location?  We are concerned if the Quickbooks file is at a remote location this will be too slow for day to day operations for the accountant. 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-08 09:39:26
The actual company file can be anywhere on the network, what I'm talking about here is QuickBooks. QODBC talks to QuickBooks and QuickBooks talks to the company file. Is that clearer? 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-08 10:18:31

I'm getting there.  Quickbooks company file anywhere on the local network in the office (on the accountant's PC in this case along with Quickbooks program so he can use Quickbooks)-that makes sense.  The PHP server is partnered with QODBC driver, Server Edition, both at a remote location miles away.

This following part I'm not clear on.  Are you saying there needs to be a copy of Quickbooks program at the PHP server site, as well?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-08 11:09:10
Yes, the QODBC DCOMs call QuickBooks directly. It needs to find QuickBooks to work. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-08 13:38:00

It sounds like I'll need another licensed copy of Quickbooks program at the PHP server end. 

How does the Quickbooks program at the PHP server end find the Quickbooks data file on the local network?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-08 19:46:39
The PHP server will need to be on the local network or remotely via a VPN. 

  Top 
  Jeremy 
  
 Group: Members 
 Posts: 10 
 Joined: 2006-11-01 
 Profile
 Posted : 2007-06-09 03:07:28

The PHP server cannot be on the local network at this time which means we would need to use a VPN. 

Would the following set up work?  Miles away at the remote end of the VPN we would have the PHP server, QODBC Enterprise running DCOM.  QODBC via the VPN would talk to the local network Quickbooks program which would talk to the Quickbooks data file located at the same PC as the Quickbooks program.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-06-09 10:34:16
It might (if your'e lucky) but the time to start and respond will be so slow. Most developers copy their QuickBooks data to MS SQL Server or MySQL server and query those databases over the net. This way you only need to update the server tables which can even be done remotely using a copy of the company file. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to