[QODBC DESKTOP] - TROUBLESHOOTING - THE CERTIFICATE WAS REVOKED BY ITS
CERTIFICATION AUTHORITY. REVOKED SECURITY CERTIFICATE.
PROBLEM DESCRIPTION:
We get an error message in QuickBooks saying that the application
FLEXquarters QODBC's certificate was rev...
SOLVED:[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 'fqqb...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - THE DRIVER DID NOT
SUPPLY AN ERROR - PYTHON
PROBLEM DESCRIPTION
I tried to connect to QODBC using python, gave me the following error.
The python code I am using is this.
import pyodbc
cn = pyodbc...
[QXL DESKTOP] HOW TO EXPORT QUICKBOOKS DATA TO GOOGLE SHEETS USING QXL
PROBLEM DESCRIPTION:
How to export QuickBooks Data to Google Sheets using QXL
SOLUTIONS:
Install the Google Drive desktop application and authorize it to
connect to your Google D...
[QODBC ONLINE] - UNABLE TO USE QODBC ONLINE ON WINDOWS 7
PROBLEM DESCRIPTION:
Unable to use QODBC Online on Windows 7
Error - session Failed. 653 - There was an error while communicating
with the Ids Server. - - The Response Stream was null or empty
...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438
PROBLEM DESCRIPTION:
I am testing the connection of QODBC & I am getting the QODBC test
connection failed error:
Can you advise what is error and the solution for it?
SOLUTION:
The above ...
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...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. UNABLE TO LOAD COMPONENT
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks Online using QODBC Online. But I
am getting the below error at the time of connection.
Please help me to resolve this error...
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 ...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL
PACKAGE
PROBLEM DESCRIPTION:
I am getting Error SOCKET Closed because of an abnormal package in the
QRemote client. I am accessing QuickBooks Data from the remote machine
over the inter...
TROUBLESHOOTING - QODBC RECORD SET ISSUE
PROBLEM DESCRIPTION:
I am using the below code. It is returning records & giving me the
correct result. But If I change the query from "SELECT Name FROM
customer" to "SELECT * FROM customer," it does not return...
TROUBLESHOOTING - HOW TO CLOSE SQL LINKED SERVER CONNECTION
PROBLEM DESCRIPTION:
We are using QRemote with SQL Linked Servers with several different
QuickBooks files. How can we close the connection to a QuickBooks file
after the query has run, then o...
TROUBLESHOOTING - CODE DIFFERENCES BETWEEN QODBC DESKTOP AND QODBC
ONLINE
PROBLEM DESCRIPTION:
I have an MS Access application using QODBC to connect to desktop
QuickBooks. Can I use the QODBC Online driver to connect to QuickBooks
Online without chan...
TROUBLESHOOTING - CONNECTION SERIAL, LIMITATION, QUEUE, AND UPPER
LIMIT
PROBLEM DESCRIPTION:
How many concurrent connections does the Server edition support?
Is the product QB version specific, requiring additional purchases
with each version? AKA. ...
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...
TROUBLESHOOTING - QXL 80040414 MODAL POPUP ERROR
PROBLEM DESCRIPTION:
I am trying to export data from QXL. But when I clicked on the QXL
export button, I got the below error message.
Unable to connect to QuickBooks. Popup window(s) in the QuickBooks...
TROUBLESHOOTING - CHANGES TO THE INTEGRATED APPLICATION
AUTHENTICATION FOR QUICKBOOKS
Intuit is reinforcing existing security features that help protect
QuickBooks customers' sensitive information.
Refer: Intuit's News: Changes to the Integrated Applic...
TROUBLESHOOTING - QXL IS NOT LICENSED FOR THIS QUICKBOOKS EDITION.
PROBLEM DESCRIPTION:
I was able to use QXL earlier. Our co recently upgraded to QB Pro 2016
and can now not connect with QXL as it says QXL is not licensed for
this QuickBooks edition. ...
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 ...
[QODBC-ONLINE] TROUBLESHOOTING - QUICKBOOKS MESSAGE 653-UNAUTHORIZED -
401 - FAULT EXCEPTION OF TYPE: AUTHENTICATION HAS BEEN GENERATED. QB
BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401
PROBLEM DESCRIPTION:
I was able to use QODBC Online. Suddenly, I g...
SAMPLE CODE FOR C++ WITH QODBC
#include
#include
#include
#include
#include
#include
#include
#include
using namespace std;
void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - DSN CONNECTION NOT CONSISTENT ACROSS MULTIPLE
COMPUTERS
PROBLEM DESCRIPTION:
I have a pass-through query for access:
Select * from Item
The connection string is as follows:
ODBC;DRIVER={QODBC Driver for
QuickBooks};SERVER=QODBC;DF...
TROUBLESHOOTING - QODBC LOGGING IN WITH THE WRONG USER ACCOUNT
PROBLEM DESCRIPTION:
I am using ms access. I have the integrated application certificate
set up correctly (see screenshot). The username for this certificate
is "odbc."
QuickBooks is clos...
TROUBLESHOOTING - HOW DO I SEE BACKORDER ITEMS THAT HAVE BEEN
INVOICED BUT NOT SHIPPED
PROBLEM DESCRIPTION:
Could someone kindly provide me with a sample, or is there a stored
procedure that would allow me to only pull out back ordered invoices
from t...
TROUBLESHOOTING - QUICKBOOKS DISPLAYS A REVOKED CERTIFICATE WARNING
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks using QODBC. At a time of
connection, QuickBooks Displays a Revoked Certificate Warning.
SOLUTION:
Please update your QODBC...
HOW TO SHARE/INVITE THE FLEXQUARTERS SUPPORT TEAM TO THE QUICKBOOKS
ONLINE COMPANY FILE
PROBLEM DESCRIPTION:
How do I share/invite the FLEXquarters Support team to access my QBO
company file?
SOLUTION:
Please follow the below steps to share/invite ...
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 - QREMOTESERVER HANG-ON CONNECTION
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks/QuickBooks POS using QRemote
Server, But QRemoteServer is Having on Connection.
SOLUTION:
Please check if QuickBooks Or QuickBooks POS has ...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATIONS
UNDER QUICKBOOKS POS
Please follow the steps to remove QODBC Related Certificates from the
Integrated Application Under QuickBooks POS:
Try removing all the integrated application en...
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 CREATE OR CONFIGURE A QODBC ONLINE DSN
PROBLEM DESCRIPTION:
I have one QuickBooks Online login, which provides access to multiple
QuickBooks Online companies.
When I initially configured the connection, I selected one of the
clients to that I ...
TROUBLESHOOTING - HOW TO STOP ANY QUERY ON VB DEMO APPLICATION
PROBLEM DESCRIPTION:
How to Stop any query on VBDEMO when it takes time.
How to convert the date to QuickBooks date.
I want to insert TxnDate in the ReceivePayment table, but it pops u...
HOW TO CONNECT TO QODBC USING PYTHON
Download Sample
[http://support.flexquarters.com/esupport/newimages/python/DisplaySQL.zip]
SAMPLE CODE FOR USING QODBC DSN:
import pyodbc
cn = pyodbc.connect('DSN=QuickBooks Data;')
cursor = cn.cursor()
cursor....
TROUBLESHOOTING - I CANNOT CONNECT TO MY QUICKBOOKS ONLINE SANDBOX
PROBLEM DESCRIPTION:
I am trying to do some testing and now have access to a QBO Sandbox
company. I have tried to connect to it in two different ways.
1. If I "Connect to QuickBooks" ...
HOW TO CONNECT TO QUICKBOOKS ONLINE SANDBOX COMPANY FILE.
For installation & configuring QODBC Online to work with QuickBooks
Online live company file. Please refer:
How to use QODBC Online with QuickBooks Online Edition (Apps.com)
[http://support.flex...
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...
TROUBLESHOOTING - QODBC/QREMOTE TRIES TO CONNECT FOR 2 MINUTES OVER
AND OVER
PROBLEM DESCRIPTION:
I am using QRemote DSN to connect to QuickBooks. QODBC/QRemote tries
to connect for 2 minutes over and over and says it has a connection
but does nothing...
TROUBLESHOOTING - HOW CAN I GET SINGLE-USER ACCESS USING THE QODBC
CONNECTION STRING
PROBLEM DESCRIPTION:
I am in access and need to update the Inventory. I have made a table
that contains the adjustments. (Thousands of them) Your notes about
Inventor...
TROUBLESHOOTING - UNABLE TO IMPORT QUICKBOOKS ONLINE CONNECTION KEY
USING QODBC ONLINE PREVIOUS VERSION
PROBLEM DESCRIPTION:
I am importing the QBO connection key using QODBC Online's latest
version & I am getting the below error:
THE FILE CAN NOT CON...
PROBLEM DESCRIPTION:
We keep getting the "QB Begin Session Failed" error when opening a
QODBC connection on a web page.
--> It happens when several users are using QuickBooks at the same
time.
--> When it happens, We try to use the 'QODBC Test Tool,' and...
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks through SSIS using QODBC, but I
cannot link to QuickBooks.
I have a Read Only Desktop edition of QODBC, which is included with
QuickBooks Enterprise Edition.
I am getting the error:
"Error =...
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/]
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection was crashing Wh...
PROBLEM DESCRIPTION:
I am trying to use QODBC with Crystal Reports 11, but I'm also having
similar results with the QODBC TEST TOOL included with the driver.
Many queries, such as "select * from invoice," cause the program to
hang. With Crystal Reports,...
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection was crashing When I tried to
connect to QuickBooks using QODBC.
I have tried reinstalling QODBC & QuickBooks, but the QODBC Test
connection (also via QODBC Test Tool) is still crashing. Also, I...
TROUBLESHOOTING - VISUAL STUDIO CONNECTION TO QODBC
PROBLEM DESCRIPTION:
I am getting the following message from Visual Studio 2015 when
trying to connect to QRemote using the ODBC data source:
"An error occurred while retrieving the information fro...
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...
TROUBLESHOOTING - QREMOTE DOES NOT WORK WITH IIS
PROBLEM DESCRIPTION:
We've been having steady success with QODBC for a good while. We're
running QB on a VM and our custom application that queries it on
another VM; both VMs are Server 2012.
All was wel...
TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO
NOTE: THE JDBC-ODBC BRIDGE DRIVER WAS REMOVED IN JAVA 8, PREVENTING
ODBC DRIVERS FROM BEING USABLE IN NEWER VERSIONS OF JAVA OR OTHER
JAVA-BASED APPLICATIONS.
Refer: Oracle JDBC-ODBC Bridge
[http...
TROUBLESHOOTING - QODBC AUTO-CONNECTING WITH THE WRONG USER
PROBLEM DESCRIPTION:
We have a few stations where we utilize the read-only QODBC desktop
version. On a station we just built, it keeps using the wrong
QuickBooks user for the auto-login. I conf...
TROUBLESHOOTING - HOW TO GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME
TIME
PROBLEM DESCRIPTION:
We use a Visual Basic app with an SQL Server database to write data
to QB through QODBC. We are executing two SQL statements as described
in your help. We ...
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 - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES
PROBLEM DESCRIPTION:
I want to upgrade my Operating System to Windows 10 and know if any
precautions/actions are required for QODBC to keep working.
SOLUTIONS:
STEPS BEFORE UPGRADING T...
GENERAL CONNECTION STRING
INSTRUCTIONS
The most difficult part of using QRemote in programming is the
connection string. The simplest form includes a reference to a DSN. A
system DSN called "QuickBooks Data QRemote" for 32-bit applications &
"QuickBook...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY
FILE
PROBLEM DESCRIPTION:
I have a question about setting ODBC to auto-login. I am trying to
automate some tasks and wanted to auto-login. We have two different
company files for accoun...
TROUBLESHOOTING - HOW TO RE-LINK QUICKBOOKS DATA IN MS ACCESS USING
QODBC
PROBLEM DESCRIPTION 1:
We are adding invoice records to QuickBooks using an Access front end.
When we create the records and try to insert them into QuickBooks, the
line items see...
TROUBLESHOOTING - HOW TO RECORD THE ISSUE I AM FACING AND SHOW/SHARE
THE SCREEN.
PROBLEM DESCRIPTION:
How to record the issue I am facing and show/share the screen.
SOLUTIONS:
Please follow below steps for recording the issue you are facing.
1) Dow...
TROUBLESHOOTING - HOW TO IDENTIFY IF THE APPLICATION IS 32-BIT OR
64-BIT
PROBLEM DESCRIPTION:
How can I Identify if the application is 32-bit or 64-bit?
SOLUTIONS:
SQL SERVER
If your application is SQL Server, you can identify it by Starting
your "...
TROUBLESHOOTING - HOW TO GIVE REFUND TO EXISTING CREDITMEMO USING
QODBC
PROBLEM DESCRIPTION:
How can I apply a refund check to an existing credit memo using QODBC?
In QuickBooks, I can refund by opening the Create Credit Memos/Refunds
dialogue box usin...
CONFIGURE QODBC ONLINE FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0
(QREMOTE)
To use QODBC Online with Jitterbit community edition 3.0.0, you
should follow the steps below to configure your QODBC Online driver
and Jitterbit connection. These steps wor...
CONFIGURE QODBC POS FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0
(QREMOTE)
To use QODBC POS with Jitterbit community edition 3.0.0, you should
follow the steps below to configure your QODBC POS driver and
Jitterbit connection. These steps work for QOD...
CONFIGURE QODBC FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0
(QREMOTE)
To use QODBC with Jitterbit community edition 3.0.0, you should
follow the steps below to configure your QODBC driver and Jitterbit
connection. These steps work for QODBC with Jitt...
SETUP IN ALPHA FIVE
CREATE A NEW WORKSPACE
Start Alpha Five and create a new workspace. It could be called
Online. adb - a holder for the entire application.
Click the WORKSPACE & TASKS tab -> Click -> choose to CREATE A NEW,
EMPTY WORKSPACE -> cl...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
excited about the prospects. I've installed it and can get the fields
and tables to appear in QODBC TEST TOO...
HOW TO USE QODBC ONLINE WITH QLIKVIEW
To use QlikView with QODBC Online, please follow the below steps.
1. Open QlikView & Create the new file.
2. Select Data Source. Click on Browse.
3. Please select the MS Excel file & click "Next."
4. Click "N...
QODBC ONLINE IS NO LONGER CONNECTED TO QUICKBOOKS ONLINE. YOUR USER
TOKEN IS NO LONGER VALID.
HOW TO CONNECT/RECONNECT QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION
(APPS.COM)
Please follow the below-mentioned steps to configure QODBC Online:
1) Open QO...
TROUBLESHOOTING - APPLICATION CONNECTIVITY DELAY
PROBLEM DESCRIPTION:
I have an inventory control system (c#, SQL Server) that needs Read
Only access to four tables in the accounting system. I have deployed
your multiuser version and can access the loca...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040410
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks through QODBC using the QODBC
TEST TOOL application.
I am consistently getting an "80040410" error.
Begin Session Failed. S0000 00000...
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 - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC
PROBLEM DESCRIPTION:
How to get Bank Reconciliation details using QODBC
I've not successfully identified any field/flag identifying the bank
reconciliation status. Is this informatio...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO
SERVER/QREMOTESERVER."
PROBLEM DESCRIPTION 1:
I have tested using QODBC Test Tool and the QRemote DSN test
connection. I cannot connect to QRemote DSN. I am getting the below
error:
PROBLEM DESCRIPT...
TROUBLESHOOTING: QODBC SHOWS ERRORS 11118,11119,11120,11121,11122
PROBLEM:
I am getting an error "11118 - SYSTEM LICENSE ERROR."
I am getting an error "11119 - REGFILE1 LICENSE OPEN ERROR"
I am getting an error "11120 - REGFILE1 LICENSE ERROR"
I...
DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE.
TABLE DIFFERENCES:
Number of Tables available in
QODBC DESKTOP
QODBC ONLINE
150
83
List of Tables available in QODBC Desktop
[http://doc.qodbc.com/qodbc/usa/TableList.php?catego...
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 DO I CHECK WHICH REGION OF QUICKBOOKS IS
INSTALLED
PROBLEM DESCRIPTION:
How do I check which region of QuickBooks is installed?
SOLUTION:
You can query the Host table using QODBC Test Tool & get detail about
your QuickBooks ver...
HOW TO USE QODBC WITH QUICKBOOKS ONLINE EDITION
SETUP OF QODBC ONLINE:
First, we need to install QODBC Online. QODBC Online requires .NET
Framework 4.0 or a later version. So, you need to install .NET
Framework 4.0 to work with QODBC Online.
Please re...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE
PROBLEM DESCRIPTION:
How do I run QODBC as windows services in the background? I noticed
it required QuickBooks and windows server 2008 to be logged on.
SOLUTIONS:
QODBC and QuickBooks are deskt...
TROUBLESHOOTING - CAN QODBC ONLINE HAVE REGION-WISE FIELDS?
PROBLEM DESCRIPTION:
Can QODBC Online have region-wise fields like QODBC Desktop driver?
SOLUTIONS:
QuickBooks Online API supports only one region; thus, we had only one
part in QODBC Onli...
HOW TO USE QODBC WITH PHP
INSTRUCTIONS FOR USING QODBC WITH PHP:
Using PHP on an internal Intranet or the World Wide Web requires the
Server Edition of QODBC. QuickBooks must be running with the company
file open.
Download Sample
[http://support.flex...
QODBC ONLINE VERSION 14 IS DISCONTINUED
INSTRUCTIONS
We continue improving the user experience for QODBC for QuickBooks
Online and are now at version 15, so support for QODBC Online version
14 has been discontinued. You will not be able to create new
c...
TROUBLESHOOTING - HOW TO USE QODBC FOR DEVELOPMENT WITH VISUAL STUDIO
PROBLEM DESCRIPTION:
I am trying to use a demo file for development, but QODBC is not
allowing me to do this now that the evaluation period on my
development machine has expired. Are ...
TROUBLESHOOTING - HOW TO ACCESS QUICKBOOKS DATA USING FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
excited about the prospects. I've installed it and can get the fields
and tables to appear in QODBC T...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING.
PROBLEM DESCRIPTION:
When I run a report query, the query works very slowly & takes about
1-5 mins per simple report like:
"sp_report ARAgingSummary show Current parameters
DateFrom={d'2014-11-...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417
PROBLEM DESCRIPTION:
When using your QODBC Driver with my custom application, coded in
Java, the application can connect and retrieve data if QuickBooks is
running with the company file already...
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...
TROUBLESHOOTING - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST
PROBLEM DESCRIPTION:
I have QuickBooks 2014 version & I am using QODBC's latest version. I
have a problem with querying the customer table using QODBC.
QODBC driver consistently gets s...
TROUBLESHOOTING: ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT
AVAILABLE IN THIS VERSION OF QUICKBOOKS.
PROBLEM DESCRIPTION:
I am getting the error "Error 3250 - This feature is not enabled or
not available in this version of QuickBooks." while I am ...
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 REMOVE QREMOTE FROM STARTUP
PROBLEM DESCRIPTION:
QRemote Initialization Error.
QRemote Error: Listening failed. Please restart application
QRemote Closing in 15 Seconds.
SOLUTION:
QRemote Server reports "Error: Listening failed. Please re...
PROBLEM DESCRIPTION:
When inserting an invoice via a looping SQL procedure, I have invoice
lines (InvoiceLine table) items that can potentially be assigned to
varying classes. Using the ClassRefListID field, I class the lines
accordingly and do not addre...
TROUBLESHOOTING: QUICKBOOKS CAN'T START BECAUSE IT IS ALREADY RUNNING.
PROBLEM DESCRIPTION 1:
I cannot Connect my trial version of QODBC to QuickBooks. I have gone
through your tutorials but am unable to connect. I have never had the
"Keep QuickBooks ...
TROUBLESHOOTING: SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS
RETURNING NO ROWS.
PROBLEM DESCRIPTION 1:
I am running ProfitAndLossBudgetPerformance through MS Query & It is
returning no rows. But using QuickBooks UI, I can get records from the
ProfitAnd...
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...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC
PROBLEM DESCRIPTION:
Any errors related to the driver and custom software or packaged
software that does not work properly with QODBC.Example, Prepared
Statements in JDBCODBCDriver.
Sample
Connection qbCo...
HOW CAN I USE QODBC WITH TWO DIFFERENT VERSIONS OF QUICKBOOKS
INSTALLED?
PROBLEM DESCRIPTION:
I have two different versions of QuickBooks (i.e., QuickBooks
Enterprise 2012 & QuickBooks Enterprise 2014) installed on my machine.
I want to access both ...
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 TO USE QODBC WITH MULTIPLE COMPANY FILES
INTRODUCTION:
When multiple QuickBooks company files are located on one machine, how
do we use only one copy of QODBC to access those company files? Please
note that QODBC can only access one company file on ...
PROBLEM DESCRIPTION:
How can I use multiple QuickBooks
SOLUTION:
You can use multiple QuickBooks of the same region and the same
version year on the same machine. But for the best configuration of
QuickBooks, please get in touch with Intuit to take he...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE.
THE TEST CONNECTION WAS NOT WORKING.
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 than other versions of Windows because of its new strict
security setting...
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...
TROUBLESHOOTING - LISTENING FAILED. QREMOTE SERVER IS SHUTTING DOWN
IN 15 SEC
PROBLEM DESCRIPTION 1:
When I start QRemote Server, I get QRemoteServer Started, and it shows
"Listening failed.QRemote Server is shutting down in 15 sec."
PROBLEM DESCRIPT...
How to Run VB Script on 64-bit Operating System
INSTRUCTION:
When running the VB Script on the 64-bit system, if you directly run
the Script by double-clicking the vbs file, the system will run the VB
Script as 64-bit. Then QODBC will report an error l...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC
Also, refer to Accessing QuickBooks Data Remotely using QODBC &
QRemote. (Video)
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/]
QODBC has the abi...
[QODBC-Desktop] How to create Link Server with MS SQL 2005/2008/2012/2016 64-bit Using QODBC/QRemote
HOW TO CREATE LINK SERVER WITH MS SQL 2005/2008/2012/2016 64-BIT USING
QODBC/QREMOTE
For 32-bit Refer: How to create Link Server with MS SQL
2005/2008/2012/2016 32-bit Using QODBC/QRemote
[http://support.flexquarters.com/esupport/index.php?/Default/Know...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS
VISTA/ WINDOWS 7 OPERATING SYSTEM
INSTALL QODBC POS
Please download QODBC Installer from this site:
http://www.qodbc.com/posDownload.htm
[http://www.qodbc.com/posDownload.htm]
Then...
Please Also Refer: Connecting QODBC Driver to QuickBooks for the First
Time (Video)
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512]
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 t...
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/].
OPEN A COMPANY FILE IN QUICKBOOKS.
First, start QuickBooks and open a co...
How QODBC and QuickBooks SDK work
Intuit QuickBooks SDK inside the QuickBooks application uses XML
format to read and write QuickBooks data.
QODBC uses the QuickBooks SDK to talk to QuickBooks data. QODBC acts
as a 'wrapper' around the Intuit SDK so cu...
NOTE: Ibiz no longer offered an SSL socket (for web apps), so we went
with Intuit's RDS component, but you can still use the ibiz connector
if you do the followings.
CONFIGURATION OF CLIENT MACHINE
MAKE MODIFICATIONS TO FILE ODBCINST.INI
The client m...
GENERAL CONNECTION STRING
INSTRUCTIONS
The most challenging part of using QODBC in programming is the
connection string. The simplest form includes a reference to a DSN. A
system DSN called "QuickBooks Data" is automatically created when
QODBC is insta...
HOW TO CONNECT QODBC TO QUICKBOOKS FOR THE FIRST TIME
START QUICKBOOKS BEFORE USING QODBC
Once the FLEXquarters QODBC Driver for QuickBooks has been
successfully installed on your computer, you can begin to use it
immediately using the FREE "once-off"...
HOW TO: CONNECT TO A QODBC DATABASE USING ASP.NET
You can use the SqlDataSource control to connect to any database that
supports Open Database Connectivity (ODBC) by storing connection
string information in the Web application's Web. Config the file a...
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/]
NOTE: AS AN ALTERNATIVE TO REMOTE DATA SHARING (RDS), WE SUGGEST YOU
USE QR...
HOW TO SETUP QODBC REMOTE USING REMOTE CONNECTOR
NOTE: VB DEMO IS DEPRECATED.
Please refer to How to use the QODBC Test Tool for testing
[https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/]
It is recommended to use...
Help Desk Software by Kayako