[QODBC-ALL] TROUBLESHOOTING - HOW TO FIX LICENSE CHECK WINDOWS
VIRTUALIZATION / VIRTUALSTORE
PROBLEM DESCRIPTION:
How to I fix QODBC license file stored in VirtualStore
SOLUTION:
Please remove the folder "QODBC Driver for QuickBooks" from the below
pa...
TROUBLESHOOTING - HOW TO FREE DISK SIZE MESSAGE
PROBLEM DESCRIPTION:
When I connect to QODBC, I am prompted to free disk space.
SOLUTION:
Please ensure you have 1 GB of free space in your primary drive where
your Windows Profile / Roaming Profile or...
TROUBLESHOOTING - HOW TO FIX DUPLICATE DEFAULT DSN.
PROBLEM DESCRIPTION:
How to resolve duplicate default DSN.
SOLUTION:
Configure 64-Bit QODBC Online Driver and switch to "User DSN".
Please delete the DSNs with the following names.
"QuickBooks ...
TROUBLESHOOTING - DEFAULT VALUE OF WINDOWS USER ACCESS CONTROL (UAC).
PROBLEM DESCRIPTION:
What should be the Default Windows User Access Control (UAC)?
SOLUTION:
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 than other ve...
QXL - QuickBooks Data Export Made Easy
Limited Use Software License
LICENSE:
LICENSER grants to you a limited, non-exclusive license to (i) install
and operate the copy of the computer program contained in this package
("Program") on a single computer...
[QODBC-ALL] TROUBLESHOOTING - TRAPPABLE ERROR (E06D7363) OCCURRED IN
AN EXTERNAL OBJECT
PROBLEM DESCRIPTION
A trappable error (E06D7363) occurred in an external object. The
script cannot continue running.
I receive this error when reading and writin...
HOW TO USE THE COMPUTER NAME INSTEAD OF IP ADDRESS IN QREMOTE?
PROBLEM DESCRIPTION 1:
When running a QRemote Server or a query, the IP address changes
randomly.
SOLUTIONS:
If you are using a 32-Bit QODBC manager, Please follow the below
steps:
Ope...
USING MS ACCESS APP 64-BIT AND 32-BIT (DIFFERENT MACHINES) WITH QODBC
PROBLEM DESCRIPTION:
My MS Access application links to QuickBooks tables via the QODBC ODBC
driver. The 64-bit QODBC calls the ODBC connection 'Quickbooks Data
64-Bit QRemote'. So my ...
LOCATE PROGRAM AND SELECT OPTIMIZER TAB
Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your
desktop. Click on the ODBC DATA SOURCE icon to launch the setup
program supplied with QODBC.
Please refer to How to locate Configure QODBC Data ...
THE INPUT STRING WAS NOT IN A CORRECT FORMAT / THE INPUT STRING WAS
NOT IN THE CORRECT FORMAT
PROBLEM DESCRIPTION:
I am running QXL and MS Office 365.
I have tried exporting to XLSX, XLS, and even CSV format, but only the
file header row writes.
Als...
HOW TO DEACTIVATE QODBC ONLINE
DEACTIVATE QODBC ONLINE FROM YOUR COMPUTER
You can Deactivate QODBC Online license from:
Start >> All Programs >> QODBC Driver for QuickBooks Online>>
Configure QODBC Data Source
Go To "System DSN" Tab>> Select "Qui...
[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 DESKTOP] MISSING QODBC MENUS IN THE START MENU
PROBLEM DESCRIPTION:
Missing QODBC Menus in the start menu
SOLUTIONS:
Navigate to the path: C:UsersAdministrator
In the Administrator folder, you will see the below options.
Switch to the 'Vi...
TROUBLESHOOTING: UNABLE TO CONNECT TO QUICKBOOKS USING QODBC. QODBC
FREEZE, QODBC HANGS, QODBC STUCK DURING CONNECTION.
PROBLEM DESCRIPTION 1:
I have the latest driver version and no errors during installation.
When I tried to connect, it just stuck "c...
HOW QODBC TALKS TO QUICKBOOKS SDK TO GET SAFE/ENCRYPTED/BALANCED DATA
FROM QUICKBOOKS, PREVENTING DATA CORRUPTION.
PROBLEM DESCRIPTION
* How does QODBC validates all the business logic which are part of
the QuickBooks application?
* Can QODBC read o...
HOW TO USE QODBC SUPPORT WIZARD
PROBLEM DESCRIPTION:
How to use QODBC Support Wizard?
SOLUTION:
Please follow the below-listed steps for using QODBC Support Wizard.
The "QODBC Support Wizard" application is included with QODBC
v18.0.0.325 and above...
There is no performance difference between the QODBC Server Edition
license and QODBC Read/Write license.
There is no difference in the commands, queries, data, or schema
between the QODBC Server Edition license and QODBC Read/Write license.
QODBC is ...
QODBC ONLINE MENU ITEMS
When you install QODBC Online below menu items are created under QODBC
Driver for use with the QuickBooks Online folder in the start menu.
1. CONFIGURE QODBC ONLINE DATA SOURCE 64-BIT
Configure QODBC Online Data Source 64-bit...
QODBC POS MENU ITEMS
When you install QODBC POS below menu items are created under QODBC
Driver for use with the QuickBooks POS folder in the start menu.
1. CONFIGURE QODBC POS DATA SOURCE 64-BIT
Configure QODBC POS Data Source 64-bit option will he...
QODBC MENU ITEMS
When you install QODBC, the below menu items are created under QODBC
Driver for use with the QuickBooks folder in the start menu.
1. CONFIGURE QODBC DATA SOURCE 64-BIT
CONFIGURE QODBC DATA SOURCE 64-BIT will help you to
view/create/...
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...
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...
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 - HOW TO CANCEL THE SUBSCRIPTION OF QODBC DRIVER FOR
QUICKBOOKS ONLINE
PROBLEM DESCRIPTION:
I want to cancel my QODBC Driver for QuickBooks Online monthly
subscription.
How to cancel the subscription of QODBC Driver for QuickBooks Onl...
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 - QODBC INSTALLER ERROR WINDOWS CANNOT FIND
EXPLORER.EXE. COULD NOT EXECUTE THE EXTERNAL PROGRAM
PROBLEM DESCRIPTION:
We downloaded the QODBC trial from your website. At the end of the
installation process - after clicking the 'finish'...
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 - 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 ...
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 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...
TROUBLESHOOTING - UPGRADING TO QUICKBOOKS AND QODBC
PROBLEM DESCRIPTION:
I have a custom program written in Access 2003 communicating with
QuickBooks 2013 using QODBC 13, which works fine. Will upgrade to the
latest QuickBooks and QODBC require any co...
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...
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 ...
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 - QUICKBOOKS UI GETTING LAUNCHED AFTER UPDATING QODBC
VERSION.
PROBLEM DESCRIPTION:
We recently upgraded from QODBC 14 to 16.00.00.313. It is functioning
normally, except now the QuickBooks window is opening up when it
didn't use to. I...
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 - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE
PROBLEM DESCRIPTION:
I cannot find or configure the 32-bit ODBC Data Source Manager under
a 64-bit System. I will be happy to remote access you and my server
representatives to resolve this....
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...
HOW TO CONNECT TO MULTIPLE COMPANY FILES AT THE SAME
TIME/SIMULTANEOUSLY
PROBLEM:
There are multiple company files in QuickBooks. At a time, I can
access only one company file. Is QODBC allow me to access multiple
company files same time?
SOLUTION:
T...
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...
HOW TO USE QODBC WITH WINDOWS SCHEDULER / HOW TO USE Z-CRON WITH
QODBC / HOW TO RUN QODBC APPLICATIONS ON A REPEATING/NIGHTLY BASIS
PROBLEM DESCRIPTION 1:
My application needs to read data from QuickBooks and update data in
the SQL server. Up to this, ...
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 USE QODBC ON MAC OR LINUX
PROBLEM DESCRIPTION:
I have MAC Operating System & I want to use QODBC on it. Is it
possible to use QODBC on MAC?
I have Linux Operating System & I want to use QODBC on it. Is it
possible to use QODBC...
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...
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 "...
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...
TROUBLESHOOTING - QUICKBOOKS DATA DSN NOT SHOWING UP IN ODBCAD32.EXE
ODBC DATA SOURCE ADMINISTRATOR IN WIN8
PROBLEM DESCRIPTION:
I can't configure QuickBooks Data DSN from Configure QODBC Data Source
window. When I click on QuickBooks Data, configure is...
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 - 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...
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...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR
PROBLEM DESCRIPTION:
I'm trying to establish a connection to QuickBooks using QRemote
Server. But when I tried to connect, I got the below error message:
"Wrong client Encyptkey setting"...
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 - HOW TO VERIFY IF THE OPTIMIZER FILE IS CORRUPTED OR
NOT
PROBLEM DESCRIPTION:
Is there any way to figure out when the Optimizer cache is corrupted,
or is there a way we can avoid it altogether in the future?
SOLUTIONS:
Please refer...
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 - 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...
Connecting QODBC Driver to QuickBooks for the First Time (Video)
Go to: How to set up the QODBC Optimizer and Where are the Optimizer
options
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358]
for the next step.
Yo...
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 - 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 - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC
PROBLEM DESCRIPTION:
We use software called RemiCrystal to generate reports for emailing.
The words have always worked fine using QB 2013 Pro and QODBC v14 (I
think v14). Then we upg...
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 - ERROR [42S00] [QODBC] INSERT VALUE MUST BE A SIMPLE
VALUE
PROBLEM DESCRIPTION 1:
We have a customer trying to import a credit memo from our database
into QuickBooks using a vb.net program. They are getting the following
error: ERROR [4...
TROUBLESHOOTING: UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER
PROBLEM DESCRIPTION 1:
I am using an MS SQL-linked server with QRemote.
I am updating a single EstimateItemLine, passing Ref Number and
ItemFullName (I also tried itemtxnlineid). Every...
TROUBLESHOOTING: HOW TO ACCESS ACCOUNT NAME DETAILS FROM JOURNAL
REPORT USING SQL SERVER
PROBLEM DESCRIPTION:
I need some guidance on extracting data from the general ledger. In
particular, I need to see the FullName of GL account. Running
sp_report Jo...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT
PROBLEM DESCRIPTION:
How can I get a Quick Report on an account from the Chart of Accounts?
In Quick Books 2006 Premier, I opened a chart of accounts (Ctrl+A),
selected an account, and then pressed Ctrl+Q.
S...
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...
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 ...
QODBC LICENSING INFORMATION
Also Refer: QODBC with QRemote Licensing Information
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/]
Different types of licenses are required depending on your requirement
in QODBC; pl...
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 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...
HOW TO REMOVE OPTIMIZER FILE
WHAT IS THE OPTIMIZER FILE?
When you turn on the Optimizer, QODBC will bring some data to a local
cache file (the optimizer file) to increase retrieval performance for
queries.
When you access any table, QODBC will gather...
HOW TO SETUP QODBC TO RUN WITHOUT QUICKBOOKS
PROBLEM DESCRIPTION
* I want to use QODBC, which does not have the QuickBooks program on
the machine.
* Do I need QuickBooks installed on the machine to use QODBC?
* Can QODBC read directly from QuickBo...
Accessing QuickBooks Data Remotely using QODBC & QRemote
Using QuickBooks data remotely via QODBC
FOR USING QREMOTE OVER THE INTERNET & WITH DYNAMIC IP (NON-STATIC-IP):
You can make sure of services like Dynamic DNS (DDNS or DynDNS). It is
a method o...
DCOM / SERVER EDITION TAB MISSING IN QODBC SETUP SCREEN
We recommend you use QRemote instead of DCom. This is because QRemote
is easy to configure and works for 32 & 64-bit applications.
For SQL Server 64-bit, Click Here "How to create Link Server with...
PROBLEM
I am unable to Activate/Deactivate the currently installed version. I
am logged in as Administrator, with admin rights, and right-clicking
on the Setup and selecting "Run As Administrator" does not change the
result.
You do not have Sufficient...
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...
INSTALLATION STEPS FOR WINDOWS 8
After you have downloaded QODBC Installer, navigate to the "Downloads"
Folder or the location where you have saved QODBC Installer. Run the
installer as administrator by Right-clicking on the installer and
selecting "Run...
ACTIVATING QODBC STILL SHOWS THE EVALUATION VERSION IN THE QODBC SETUP
SCREEN.
If you have activated QODBC with a purchased license CDKey and get the
"Activation Successful" message and then run an application trying to
use QODBC, you get the message t...
How to Get QODBC to go with 64-bit Applications
HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT APPLICATIONS
INSTRUCTIONS
64 and 32-bit words are kept separate in the Microsoft Windows
Operating System. QuickBooks 2022 and above are 64-Bit applications
and...
HOW TO SETUP QODBC IN WINDOW SERVER 2003 SP2 SYSTEM
NOTE: QuickBooks is running on the server console.
QODBC DCOM SETTING
Make sure Server Edition Use DCOM Servers is checked.
Also refer : DCom Option / Server Edition Tab missing in QODBC Setup
T...
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...
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...
NOTE: DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU CAN
USE QREMOTE.
Please refer to the articles for more information:
Web Server
How to build a QuickBooks IIS Web application using QODBC Driver and
Microsoft ASP.NET (Video)
[https:/...
QODBC SETUP OPTIONS
QODBC GENERAL SETUP
The first step in configuring the driver is to click on the QODBC
Setup Screen, and the following general setup screen will become
available.
USING THE COMPANY FILE THAT'S NOW OPEN IN QUICKBOOKS allows QODBC ...
WHERE ARE THE OPTIMIZER OPTIONS
LOCATE QODBC OPTIMIZER
Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your
desktop. CLICK ON THE QODBC SETUP SCREEN icon to launch the setup
program supplied with QODBC.
The following general setup scree...
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...
SETUP WITH ODBCINST.INI FILE
ADD OPTION INTO ODBCINST.INI FILE
Add the TraceWithXML=Yes option line to your:
FOR WINDOWS XP SYSTEM
C:Documents and SettingsAll UsersApplication DataQODBC Driver For
QuickBooksodbcinst.ini file
FOR WINDOWS VISTA SY...
LAUNCH QODBC DATA SOURCE CONFIGURATION
Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your
desktop. Click on the CONFIGURE QODBC DATA SOURCE icon to create or
configure a QODBC Data Source Name (DSN).
CREATE A NEW DSN
Click on the SYST...
HOW TO TURN ON THE TRACE LOG
You can Turn on Detail Trace from Start >> All Programs >> QODBC
Driver for use with QuickBooks >> Configure QODBC Data Source.
Go To the "System DSN" Tab, Select "QuickBooks Data" DSN & click
"Configure."
Navigate to the...
METHOD FOR STARTING QODBC SETUP SCREEN OF A SPECIFIED DSN
PASS DSN ON A COMMAND LINE
You can pass your DSN on a command line via:
START -> RUN... -> Input:
"C:Program FilesQODBC Driver for QuickBooksEditQDSN.exe" QODBC
Auto-Login
SETUP A DES...
Help Desk Software by Kayako