Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Error = 8004042b, Auth flags not supported, Multiple versions of QuickBooks |
Author |
Message |
Ben |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-05-03 |
|
Profile |
|
Posted : 2006-05-03 05:38:06 |
Hello,
We just installed QODBC 6.00.00.155 (Read-Only) on Windows Server 2003 Standard SP1 with two versions of QuickBooks installed, 2005 Pro USA Release R1P and 2006 Pro USA Release R3P (because we don't have the option of upgrading the 2005 qbw files to 2006).
QODBC is connecting fine to QuickBooks 2006, but with QuickBooks 2005 it gives the error:
Test Connection to QuickBooks Failed
[QODBC] QB Begin Session Failed. Error = 8004042b, This call is unavailable in this version of QuickBooks.
QODBC Messages shows:
2006-05-02 14:26:11 QODBC Ver: 6.00.00.155 ********************************************************************************************************************* IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 8004042b, This call is unavailable in this version of QuickBooks. Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"
SDK Messages show:
========= Started Connection ========= Request Processor, QBXMLRP2 v5.0 Connection opened by app named 'FLEXquarters QODBC' Opening the file in the DoNotCare mode. Auth flags not supported in this version of QuickBooks. Connection closed by app named 'FLEXquarters QODBC' ========== Ended Connection ==========
Nothing shows up in the Trace Log with Detail Tracing enabled.
I've tried it with almost every combination of options in the Advanced setup tab, but no luck. We're not using DCOM or IBiz.
The Windows 2003 Server box was working fine for both QB 2005 and QB 2006 using the free QODBC driver bundled with QReportGrabber, but when we installed QODBC 6.00.00.155 (Read-Only), QuickBooks 2005 stopped working. I tried deleting/re-adding QODBC in the Quickbooks "Integrated Applications" as suggested at http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=2&post_id=1 but this didn't help.
Any ideas? Thanks in advance. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-03 09:59:18 |
Sorry, QODBC is intended to work with only version of QuickBooks on a computer. In your case, you installed QuickBooks 2006 Pro USA Release R3P last, so your C:\Program Files\Common Files\Intuit\QuickBooks folder contains QBXMLRP2.dll v5.0 R4000 +5 (for QuickBooks 2006) instead of v4.0 R4000 +7 used in QuickBooks 2005. Because Request Processor QBXMLRP2 v5.0 is found, QODBC v6.00.00.155 auto-detects QuickBooks 2006 and will connect using SDK 5.0 instead of SDK 4.0 used by QuickBooks 2005. |
|
|
|
Ben |
|
Group | : Members |
Posts | : 2 |
Joined | : 2006-05-03 |
|
Profile |
|
Posted : 2006-05-03 11:38:08 |
Thanks for the quick answer, Tom.
The only thing I can't figure out is why the 30-day trial version of QODBC that ships with QReportGrabber was working fine with QuickBooks 2005 before we upgraded to the full read-only version of QODBC v6.00.00.155. I'm actually not sure that QODBC was working with QB 2006 before, but QB 2005 was definately working. Strange.
Is there any solution to our problem? We know up-front which version of QuickBooks we'll be processing before we launch QODBC, so could get away with swapping out QBXMLRP2.dll dynamically? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-03 11:53:24 |
The OEM version shipped in QReportGrabber is earlier than v6.00.00.155.
Our support is also limited to only one version of QuickBooks on a computer. Most users open their QuickBooks 2005 company file in QuickBooks 2006 and allow it to upgrade their company file to the new 2006 format (after doing a backup of course). |
|
|
|
|