RSS Feed
Knowledgebase : TroubleShooting > Microsoft Products
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 VB Demo. VB Demo will return the data in 2 seconds while running the qu...
TROUBLESHOOTING: QODBC QUERY VERY SLOW IN MS ACCESS PROBLEM DESCRIPTION When trying to open a table in VB demo, it will open one with less than 1000 records, but it takes 2 to 3 minutes. The optimization does not seem to matter. When trying to open a l...
TROUBLESHOOTING: QB MULTI-LINE DESCRIPTION FIELDS 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 0x0A lin...
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 I can conn...
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 use Sample Company provided a...
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: 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: SEVERE DELAY BETWEEN CONNECTION CREATION AND COMMAND EXECUTION IN VB CODE PROBLEM DESCRIPTION Below is a simple application that runs a QODBC stored procedure and dumps the results to a .NET DataSet. The command line app below seems to...
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 error "Pure virtual function call" when conne...
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. Solution to this issue is to re-create the linked table. Ope...
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 trying to connect to QuickBooks through SSIS using QODBC but I am unable to connect to QuickBooks. I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition. I am getting the error: "Er...
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...
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 CAN I USE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use 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 system? I...
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...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and we are trying to get the data out in Excel, but QODBC gives us the old data still. Why? SOLUTIONS: QODBC failed to return full records is usually caused by either corruption of QODBC opti...
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 MS Access database & linked all QODBC tables through QRemote DSN, After that...
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 - MULTIPLE TABLES EXIST ERROR IN 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 been t...
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 - "ERROR PARSING COMPLETE XML RETURN STRING" ERROR WHEN TRYING TO UPDATE TABLE PRICELEVELPERITEM IN MS ACCESS PROBLEM DESCRIPTION: I have constructed an Access database file (in 32bit Access 2003) with tables linked to QuickBooks. I can ...
TROUBLESHOOTING - HOW TO USE DATE() AND DATEADD() FUNCTION IN QODBC PROBLEM DESCRIPTION: I want to write some select statements on both InvoiceLine and SalesReceiptLine that returns all records dated WITHIN the past 30 days, relative to whatever TODAY ...
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...
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 Online...
TROUBLESHOOTING - MICROSOFT  EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT  ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I am having significant difficulties with QODBC...
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 now all our Linked Servers timeout. I test the QODBC connect...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL SERVER PROBLEM DESCRIPTION: So the QODBC works great running on the machine. We have the intent to integrate into our website / Intranet to create customers or make changes from the web...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code which reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV u...
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...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I just recently installed QODBC to try to get data out of a QuickBooks company file but I get this error: "...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where SSIS package will be developed, deployed or SSIS services are installed. Development - On the machine, you are developing SSIS package - You should have QODBC install...
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 New Standard EXE ...
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 that it can connect only 1 company fil...
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 that How to insert Invoice in QuickBooks using the data available in Exce...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using MS Excel application, please make sure you have installed MS Office C...
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 How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://suppor...
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 ...