[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
(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:
BuildAssembly Table Missing,