[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...
Help Desk Software by Kayako