RSS Feed
Knowledgebase : TroubleShooting > Microsoft Products
     

[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...
[QODBC-ALL] TROUBLESHOOTING - UNABLE TO EXECUTE UPDATE STATEMENT WHEN USING SQL SERVER 2019 LINKED SERVER ON WINDOWS 11 OR WINDOWS SERVER 2019 ISSUE: We recently upgraded our Windows OS to Windows 11 and SQL Server to 2019. We can connect from SQL Se...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - EXCEL CRASHES WHEN USING SQL STATEMENT WITH TWO INNER JOINS ALONG WITH UNOPTIMIZED PROBLEM DESCRIPTION I am using Microsoft Excel. I am using the following SQL statement. SELECT TransferInventoryLin...
HOW TO USE POWERSHELL WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/PowerShell/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: $connectstring = "DSN=QuickBooks Data;" $sql = "Select TOP 10 Name from Customer" $conn ...
HOW TO IMPORT QUICKBOOKS DATA TO SQL SERVER DATABASE (LOCAL TABLE) First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://sup...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using the MS Excel application, please ensure you have installed the MS Off...
HOW TO INSERT INVOICE USING EXCEL - VBA Download Sample [http://support.flexquarters.com/esupport/newimages/InsertInvoiceVBA/Insert_Invoice.zip] In this example, We will show you How to insert an Invoice in QuickBooks using the data available in an Exc...
CONNECTING MULTIPLE QUICKBOOKS COMPANIES VIA EXCEL Download Sample [http://support.flexquarters.com/esupport/newimages/MultipleCompany/MultipleQBCompanyConnection.zip] There is a limitation with the QuickBooks SDK: it can connect only one company file ...
USING ADODC AND ADODB WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/VB6/QODBCVB6.zip] ADODB WITH QODBC Open VB6, you can find it via Windows Start->All Programs->Microsoft Visual Studio 6.0 : Create a New Standard EX...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where the SSIS package will be developed and deployed, or SSIS services are installed. Development - On the machine, you are developing, the SSIS package should have QODBC ...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE ARRAY BOUNDS." WHEN USING THE IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I recently installed QODBC to get data out of a QuickBooks company file, but I get this error: "Index was outs...
HOW TO USE QODBC WITH MS EXCEL POWER QUERY NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click wi...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code that reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV us...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works excellently running on the machine. We intend to integrate into our website / Intranet to create customers or make changes from the web. I...
TROUBLESHOOTING - GETTING TIMEOUT ERROR IN SQL SERVER'S LINKED SERVER USING QODBC PROBLEM DESCRIPTION: I recently upgraded from 1.0.0.7 to 1.0.0.312. Everything was pretty smooth, except for our Linked Servers timeout now. I test the QODBC connection,...
TROUBLESHOOTING - MICROSOFT  EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT  ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I have been having significant difficulties wit...
CONNECTING QODBC ONLINE DRIVER TO QUICKBOOKS ONLINE FOR THE FIRST TIME  (VIDEO) For system requirement details of QODBC Online, click here [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2816]. How to install QODBC Onlin...
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 USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on InvoiceLine and SalesReceiptLine that return all records dated WITHIN the past 30 days relative to whatever TODAY is. I'm...
TROUBLESHOOTING - "ERROR PARSING COMPLETE XML RETURN STRING" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I constructed an Access database file (32bit Access 2003) with tables linked to QuickBooks. I can pull inf...
TROUBLESHOOTING - CANNOT USE ALIAS IN MS QUERY PROBLEM DESCRIPTION: I am getting the below error message when trying to SELECT data fields AS Alias, the statement runs fine otherwise. [sql syntax error] Expected lexical element not found:= Please se...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN THE LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server, and the connection has b...
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: MS ACCESS AS MIDDLEWARE IS NOT WORKING WITH MS SQL SERVER PROBLEM DESCRIPTION: I am trying to use MS Access as a middleware with MS SQL Server. I have created an MS Access database & linked all QODBC tables through QRemote DSN. After t...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and are trying to get the data out in Excel, but QODBC gives us the old data. Why? SOLUTIONS: QODBC failure to return full records is usually caused by corruption of the QODBC optimizer file....
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...
HOW CAN I USE THE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use the same Excel files in 64 & 32-bit Systems? Is it possible to have a connection setup in an Excel file and be able to refresh on either a 64 or 32-bit syst...
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...
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...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot connect to QuickBooks. I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition. I am getting the error: "Error ...
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...
HOW TO GET UPDATED CUSTOM FIELD WITH MS-ACCESS (LINKED TABLE) IN QUICKBOOKS New Custom Fields are created within QuickBooks. In MS Access Newly created Custom Fields are not visible. The solution to this issue is to re-create the linked table. ...
Pure Virtual Function Call Error TROUBLESHOOTING: THE "PURE VIRTUAL FUNCTION CALL" ERROR WHEN USING QODBC WITH MS EXCEL OR ACCESS PROBLEM DESCRIPTION When using QODBC with MS Excel or Access, QODBC throws the error "Pure virtual function call" when c...
TROUBLESHOOTING: SEVERE DELAY BETWEEN CONNECTION CREATION AND COMMAND EXECUTION IN VB CODE PROBLEM DESCRIPTION Below is a simple application running a QODBC stored procedure and dumping the results into a .NET DataSet. The command line app below seems ...
TROUBLESHOOTING: ACCESS 97 CRASHES WHEN USING QODBC WITH IT PROBLEM DESCRIPTION When we try to link our Access 97 database to QuickBooks using QODBC v10, our Access database crashes with the typical "send error report" screen as below. The VBDEMO progra...
TROUBLESHOOTING: MICROSOFT OFFICE ACCESS HAS ENCOUNTERED A PROBLEM AND NEEDS TO CLOSE ERROR WHEN LINKING TABLES PROBLEM DESCRIPTION Several times (but not every time) when I try to add a new linked table in my Access 2003 database via New > Linked Tab...
TROUBLESHOOTING: SPEED ISSUE WHEN RESOLVED DATA PROVIDER OR OTHER SERVICE RETURNED AN E_FAIL STATUS ERROR PROBLEM DESCRIPTION 1 We are using QuickBooks Enterprise Canadian Edition 2004 and QODBC Version 6.0.0.150. When we used Sample Company provided ...
TROUBLESHOOTING: TOO MANY INDEXES ERROR PROBLEM DESCRIPTION 1 I just purchased QODBC Desktop Driver for QuickBooks USA 2008 Read Only. I am running QuickBooks 2006 - the 5-user version where the QB file is on a server. I installed QODBC and can connec...
TROUBLESHOOTING: QB MULTI-LINE DESCRIPTION FIELDS ARE NOT DISPLAYED PROPERLY IN MS ACCESS REPORTS PROBLEM DESCRIPTION 1 I have found that the text I received from QODBC for multi-line fields (e.g., the item purchase or sales description) uses only 0x0...
TROUBLESHOOTING: QODBC QUERY VERY SLOW IN MS ACCESS PROBLEM DESCRIPTION The optimization does not seem to matter. When trying to open a table in QODBC Support Wizard [https://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/Vi...
TROUBLESHOOTING: SLOW PERFORMANCE WITH EXCEL MS QUERY PROBLEM DESCRIPTION I am experiencing a huge delay when running a Query in the Excel MS Query versus running the same script in QODBC Support Wizard [https://support.flexquarters.com/esupport/index.p...