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