[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 installation QuickBooks 2014 R6 on Windows XP and Windows 2003 machine.


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

Execute below query
Select * from HostSupportedVersion 

(The query would show only 4 rows, if it's so, please refer 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 missing fields.

Check Updates on QuickBooks OR Contact Intuit for 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 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 copy of QBXMLRP2.dll from R5 installation, you can download it from

Please also refer:

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 enter the text you see in the image into the textbox below (we use this to prevent automated submissions).