Knowledgebase
[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.

Problem:

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.

Solution:
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
http://support.flexquarters.com/supportfiles/QBXMLRP2-13.24.4005/QBXMLRP2.zip

Please also refer:
http://www.sleeter.com/blog/2014/06/quickbooks-2014-r6-bugs/

Tags :

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

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).