RSS Feed
Knowledgebase : TroubleShooting > Others
     

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