RSS Feed
Knowledgebase : TroubleShooting > Others
TROUBLESHOOTING: AN INTERNAL QUICKBOOKS ERROR OCCURRED WHILE TRYING TO ACCESS 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 QB database with the help...
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 error: ...
TROUBLESHOOTING: ERROR WHEN USING QODBC WITH VISUAL STUDIO 2008 PROBLEM DESCRIPTION I am trying to use QODBC connection using Visual Studio 2008. The 2.1 Compatibility option in QODBC Setup Screen -> Advanced tab is unchecked. Test Connection wo...
TROUBLESHOOTING: CHINESE CHARACTER CANNOT EXPORT FROM QUICKBOOKS NORMALLY PROBLEM DESCRIPTION I can't transfer the chinese character from QuickBooks to third-party software normally. All of the words become #$%&^$&. Whether QODBC cannot support Chines...
TROUBLESHOOTING: ADO QUERY RETURNS EOF WHEN WRONG CURSOR TYPE IS USED PROBLEM DESCRIPTION A Select query works with the VB Demo but not with the sample code below in Delphi: begin try oConn := TAdoConnection.CREATE(Self); oConn.ConnectionString := 'Pr...
TROUBLESHOOTING: QODBC CONNECTION LIFECYCLE WITH VB PROBLEM DESCRIPTION: I have a VB6 application that query's QuickBooks. What are the performance considerations regarding leaving a QODBC connection open when not actively using it? QODBC takes about 1...
TROUBLESHOOTING: XERCES-COM.DLL ERROR - ACTIVEX COMPONENT CAN'T CREATE OBJECT PROBLEM DESCRIPTION If you run the TestDCOM.asp page supplied with QODBC, and get the following results: QODBC ASP DCOM Access Test Page QB2002QB2003QB2004DCOMCOMObject N...
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 fol...
TROUBLESHOOTING: DELETE OPERATION VERY SLOW IN DATAFLEX PROBLEM DESCRIPTION I have an 800MB DataFlex table with several million records and I am trying to delete them all. What I need is an empty version of the table and since FlexODBC doesn't support...
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 DAT...
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 thou there are more than 10K records in th...
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...
"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 to follow steps and let us know if that resolves the iss...
TROUBLESHOOTING: GETTING A LIMITED NUMBER OF RECORDS OR FEW OF THE RECORDS IS MISSING IN QODBC TABLE RESULT. PROBLEM DESCRIPTION 1. When I Query my tables e.g. Bill or Customer, I noticed QODBC is not returning all the records and seems few records ar...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION - QBOE PROBLEM DESCRIPTION: When trying to update memo field in the table Invoice or InvoiceLine, QODBC reports the error: [QODBC]Error:1030-Not Support It is not only in field me...
TROUBLESHOOTING: TIMETRACKING / TRANSACTION TABLE IS BLANK PROBLEM DESCRIPTION: The TimeTracking / Transaction table always return null/ no rows as a result. Tried to reset QODBC optimizer, but doesn't work. SOLUTION: Please update your QuickBooks ...
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...
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 file. QODBC can show/fetch only those information which is exposed/provided by QuickB...
Check to see 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 they cannot fit in a single spreadsheet cell. A good example of this is the InvoiceLin...
PROBLEM DESCRIPTION: I am getting error ODBC CALL FAILED- ERROR 10004 when I am trying to connect QuickBooks through MS Access using QODBC. SOLUTION: Please keep QuickBooks running, Logged in as Admin to your company file, Switch to single user mode a...
PROBLEM DESCRIPTION: When trying to connect to QuickBooks using VB Demo, I am facing the error : QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused SOLUTION: Please first keep QuickBooks runni...
HOW TO VIEW DETAILS ON WHAT QODBC IS PERFORMING PROBLEM DESCRIPTION: How can I view details on what QODBC is performing in the background? SOLUTION: You can enable QODBC status panel via: Start >> All Programs >> QODBC Driver for use with QuickBooks...
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 their...
TROUBLESHOOTING: ERROR:3000-THE GIVEN OBJECT ID "" IN THE FIELD "LISTID" IS INVALID PROBLEM DESCRIPTION: When do an inventory adjustment in a company file whose multiple inventory sites feature is not enabled, there are no values in the field "Inventor...
QODBC SHOWS RUNTIME ERROR R6025 PURE VIRTUAL FUNCTION CALL WHEN USING MS ACCESS PROBLEM: I have created the link to Customer table in MS Access using QODBC. I can link table without any error, But when I try to edit any field from the linked table, I a...
HOW TO ADD ADDITIONAL QUOTE (') IN INSERT STATEMENT USING QODBC PROBLEM DESCRIPTION: I have exported customer list from QB and Now I wanted to insert these using insert query. But some of them are failing because of having the apostrophe ('). How to de...
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 listed in your report help guide aren't accessible to m...
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 - HOW TO ADJUST VALUE OF A STOCK ITEM WITHOUT ADJUSTING STOCK QUANTITY PROBLEM DESCRIPTION: Can I adjust the value of a stock item without adjusting the stock quantity? SOLUTIONS: Yes, you can adjust the value of a stock item withou...
TROUBLESHOOTING - HOW TO TAKE SCREENSHOT PROBLEM DESCRIPTION: How do I take an error screenshot? SOLUTIONS: If you've got a problem with a program in Windows, you may be wondering how to show the errors you're receiving. Luckily, taking a screensho...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ PROBLEM DESCRIPTION: I have invoice number (RefNumber) from my own table outside of QuickBooks. But if QuickBooks user creates invoices directly in QuickBooks then QuickBooks keeps new incrementing invoices autom...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When set QODBC POS DSN to access the company file that is running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for ...
TROUBLESHOOTING - HOW TO SELECT RECORD WHEN VALUE IS NULL PROBLEM DESCRIPTION: I am trying to run a report which returns ItemInventory where LastReceived is NULL I have tried in vain to accomplish this. My question is what syntax do you use to select a...
HOW TO USE QXL STEP 1 - DOWNLOAD QXL If you haven't already downloaded QXL, do it now by going to the download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/]. Don't forget to read the "Readme" file during installation for the latest infor...
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...
TROUBLESHOOTING - HOW TO CANCEL SUBSCRIPTION OF QODBC DESKTOP DRIVER FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QODBC Online monthly subscription. How to cancel the subscription of QODBC Desktop Driver for QuickBooks Online? SO...