Knowledgebase : Tutorials > Connection
HOW TO SETUP QODBC REMOTE USING REMOTE CONNECTOR
It is recommended to use QRemote For QODBC v12 & Above:
Please refer: Accessing QuickBooks Data Remotely using QODBC &
QRemote. (Video)
[http://support.flexquarters.com/esupport/index.php?/Default/Knowl...
NOTE: AS AN ALTERNATIVE TO REMOTE DATA SHARING (RDS) WE SUGGEST YOU TO
USE QREMOTE.
Using QuickBooks data remotely via QODBC
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2483/0/using-quickbooks-data-remotely-vi...
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 file and th...
HOW TO DO THE CONNECTION
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" 30 Day QODBC Server Edition
...
GENERAL CONNECTION STRING
INSTRUCTIONS
The most difficult 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 install...
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 MODIFICATION TO FILE ODBCINST.INI
On the client ...
How QODBC and QuickBooks SDK works
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 c...
OPEN A COMPANY FILE IN QUICKBOOKS
First, start QuickBooks and open a company file, your own or a sample
company file, log into QuickBooks Company File as Admin.
USING VB DEMO FOR TESTING
RUNNING VB DEMO
Leaving your QuickBooks company file open -...
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...
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...
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...
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...
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 error like...
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 DESCRIPTIO...
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...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE,
TEST CONNECTION NOT WORKING
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 than other versions of Windows because of its new strict
security settings.
If T...
PROBLEM DESCRIPTION:
How can I use multiple QuickBooks
SOLUTION:
You can use multiple QuickBooks of the same region and same version
year on the same machine. But for the best configuration of
QuickBooks, Please contact Intuit to take help.
Please n...
HOW TO USE QODBC WITH MULTIPLE COMPANY FILES
INTRODUCTION:
When there are multiple QuickBooks company files located on one
machine, then how do we use only one copy of QODBC to access those
company files? Please note that in one machine, QODBC can only ...
HOW TO CREATE 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 Select...
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 v...
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 TO USE MS ACCESS AS MIDDLEWARE WITH QODBC
PROBLEM DESCRIPTION:
When using Prepared Statements with QRemote driver, then it throws an
error called ODBC driver not supported. How can I use Prepared
Statements with QODBC/QRemote?
SOLUTIONS:
You ma...
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 am able to get records
from ProfitA...
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...
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 addr...
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...
QODBC SHOWS 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 AS SOON AS TRYING TO
...
TROUBLESHOOTING: ERROR 3250 - THIS FEATURE IS NOT ENABLED OR NOT
AVAILABLE IN THIS VERSION OF QUICKBOOKS.
PROBLEM DESCRIPTION:
I am getting error "Error 3250 - This feature is not enabled or not
available in this version of QuickBooks." while I am tryi...
TROUBLESHOOTING - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST
PROBLEM DESCRIPTION:
I have QuickBooks 2014 version & I am using QODBC latest version. I
have a problem with querying customer table using QODBC.
QODBC driver consistently gets stuck o...
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 - QB BEGIN SESSION FAILED. ERROR = 80040417
PROBLEM DESCRIPTION:
When using your QODBC Driver with my custom application, coded in
Java, the application is able to connect and retrieve data if
QuickBooks is running with the company file ...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING.
PROBLEM DESCRIPTION:
When I run report query, query works very slow & take about 1-5 mins
per simple report like:
"sp_report ARAgingSummary show Current parameters
DateFrom={d'2014-11-12'}, Dat...
TROUBLESHOOTING - HOW TO ACCESS QUICKBOOKS DATA USING FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
really excited about the prospects. I've installed it and am able to
get the fields and tables to app...
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 ...
QODBC ONLINE VERSION 14 IS DISCONTINUED
INSTRUCTIONS
We continue to improve the user experience for QODBC for QuickBooks
Online and we are now at version 15, so support for QODBC Online
version 14 has been discontinued. You will not be able to create n...
HOW TO USE QODBC WITH PHP
INSTRUCTIONS FOR USING QODBC WITH PHP:
Using PHP, whether it's an internal Intranet or on the World Wide
Web, requires the Server Edition of QODBC. QuickBooks must be running
with the company file open.
Download Sample
[http...
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 is supporting only 1 region and thus we had
only 1 region in QODBC...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE
PROBLEM DESCRIPTION:
How do I run QODBC as windows services in the background? I notice it
required QuickBooks to be logged and windows server 2008 to be logged
on.
SOLUTIONS:
QODBC and QuickBoo...
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 ref...
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 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...
PROBLEM DESCRIPTION:
How to use parameter 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 = '19...
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...
TROUBLESHOOTING: QODBC SHOWS ERROR 11118,11119,11120,11121,11122
PROBLEM:
I am getting error "11118 - SYSTEM LICENSE ERROR"
I am getting error "11119 - REGFILE1 LICENSE OPEN ERROR"
I am getting error "11120 - REGFILE1 LICENSE ERROR"
I am getting...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO
SERVER/QREMOTESERVER"
PROBLEM DESCRIPTION 1:
I cannot connect to QRemote DSN. I have tested using QODBC Test Tool
as well as using the QRemote DSN test connection. I am getting the
below error:
PRO...
TROUBLESHOOTING - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC
PROBLEM DESCRIPTION:
How to get Bank Reconciliation details using QODBC
I've not had success identifying any field/flag that identifies the
Bank Reconciled status. Is this informatio...
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 - 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...
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 get to the loca...
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...
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 MS Excel file & click "Next".
4. Click "Next"...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER
PROBLEM DESCRIPTION:
I downloaded the trial version of your driver this morning and am
really excited about the prospects. I've installed it and am able to
get the fields and tables to appear in ...
SETUP IN ALPHA FIVE
CREATE A NEW WORKSPACE
Start Alpha Five and create a new workspace, it could be called
Online.adb - it is a holder for the entire application.
Click the WORKSPACE & TASKS tab -> Click -> choose CREATE A NEW,
EMPTY WORKSPACE -> ...
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 Jitte...
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 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...
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...
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, then you can identify it by
Starting y...
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 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 into QB the line items
seem to go but wh...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY
FILE
PROBLEM DESCRIPTION:
I have a question about setting ODBC to auto login. We have two
different company files for accounting purpose. I am trying to
automate some of the tasks and I...
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 application &
"QuickBooks...
TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES
PROBLEM DESCRIPTION:
I want to upgrade my Operating System to Windows 10 and want to know
if there are any precautions/actions required for QODBC to keep
working.
SOLUTIONS:
STEPS BEFO...
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 - HOW TO GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME
TIME
PROBLEM DESCRIPTION:
We are using a Visual Basic app which works with an SQL Server
database to write data to QB through QODBC. We are executing two SQL
statements as described...
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 that we just built, it keeps to using the wrong
QuickBooks user for the auto-login...
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 - 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...
REFRESH ON MS EXCEL FAILS
PROBLEM:
MS Excel shows data protection error when we click on "Refresh All"
link.
When you click on "OK" you will see below error.
SOLUTION:
You are receiving this error because your Excel sheet is in PROTECTED
MODE.
Wh...
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...
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection is crashing When I tried to
connect to QuickBooks using QODBC.
I have tried to reinstall QODBC & QuickBooks, but the QODBC Test
connection (also via QODBC Test Tool) is still crashing. Also, I ...
PROBLEM DESCRIPTION:
I am are 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 Repor...
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection is crashing When I tried to
connect to QuickBooks using QODBC.
I have tried to reinstall QODBC & QuickBooks, but the QODBC Test
connection (also via QODBC Test Tool) is still crashing. Also, I ...
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:
...
PROBLEM DESCRIPTION:
We keep getting "QB Begin Session Failed" error when trying to open a
QODBC connection on a web page.
--> It happens when there are several users using QuickBooks at the
same time.
--> When it happens, We tried to use the 'QODBC Test...
TROUBLESHOOTING - UNABLE TO IMPORT QUICKBOOKS ONLINE CONNECTION KEY
USING QODBC ONLINE PREVIOUS VERSION
PROBLEM DESCRIPTION:
I am importing QBO connection key using QODBC Online latest version &
I am getting below error:
FILE CAN NOT CONTAIN PROPER K...
TROUBLESHOOTING - HOW CAN I GET SINGLE USER ACCESS USING 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) In your notes about
InventoryA...
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, says it has a connection but
does nothing. I...
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...
TROUBLESHOOTING - THIS RECORD HAS BEEN CHANGED BY ANOTHER USER SINCE
YOU STARTED EDITING IT.
PROBLEM DESCRIPTION:
I am using the QuickBooks Pro 2015 trial version and a purchased QODBC
latest version.
I have an Access database with linked QB tables. ...
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 - 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 two different ways.
1. If I "Connect to QuickBooks" on th...
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 - 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 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 that I hav...
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 REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATION
UNDER QUICKBOOKS POS
Please follow the steps to remove QODBC Related Certificates from
Integrated Application Under QuickBooks POS:
Try removing all the integrated application entries...
TROUBLESHOOTING - QREMOTESERVER HANG ON CONNECTION
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks/QuickBooks POS using QRemote
Server, But QRemoteServer is Hang on Connection.
SOLUTION:
Please check if QuickBooks Or QuickBooks POS is hav...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT
FOR 32-BIT, PLEASE REFER: 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 MICROSOF...
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 SHARE/INVITE FLEXQUARTERS SUPPORT TEAM TO QUICKBOOKS ONLINE
COMPANY FILE
PROBLEM DESCRIPTION:
How do I share/invite FLEXquarters Support team to access my QBO
company file?
SOLUTION:
Please follow below steps to share/invite FLEXquarters Sup...
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...
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 - QODBC LOGGING IN WITH 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 closed.
...
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...
SAMPLE CODE FOR C++ WITH QODBC
#include
#include
#include
#include
#include
#include
#include
#include
using namespace std;
void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401
PROBLEM DESCRIPTION:
I was able to use QODBC Online. Suddenly, I am getting below error
when I tried to connect QBO using QODBC Online. It was working
properly. No known changes to Wi...
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...
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 now unable to connect with QXL as it says QXL is not licensed for
this QuickBooks edition...
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 80040414 MODAL POPUP ERROR
PROBLEM DESCRIPTION:
I am trying export data from QXL. But when I click on QXL export
button I got below error message.
Unable to connect to QuickBooks. Popup window(s) in the QuickBooks
application M...
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 ...
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 purchase with
each version. AKA. Up...
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 - 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 - QODBC RECORD SET ISSUE
PROBLEM DESCRIPTION:
I am using below code it is returning records & giving me the correct
result. But If I change query from "SELECT Name FROM customer" to
"SELECT * FROM customer" it does not return any recor...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL
PACKAGE
PROBLEM DESCRIPTION:
I am getting Error SOCKET Closed because of abnormal package in
QRemote client. I am accessing QuickBooks Data from the remote machine
over the internet (WA...
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...
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 below error at the time of connection.
Please help me to resolve this error.
...
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...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER
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://support.flexquarters.co...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438
PROBLEM DESCRIPTION:
I am testing the connection of QODBC & I am getting QODBC test
connection failed error:
Can you advise what is error and the solution for it?
SOLUTION:
The above erro...
[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
...
[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...
TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - THE DRIVER DID NOT
SUPPLY AN ERROR - PYTHON
PROBLEM DESCRIPTION
I tried to connect to QODBC using python and it is giving me the
following error.
The python code I am using is this.
import pyodbc
...
Help Desk Software by Kayako