[QODBC-Desktop] QODBC is missing tables and fields after upgrading to QuickBooks 2014 R6
Posted by Rajendra Dewani (QODBC Support) on 03 July 2014 08:07 AM

QODBC is missing tables and fields after upgrading to QuickBooks 2014 R6

The issue is noticed after installing QuickBooks 2014 R6 on Windows XP and Windows 2003 machines.


When you connect VB Demo and list the tables, you will notice only 100 tables listed.

Execute below query
Select * from HostSupportedVersion 

(The query would show only four rows, if it's so, please refer to the solution)

On Windows XP & 2003, The QuickBooks SDK (QBXMLRP2.dll) 2014-R6 allows supported version till 2.4 (instead of 13). Thus QODBC shows 100 tables instead of 137, and the same is the reason behind the missing fields.

Check Updates on QuickBooks OR Contact Intuit for a hotfix of QBXMLRP2.dll for WinXP / Windows 2003
Workaround: Uninstall R6 and revert back to R5 OR  Restore the QBXMLRP2.dll  from  R5 installation
Create a Backup of QBXMLRP2.dll
You can locate the QBXMLRP2.dll file (usually in C:\Program Files\Common File\Intuit\QuickBooks, or C:\Program Files (x86)\Common File\Intuit\QuickBooks on 64-bit systems)
Get the QBXMLRP2.dll from R5 installation
Copy it to Common File\Intuit\QuickBooks

If you do not have a copy of QBXMLRP2.dll from the R5 installation, you can download it from

Please also refer to the following:

Tags :

BuildAssembly Table Missing,
InvoiceLine -- TemplateRefFullName is missing
InvoiceLine--ShipAddressNote is missing
Inventory--ManufacturerPartNumber is missing

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).