[QODBC-ALL] TROUBLESHOOTING - WINDOWS CANNOT FIND FQQBSAV.EXE
PROBLEM DESCRIPTION
Issue 1:
I just updated QODBC to the latest build, 349. When trying to connect
to the QRemote DSN, I get the following error message.
Windows cannot find 'fqqbvsav.ex...
USING QODBC WITH OFFICE 64-BIT
QuickBooks is a 32-Bit application, but other applications such as MS
Excel, MS Access, and MS SQL Server are also available in 64-Bit
architecture.
Since a 64-Bit application cannot talk to a 32-bit driver, we have to
d...
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 ...
TROUBLESHOOTING - UPDATE FROM A SELECT STATEMENT NOT WORKING
PROBLEM DESCRIPTION:
I am trying to update records through the select statement. But it is
not working.
UPDATE Customer SET CustomFieldProjectNumber = i.JobNumber FROM (
SELECT ListID, {fn...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER
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://support.flexquarters...
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...
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...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 (64-BIT)
FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2771]
SETUP QODBC TO US...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT
FOR 32-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH
32-BIT MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2470].
CREATING A TABLE IN MICR...
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 - ANOTHER USER HAS CHANGED THIS RECORD SINCE YOU
STARTED EDITING IT.
PROBLEM DESCRIPTION:
I used the QuickBooks Pro 2015 trial version and purchased QODBC's
latest version.
I have an Access database with linked QB tables. I also have ...
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...
REFRESH ON MS EXCEL FAILS.
PROBLEM:
MS Excel shows a data protection error when we click on the "Refresh
All" link.
When you click "OK," you will see the error below.
SOLUTION:
You are receiving this error because your Excel sheet is in PROTECTED
M...
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...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER
NOTE: For multi-line invoices, some may find it easier to NOT include
the header information with each line item, but rather to have
separate smaller commands for the Invoice Lines and a final ...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING
WITH ODBCCOMMAND & PARAMETERS
PROBLEM DESCRIPTION:
QRemote Does not consider FQSaveToCache with working with OdbcCommand
& Parameters.
I have an application that creates Sales Orde...
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...
PROBLEM DESCRIPTION:
How to use parameters in OPENQUERY
SOLUTIONS:
OPENQUERY does not accept variables for its arguments. You need to
Pass Basic Values as below example:
SELECT QUERY:
DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25)
SELECT @ID = '1...
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...
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 - 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 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 ...
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....
QODBC SHOWS A REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR
ACCESS 2013
MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION
OF QODBC READ WRITE OR SERVER EDITION.
MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES WHEN TRYING TO
CO...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC
PROBLEM DESCRIPTION:
When using Prepared Statements with the QRemote driver, it throws an
error called ODBC driver not supported. How can I use Prepared
Statements with QODBC/QRemote?
SOLUTIONS:
You may...
QUESTION:
I've built a table in Access of invoice lines to be added to existing
invoices. I have the TxnID and all the necessary xxxxListID fields
etc., with the item, quantity, and values coming from other sources.
So "all" I have to do now is to feed t...
EXAMPLES OF CREATING INVOICE USING QODBC
First, please create a new MS Access database & link ALL tables.
Please refer to the below-mentioned article for How to Use QODBC with
Microsoft Access:
How to Use QODBC with Microsoft Access
[http://support.fle...
HOW TO CREATE AN ITEM INVENTORY ASSEMBLY THROUGH MS ACCESS USING QODBC
AN EXAMPLE OF CREATING ONE ITEMINVENTORYASSEMBLY WITH TWO LINES
First, please create a new MS Access database & link
ItemInventoryAssembly, and ItemInventoryAssemblyLine tables.
P...
USING QUICKBOOKS DATA WITH VBA
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACCESS-2003-AND-QODBC].
PROBLEM DESCR...
HOW TO CREATE A LINK SERVER WITH MS SQL 2005/2008/2012 64-BIT USING
QODBC POS/QREMOTE
Start your "SQL Server Management Studio"
Login to your SQL Server.
On the left-hand side panel, you will find the Server, Right Click on
the "SQL Server" and Sele...
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 does support standard SQL queries, but the function is
implemented differently.
Please refer to the below functions & try to execute them in QODBC
TEST TOOL.
FUNCTIONS IN SELECT QUERY:
You can use distinct like:
SELECT DISTINCT CustomerRefFull...
USING QUICKBOOKS POS DATA WITH ACCESS 2013 (LINKED TABLES) 32-BIT
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2472/57/MICROSOFT-ACC...
SETUP QODBC TO WORK WITH MICROSOFT EXCEL POWERPOINT
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-...
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.
...
HOW TO USE THE QODBC EXCEL TEMPLATE
You can download the QODBC Excel Template, which has most of the
tables and reports preconfigured.
All you have to do is download the Excel Template and copy the file to
the Default Template folder.
To download t...
[QODBC-Desktop] How to create Link Server with MS SQL 2005/2008/2012/2016 32-bit Using QODBC/QRemote
HOW TO CREATE LINK SERVER WITH MS SQL 2005/2008/2012/2016 32-BIT USING
QODBC/QREMOTE
For 64-bit Refer: How to create Link Server with MS SQL
2005/2008/2012/2016 64-bit Using QODBC/QRemote
[http://support.flexquarters.com/esupport/index.php?/Default/Knowl...
How to build a QuickBooks IIS Web application using QODBC Driver and
Microsoft ASP.NET (Video)
Download the sample code: Click Here
[http://support.flexquarters.com/supportfiles/QODBC%20onASP.NET.zip]
Also, refer to
Sample C#.NET Web Application for ...
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS
ACCESS 2010 (VIDEO) - 32-BIT
ACCESSING QUICKBOOKS DATA WITH QODBC DRIVER USING MS EXCEL 2010 & MS
ACCESS 2010 (VIDEO) - 64-BIT (MINIMUM REQUIREMENT: QUICKBOOKS 2022
64-BIT AND QODBC 202...
QODBC and Microsoft Excel
MICROSOFT EXCEL 2003 AND QODBC
Also, Refer:
How to Use QODBC with MS Excel 2007
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2449/57/how-to-use-qodbc-with-ms-excel-2007]
Using QuickBo...
QODBC and Microsoft Excel
MICROSOFT ACCESS 2003 AND QODBC
CREATING A TABLE IN MICROSOFT ACCESS
NOTE: Microsoft Access has many uses and will allow you to use your
QuickBooks data files similarly to Access databases.
Selecting the menu FILE -> NEW -...
[QODBC-Desktop] Using QuickBooks Data with Microsoft Access 2016 / 365 / 2013 32-bit (Import tables)
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 /
2019 32-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019
64-BIT TO IMPORT QUICKBOOKS DATA USING IMPORT TABLES (MINIMUM
REQUIREMENT...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019
32-BIT
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 / 365 / 2013 / 2019 64-BIT
(MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)
QuickBooks 2022 and above are 64-Bit applicatio...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 (32-BIT) TO IMPORT
QUICKBOOKS DATA
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2010 TO BUILD LINKED
TABLE(32-BIT)
FOR 64 BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT
MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2010 (32-BIT)
FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS EXCEL
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-CONFIGURE-...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 32-BIT
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 / 365 / 2013 / 2019 64-BIT
(MINIMUM REQUIREMENT: QUICKBOOKS 2022 64-BIT AND QODBC 2023)
QuickBooks 2022 and above are 64-Bit applications...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2007
SETUP QODBC TO WORK WITH MICROSOFT OFFICE 2007
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 ret...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2007
CREATING A TABLE IN MICROSOFT ACCESS
Open MS Access 2007, and create a blank database.
Click on the "Create" button. Then you get a Microsoft Office Access
blank database.
The newly created database shall ...
How to Get QODBC to go with 64-bit Access and Excel
HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS EXCEL
INSTRUCTIONS
64 and 32-bit words are kept separate in the Microsoft Windows
Operating System. QuickBooks 2021 and older versions are 32-bit
appli...
How to Get QODBC to go with 64-bit Access and Excel
HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MICROSOFT ACCESS
INSTRUCTIONS
64 and 32-bit words are kept separate in the Microsoft Windows
Operating System. . QuickBooks 2021 and older versions are 32-b...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL 2007
INSTRUCTIONS
To extract sp_reports from QuickBooks into Microsoft Excel
Spreadsheet, you should use MICROSOFT QUERY.
HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL 2007
OPEN MICROSOFT QUERY IN EXC...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH
SSIS
PROBLEM DESCRIPTION
We are using the QODBC driver for connecting QuickBooks with SSIS. I
can able to connect with QuickBooks through SSIS. But Quick books Ex:
LIST ID) nvarchar da...
HOW TO USE ADO AND VISUAL BASIC WITH QODBC
SETUP QODBC TO WORK WITH ADO
NOTE: QODBC can be accessed from ADO. ADO can be used in Visual Basic
(VB), Access, VBScript, ASP, C++, VB.NET, C#, and other languages that
support COM components.
CONNECTION S...
QODBC AND MICROSOFT ACCESS
FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS ACCESS
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2435/57/HOW-TO-CONFIGURE-QODBC-TO-WORK-WITH-64-...
QODBC and Microsoft Excel
MICROSOFT EXCEL 2010 AND QODBC
FOR MS ACCESS 64-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK
WITH 64-BIT MS EXCEL
[HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2441/57/HOW-TO-C...
Microsoft Office with MS Query and QODBC
MICROSOFT OFFICE WITH MS QUERY AND QODBC
SETUP QODBC TO WORK WITH MICROSOFT OFFICE
Before using any Microsoft Office applications, you must ensure that
the Microsoft Query builder is installed.
Click START ...
QODBC and Microsoft Word
MICROSOFT WORD 2003 AND QODBC
CREATING A WORD MAIL MERGE TO LIVE QUICKBOOKS DATA
NOTE: QODBC allows you to easily merge QuickBooks data onto your Word
documents as tables or mail-merged fields.
Open the document you wish to...
QODBC AND SHAREPOINT
ENVIRONMENT DESCRIPTION
QuickBooks Enterprise 2017
Microsoft SharePoint 2006 / SharePoint 2016 / SharePoint Foundation /
SharePoint Office 365
INSTRUCTIONS
The use of SharePoint Services requires the full QODBC Server
Editio...
HOW TO USE PROMPTED DATE RANGES IN MS ACCESS
CREATE LINK TABLE
Let's start from the beginning. Open MS Access -> Create a blank
database -> Using the FILE menu pulldown -> GET EXTERNAL DATA ->
select LINK TABLES...
Select Files of type: ODBC DATAB...
HOW TO USE PROMPTED DATE RANGES IN MS ACCESS 2007 USING VISTA
CREATE A LINK TO TABLE
Let's start from the beginning. Open Microsoft Access 2007 -> Create
a Blank Database:
Using the EXTERNAL DATA tab -> use the More icon and select: ODBC
DATABASE
...
SAMPLE CODE FOR VB.NET WITH QODBC
SAMPLE CODE OF VB.NET TO CREATE DATASET
NOTE: The following is the minimal code required to create a DataSet
from the SQL statement and attach the dataset to a DataGrid.
Dim cnQODBC As System.Data.Odbc.OdbcConnection...
EXAMPLES OF HOW TO USE QODBC VIA VISUAL BASIC
DOWNLOAD LINK
QUERY AND UPDATE VBS
Click here: http://www.qodbc.com/docs/support/vbexamples.zip
[http://www.qodbc.com/docs/support/vbexamples.zip] to download some
VBS files that show several examples of q...
HOW TO USE PROMPTED DATE RANGES IN MS EXCEL
NEW DATABASE QUERY
Let's start from the beginning. Open MS Excel -> Using the DATA menu
pulldown -> IMPORT EXTERNAL DATA -> select NEW DATABASE QUERY...
LOCATE TABLE AND FIELD RECORD
Select Databases ...
EXAMPLE CODE OF UPDATE QUICKBOOKS FROM MS ACCESS
REQUIREMENTS OF UPDATE QB FROM MS ACCESS
Now take below as an example:
All I am trying to do is update the account number in QB from a table
I built in Access. In Access, I linked the QB Account table...
Help Desk Software by Kayako