TROUBLESHOOTING - HOW TO FREE DISK SIZE MESSAGE
PROBLEM DESCRIPTION:
When I connect to QODBC, I am prompted to free disk space.
SOLUTION:
Please ensure you have 1 GB of free space in your primary drive where
your Windows Profile / Roaming Profile or...
[QODBC-DESKTOP] TROUBLESHOOTING - NO DATA RETURNED - UNABLE TO EXECUTE
- INVENTORYSTOCKSTATUSBYITEM
PROBLEM DESCRIPTION
Upon pulling QuickBooks data into Microsoft Access, I didn't see any
values (all blank) in the QuantityonOrder field of either the...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QODBC DRIVER FOR
QUICKBOOKS ONLINE
PROBLEM DESCRIPTION:
I want to cancel my QODBC Driver for QuickBooks Online monthly
subscription.
How to cancel the subscription of QODBC Driver for QuickBooks Onl...
TROUBLESHOOTING - GETTING MULTIPLE-STEP OLE DB OPERATION GENERATED
ERRORS IN SQL SERVER
PROBLEM DESCRIPTION:
Trying to insert into SalesOrderLine and getting a 'Multiple-step'
error.
INSERT INTO QBREMOTE...SalesOrderLine (CustomerRefListID,
TemplateR...
HOW TO USE QXL
STEP 1 - DOWNLOAD QXL
If you haven't already downloaded QXL, go to the download page
[http://qxl1.com/qxl-for-quickbooks-desktop-downloads/] now. Don't
forget to read the "Readme" file during installation for the latest
information on QX...
TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE VALUE IS NULL
PROBLEM DESCRIPTION:
I am trying to run a report that returns ItemInventory where
LastReceived is NULL. I have tried in vain to accomplish this. What
syntax do you use to select a blank/nu...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE
PROBLEM DESCRIPTION:
When ting sets QODBC POS DSN to access the company file running in
QuickBooks POS (Version 10), it will fail to connect to the company
file. QuickBooks POS will search for th...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ
PROBLEM DESCRIPTION:
I have the invoice number (RefNumber) from my table outside
QuickBooks. But if a QuickBooks user creates invoices directly in
QuickBooks, then QuickBooks keeps new incrementing invoices
autom...
TROUBLESHOOTING - HOW TO TAKE A SCREENSHOT
PROBLEM DESCRIPTION:
How do I take an error screenshot?
SOLUTIONS:
If you've got a problem with a Windows program, you may wonder how to
show the errors you're receiving. Luckily, taking a screenshot of yo...
TROUBLESHOOTING - HOW TO ADJUST THE VALUE OF A STOCK ITEM WITHOUT
CHANGING THE STOCK QUANTITY
PROBLEM DESCRIPTION:
Can I adjust the value of a stock item without changing the stock
quantity?
SOLUTIONS:
Yes, you can adjust the value of a stock item ...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY
PROBLEM DESCRIPTION:
I've linked all the QODBC tables into an Access 2010 DB. I have
created table subset queries on the original tables and would like to
do selects based on date ranges - other thi...
TROUBLESHOOTING - UNABLE TO FIND TABLE QBADVANCEDREPORTGROUP.
PROBLEM DESCRIPTION 1:
1. I'm attempting to utilize your ODBC driver for reporting through
Excel from QuickBooks Enterprise. The tables in your report help guide
aren't accessible to me and a...
HOW TO ADD ADDITIONAL QUOTE (') IN INSERT STATEMENT USING QODBC
PROBLEM DESCRIPTION:
I have exported the customer list from QB, and Now I want to insert
these using the insert query. But some of them fail because of the
apostrophe (').
How to deal with...
QODBC SHOWS RUNTIME ERROR R6025 PURE VIRTUAL FUNCTION CALL WHEN USING
MS ACCESS
PROBLEM:
I have created the link to the Customer table in MS Access using
QODBC. I can link the table without any error, But when I try to edit
any field from the linked ta...
TROUBLESHOOTING: ERROR:3000-THE GIVEN OBJECT ID "IN THE FIELD "LISTID"
IS INVALID
PROBLEM DESCRIPTION:
When making an inventory adjustment in a company file whose multiple
inventory sites feature is not enabled, there are no values in the
field "Invent...
PROBLEM:
I have a customer who does their invoicing with an ASP.NET
application, and it flows into QuickBooks. I created the interface
with QODBC, and it works with no problem except that sometimes the
processes will lock up, and I have to remote into th...
HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING
PROBLEM DESCRIPTION:
QODBC and my application are not responding. How can I know what QODBC
is performing in the background?
SOLUTION:
You can enable the QODBC status panel via Start >> All Programs >>...
PROBLEM DESCRIPTION:
When trying to connect to QuickBooks using QODBC Test Tool, I am
facing the error :
QB Begin Session Failed. Error Calling OpenQBConnection Returned
Error: 10061 - [10061] Connection refused
SOLUTION:
Please first keep QuickBoo...
PROBLEM DESCRIPTION:
I am getting the error ODBC CALL FAILED- ERROR 10004 when trying to
connect QuickBooks through MS Access using QODBC.
SOLUTION:
Please keep QuickBooks running, Log in as Admin to your company file,
Switch to single-user mode and t...
Check if the table you are importing has any long fields and exclude
them from the import. Some tables in QuickBooks have fields as long as
4095 characters and cannot fit in a single spreadsheet cell.
An excellent example of this is the InvoiceLine tabl...
Environment
QuickBooks 2014
QODBC 14.0.0.298
QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to
communicate with QuickBooks & QuickBooks company files. QODBC can
show/fetch only the information which is exposed/provided by
QuickBo...
TROUBLESHOOTING - QREMOTE INITIALIZATION ERROR, ERROR: LISTENING
FAILED. PLEASE RESTART APPLICATION
PROBLEM DESCRIPTION 1:
QRemote Initialization Error,
QRemote Error: Listening failed. Please restart application
QRemote Closing in 15 Seconds.
PR...
TROUBLESHOOTING: TIMETRACKING / TRANSACTION TABLE IS BLANK
PROBLEM DESCRIPTION:
The TimeTracking / Transaction table always returns null/ no rows. I
tried to reset the QODBC optimizer, but it didn't work.
SOLUTION:
Please update your QuickBooks to ...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION -
QBOE
PROBLEM DESCRIPTION:
When trying to update the memo field in the table Invoice or
InvoiceLine, QODBC reports the error:
[QODBC]Error:1030-Not Support
It is not only in the ...
TROUBLESHOOTING: GETTING A LIMITED NUMBER OF RECORDS OR A FEW OF THE
RECORDS ARE MISSING IN THE QODBC TABLE RESULT.
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index...
"HY111 database connector error invalid bookmark value" on crystal
report when refreshing the report.
SOLUTIONS
This could be the issue with the company file or Optimizer.
I kindly request you follow the steps and let us know if that resolves
the is...
This method is Discontinued. Please refer new product QODBC for
QuickBooks Online:
How to use QODBC Online with QuickBooks Online Edition (Apps.com)
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658]
How to Reconnect...
Why can VB Demo only display 10000 records?
TROUBLESHOOTING: THE RESULTSET LIMITATION IN VB DEMO
PROBLEM DESCRIPTION:
When running the VB test application, only 10,000 records are returned
from the table, even though there are more than 10K records ...
ERROR: 'CAPABILITY NOT SUPPORTED' IN DELPHI WITH QODBC
PROBLEM DESCRIPTION
I am using Delphi to access the QODBC driver. Simple test program.
Have a query, data source, and grid on a form. Database Name in the
Query properties is set to QUICKBOOKS DA...
TROUBLESHOOTING: DELETE OPERATION VERY SLOW IN DATAFLEX
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/]
PROBLEM DESCRIPTI...
Searching for available servers message
TROUBLESHOOTING: SEARCHING FOR AVAILABLE SERVERS MESSAGE
NOTE: All the related information comes from Intuit forum.
PROBLEM DESCRIPTION
When the code reaches sessionManager, BeginSession, a message comes
as f...
TROUBLESHOOTING: XERCES-COM.DLL ERROR - ACTIVEX COMPONENT CAN'T CREATE
AN OBJECT
PROBLEM DESCRIPTION
If you run the TestDCOM.asp page supplied with QODBC, and get the
following results:
QODBC ASP DCOM Access Test Page QB2002QB2003QB2004DCOMCOMObjec...
TROUBLESHOOTING: QODBC CONNECTION LIFECYCLE WITH VB
PROBLEM DESCRIPTION:
I have a VB6 application that queries QuickBooks. QODBC takes about 10
seconds to make the handshake with the connection string, so any query
to QuickBooks is very slow if I creat...
TROUBLESHOOTING: ADO QUERY RETURNS EOF WHEN WRONG CURSOR TYPE IS USED
PROBLEM DESCRIPTION
A Select query works with the QODBC Support Wizard
[https://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2981]
but not with the ...
TROUBLESHOOTING: CHINESE CHARACTER CANNOT EXPORT FROM QUICKBOOKS
NORMALLY
PROBLEM DESCRIPTION
I can't transfer the Chinese character from QuickBooks to third-party
software usually. All of the words become #$%&^$&. Whether QODBC
cannot support Chinese...
TROUBLESHOOTING: ERROR WHEN USING QODBC WITH VISUAL STUDIO 2008
PROBLEM DESCRIPTION
I am trying to use the QODBC connection using Visual Studio 2008.
The 2.1 Compatibility option in QODBC Setup Screen -> Advanced tab is
unchecked.
Test Connectio...
TROUBLESHOOTING: CRW32.EXE HAS ENCOUNTERED A PROBLEM AND NEEDS TO
CLOSE
PROBLEM DESCRIPTION
Whenever I go into Crystal 9 and try to create reports with more than
one table, like Employee and Employee Earnings, Crystal errors out
every time with the err...
TROUBLESHOOTING: AN INTERNAL QUICKBOOKS ERROR OCCURRED WHILE ACCESSING
THE QUICKBOOKS COMPANY DATA FILE.
PROBLEM DESCRIPTION
When using QuickBooks Premier 2007 Canadian Edition and QODBC
7.0.0.214. We try to connect to the QB database with the help of...
Help Desk Software by Kayako