[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-DESKTOP] TROUBLESHOOTING - QUICKBOOKS 2022 - COULD NOT
START QUICKBOOKS - WINDOWS SERVER 2012 R2 & WINDOWS SERVER 8
ISSUE:
We upgraded our QuickBooks Enterprise from 2020 to 2022. We were using
QuickBooks 2020 and the QODBC driver versio...
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...
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 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 - 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 ...
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 - 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...
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 ...
TROUBLESHOOTING - CAN I USE QODBC WITH QBB ( QUICKBOOKS BACKUP ) FILE
PROBLEM DESCRIPTION:
I am trying to find a way to pull data from a . QBB file without
having to restore the. QBB file and going through QuickBooks.
Is QODBC capable of doing so? I...
[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 ...
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 - 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 - FAULTING APPLICATION NAME: QREMOTESERVER.EXE
PROBLEM DESCRIPTION:
We recently had a few error messages pop up on the server related to
the QODBC driver on our server. We were wondering if you could provide
any information as to what ...
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 - GETTING UNEXPECTED EXTRA TOKEN ERROR IN DATE FIELD
QUERY
PROBLEM DESCRIPTION:
I am trying to query the Transaction table based on the TxnDate field.
I tried the below code.
OdbcCommand SourceCmd = new OdbcCommand("Select * from Tra...
TROUBLESHOOTING - "CANNOT UPDATE TABLE ITEMINVENTORY ERROR 10004."
PROBLEM DESCRIPTION:
I am trying to run an update on the Name field in ItemInventory. I've
checked to see if it's updateable, and it is.
I get "Cannot update table ItemInventory Error...
TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES
PROBLEM DESCRIPTION:
I have to update a field with specific data; for some records, one of
the fields will have leading spaces that are required to be there. I
have tried numerous ways to get th...
TROUBLESHOOTING - GETTING TIMEOUT ERROR IN SQL SERVER'S LINKED SERVER
USING QODBC
PROBLEM DESCRIPTION:
I recently upgraded from 1.0.0.7 to 1.0.0.312. Everything was pretty
smooth, except for our Linked Servers timeout now. I test the QODBC
connection,...
TROUBLESHOOTING - MICROSOFT EXCEL 2013 (OFFICE 365 / 2016) CRASHES /
REQUIRED ACTIVATION
TROUBLESHOOTING - MICROSOFT ACCESS 2013 (OFFICE 365 / 2016) CRASHES
/ REQUIRED ACTIVATION
PROBLEM DESCRIPTION 1:
I have been having significant difficulties wit...
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,...
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 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 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...
HOW TO USE QODBC ONLINE WITH QUICKBOOKS ONLINE EDITION (APPS.COM)
SETUP OF QODBC ONLINE:
The first step is to download and install QODBC Online. QODBC Online
requires .NET Framework 4.6.1 or a later version. So you need to
install .NET Framework 4.6.1 t...
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...
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...
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 - 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...
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 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...
TROUBLESHOOTING: UNABLE TO CONNECT TO THE QUICKBOOKS DATABASE.
PROBLEM DESCRIPTION:
I installed the QODBC driver as a new install. I have configured the
ODBC and made sure that the driver is referenced and checked in the
Integrated Applications window i...
PROBLEM DESCRIPTION:
VB DemoQODBC Test ToolTest Connection was crashing When I tried to
connect to QuickBooks using QODBC.
I have tried to reinstall QODBC & QuickBooks, but the QODBC Test
connection (via VB Demo or QODBC Test Tool) is still crashing. A...
PROBLEM:
I have a customer who does their invoicing with an ASP.NET
application, and it flows into QuickBooks. I created the interface
with QODBC, and it works with no problem except that sometimes the
processes will lock up, and I have to remote into th...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS
PROBLEM DESCRIPTION:
When there is huge data in QuickBooks POS, QODBC POS cannot pull all
data in Table SalesReceipt from QuickBooks POS.
SOLUTION:
1. When there are huge data in Qu...
TROUBLESHOOTING: THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR
CHANGES IN THE CUSTOM FIELD
PROBLEM DESCRIPTION:
The QBReport Admin Group views are not updated for changes in custom
field id's. The user can see QBReportAdminGroup and other tables in...
PROBLEM DESCRIPTION:
I have closed the QODBC connection to QuickBooks.
But It still shows running in task manager QBW32.EXE keeps running
even after QODBC closes the connection.
SOLUTIONS:
When the Disconnect command is sent to QODBC, QODBC sends th...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE
OR SERVER EDITION
PROBLEM DESCRIPTION
When I try to run a command in QODBC Test Tool, I get the error
message "This function requires QODBC read-write or server version."
I am try...
TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED"
WHEN WORKING WITH 64-BIT ACCESS OR EXCEL
PROBLEM DESCRIPTION:
Set up QRemote to work with 64-bit MS Excel. The Client DSN settings
are correct. But when access to "QRemote Data 64-bit,...
PROBLEM DESCRIPTION
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed.
Error = 80040408, Could not start QuickBooks.
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed.
Error = 80040408, Could not start Reckon Accounts. ...
PROBLEM DESCRIPTION:
I am trying to connect to QuickBooks through SSIS using QODBC, but I
cannot connect to QuickBooks.
I have a Read Only Desktop edition of QODBC, which is included with
QuickBooks Enterprise Edition.
I am getting the error: "Error ...
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...
PROBLEM :
QBXML components have not been installed. / Error Getting Version /
QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks
REASON :
There have been a few problems reported when Upgrading to QuickBooks
2013 R7.
After auto up...
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
C...
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...
TROUBLESHOOTING: THIS APPLICATION IS NOT ALLOWED TO CHANGE ITS
AUTHENTICATION PREFERENCES UNLESS QUICKBOOKS IS RUNNING WITH THE
ADMINISTRATOR LOGGED IN
PROBLEM DESCRIPTION:
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session F...
TROUBLESHOOTING: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS
FAILED" ERROR.
PROBLEM DESCRIPTION:
QODBC POS reports a "Test Connection to QuickBooks POS failed" error
when trying to connect to QuickBooks POS:
SOLUTION:
This error shows a pro...
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: ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061
- 10061 CONNECTION REFUSED
PROBLEM DESCRIPTION:
When doing a connection test using the "Test Connection" button in
QODBC Setup Screen->General Window, QODBC reports this error:
...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION -
QBOE
PROBLEM DESCRIPTION:
When trying to update the memo field in the table Invoice or
InvoiceLine, QODBC reports the error:
[QODBC]Error:1030-Not Support
It is not only in the ...
[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...
"HY111 database connector error invalid bookmark value" on crystal
report when refreshing the report.
SOLUTIONS
This could be the issue with the company file or Optimizer.
I kindly request you follow the steps and let us know if that resolves
the is...
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...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM
DSN WITH ANY APPLICATION OTHER THAN THE QODBC TEST TOOL
PROBLEM DESCRIPTION
Testing under the 64-bit system, when using the QODBC Test Tool
application, the user can see DSN (QuickBo...
PROBLEM
Created a VBS referring -
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Arti...
PROBLEM DESCRIPTION:
When I attempt to configure the driver and data source, only QRemote
for the QuickBooks driver is visible; please see below:
Where can I find QuickBooks Data, the driver? Don't I need to
configure the QuickBooks Data driver instead...
TROUBLESHOOTING: CREATE DCOM INSTANCE ERROR = 80070005, UNKNOWN ERROR.
CREATED QBXMLRP2 OK.
PROBLEM DESCRIPTION:
When trying to use SQL Server via QODBC, It reports the error like
this:
Create DCOM Instance Error = 80070005, Unknown error. Created q...
TROUBLESHOOTING: CONNECTION LOST BETWEEN QODBC AND QUICKBOOKS /
QUICKBOOKS ASKING FOR PASSWORD EVEN THOUGH CERTIFICATE IS ACCEPTED.
PROBLEM DESCRIPTION
We might get an issue where every time we reboot our file server the
connection between QODBC and Qui...
TROUBLESHOOTING: RDS CLIENT IS NOT INSTALLED
PROBLEM DESCRIPTION
In a 64-bit system, I downloaded the RDS client, but when I launch the
odbc configuration, it keeps on telling me the RDS client is not
installed error.
SOLUTIONS
That was a bug on 64-b...
TROUBLESHOOTING: .NET FRAMEWORK INITIALIZATION ERROR WITH RDS
PROBLEM DESCRIPTION
Some people may get a .NET error as below when trying to launch RDS
Server/Client after a successful installation of RDS applications:
RDSServer.exe - ".Net Framework ...
TROUBLESHOOTING: CONNECTION ERROR AFTER QODBC OR QUICKBOOKS UPGRADE
PROBLEM DESCRIPTION 1
Sometimes when upgrading to a new version of QODBC, the connection
test fails. If I go to the advanced tab in the setup, I get an error
about NOT FINDING A DLL -...
TROUBLESHOOTING: COMPANY FILE SPECIFIED IS NOT AUTHORIZED FOR REMOTE
ACCESS
PROBLEM DESCRIPTION
I have followed the instructions for the RDS setup but got the
following error:
First, how to Authorize remote access? and how to fix this problem.
S...
TROUBLESHOOTING: BEGIN SESSION FAILED ERROR=80040154 - CREATE
QUICKBOOKS COM INSTANCE ERROR=80040154 OR CLASS NOT FOUND
PROBLEM DESCRIPTION.
Suppose you receive an 80040154 error like the one below when
connecting to QuickBooks. In that case, somethin...
TROUBLESHOOTING: GET ERROR 8004040A AFTER UPDATE THE DRIVER
PROBLEM DESCRIPTION 1
I updated the driver, and now it will not connect to the company
file. I'm getting error = 8004040a. It says the company file is
already open and different from the one ...
TROUBLESHOOTING: MODAL WINDOW CAUSES QBW32.EXE TO HANG IN THE
BACKGROUND WHEN OPENED WITH QODBC
PROBLEM DESCRIPTION 1
I'm running PHP scripts on a Win 2k server to access my company file
and export specific tables to CSV files. I've checked the option ...
Help Desk Software by Kayako