USING MICROSOFT POWERBI WITH QUICKBOOKS DATA
PROBLEM DESCRIPTION 1:
How to connect to QuickBooks Data with Power BI using QODBC Desktop?
SOLUTIONS:
Open the QODBC setup screen and change the QODBC Compatibility mode
from "Default" to "3.8."
To cha...
HOW TO USE QODBC WITH TABLEAU DESKTOP
For using QODBC with Tableau Desktop, You need to use QODBC V
18.0.0.326 or a later version.
If you are using an older version of QODBC, please upgrade your QODBC
to the latest version. Click here [http://qodbc.com...
HOW TO USE QLIKSENSE DESKTOP (WEB-BASED) WITH QODBC
To use QlikSense Desktop with QODBC, Please follow the below steps.
Open QlikSense Desktop in the browser & click on the "CREATE A NEW
APP" button.
Enter the app name and click the "Create" button. ...
TROUBLESHOOTING - HOW TO CONVERT MS OFFICE FROM 64-BIT TO 32-BIT
PROBLEM DESCRIPTION:
I am on Windows 64-bit and Office 365 64-bit. QODBC Test Tool works
fine when I use QuickBooks Data as a connection source.
If I use QRemote, I get the "Evaluation ...
TROUBLESHOOTING - QODBC HUNG UP, EVERYTHING LOOKS LOCKED UP, OR THE
APPLICATION IS NOT RESPONDING WHEN FETCHING QUICKBOOKS DATA.
PROBLEM DESCRIPTION:
I can access the database, but when I added another table & fetch
table data, it generally hung up. No...
HOW TO USE M-FILES WITH QODBC
PROBLEM DESCRIPTION:
How to use M-Files with QODBC?
SOLUTION:
Please follow the below steps for using M-Files with QODBC.
1. Open M-Files Admin.
2. Expand the desired connection to M-Files Server in the left-side
tre...
HOW TO CREATE SP_REPORTS USING MICROSOFT EXCEL
HOW TO EXTRACT SP_REPORTS USING MICROSOFT EXCEL
OPEN MICROSOFT QUERY IN EXCEL
Open Microsoft Excel, get external data from Microsoft Query via Data
Menu -> "Get Data -> From Other Sources->From Microsoft...
HOW TO MANUALLY START QREMOTESERVER
By default, QRemoteServer will start as soon as a user logs on to the
system.
You can manually start QRemoteServer by the below steps:
You can begin to QRemoteServer from: Start >> All Programs >> QODBC
Driver for ...
HOW TO CREATE OR CONFIGURE A QREMOTE DSN
LAUNCH QODBC DATA SOURCE CONFIGURATION
Locate the QODBC DRIVER FOR THE QUICKBOOKS program group from Startup
Program: Start >> All Programs >> QODBC Driver for use with QuickBooks
>> Configure QODBC Data Source....
TROUBLESHOOTING - DATA SOURCE NAME NOT FOUND, AND NO DEFAULT DRIVER
SPECIFIED
PROBLEM DESCRIPTION:
I have QODBC running on a terminal server.o
I can use 64-bit Excel to query QODBC via the "from other sources." I
have set up a 64-bit remote DSN that ...
TROUBLESHOOTING - HOW TO ADD QREMOTE TO STARTUP
PROBLEM DESCRIPTION 1:
How to add QRemote to ALL users Startups?
SOLUTION 1:
It would be best to enabled QRemote Server to auto-start from the
QRemote Server.
Open the QRemote Server from the Start M...
HOW TO USE QLIKSENSE DESKTOP WITH QODBC
To use QlikSense Desktop with QODBC, Please follow the below steps.
Open QlikSense Desktop & click on the "CREATE A NEW APP" button.
Enter the app name and click the "Create" button.
A New application in Qlik...
TROUBLESHOOTING - HOW TO CONNECT TO QUICKBOOKS USING PDO
PROBLEM DESCRIPTION:
We have a setup connecting a PHP application to QuickBooks with QODBC.
This works correctly using odbc_connect.
However, if we try to connect using PDO instead, we get 500...
HOW TO USE BARTENDER WITH QODBC
PROBLEM DESCRIPTION:
How to use BarTender with QODBC?
SOLUTION:
Please follow the below steps for using BarTender with QODBC.
Please start BarTender & create a new document by clicking "Start a
new BarTender document...
HOW TO USE DBASE PLUS WITH QODBC
PROBLEM DESCRIPTION:
How to use dBase Plus with QODBC?
SOLUTION:
Please follow the below steps for using dBase Plus with QODBC.
Please start dBase Plus & create a new form by clicking "New Form."
Select the "Desig...
TROUBLESHOOTING - HOW TO USE ANY OTHER QUICKBOOKS USER OTHER THAN
ADMIN.
PROBLEM DESCRIPTION:
We have installed the QODBC and can read the tables in QODBC Test
Tool. However, after doing the initial read as an admin to QuickBooks,
we cannot read the ta...
TROUBLESHOOTING - ERROR = 80040437, THE USER YOU ARE TRYING TO LOG IN
WITH IS ALREADY LOGGED IN FROM ANOTHER MACHINE.
PROBLEM DESCRIPTION:
Our company uses QuickBooks 2018 contractor edition, which allows only
one user simultaneously.
Yesterday, I se...
TROUBLESHOOTING - QREMOTE FOR QUICKBOOKS IS NOT LISTED AS A CHOICE IN
ODBC SETUP SCREEN
PROBLEM DESCRIPTION:
I am trying to set up the QODBC Driver on a machine running Windows
Server 2016. Previously, I have had it set up and working fine on my
local ...
TROUBLESHOOTING - CAN I USE QODBC WITHOUT HAVING QUICKBOOKS
INSTALLED?
PROBLEM DESCRIPTION:
My clients give me a backup copy of their QuickBooks file. I don't
have QuickBooks installed on my computer but would like to bring the
data into Excel. Can I u...
TROUBLESHOOTING - QODBC IS NO LONGER LICENSED FOR THIS RECKON VERSION
PROBLEM DESCRIPTION:
We have been using QODBC without problems with our current QuickBooks
version for months. Suddenly QODBC has stopped working on all our
computers.
I have tried a...
TROUBLESHOOTING - GETTING ERROR WHEN TRYING TO CONFIGURE QODBC IN SQL
SERVER
PROBLEM DESCRIPTION:
I'm trying to install the QODBC on our SQL Server, and I followed all
steps in your documentation on How to create a Link Server with MS SQL
2005/2008/201...
TROUBLESHOOTING - UNKNOWN EXCEPTION QODBC CAN'T QUERY-SPECIFIC TABLE;
CRASHES QUICKBOOKS
PROBLEM DESCRIPTION:
QB Desktop Enterprise 2017 Manufacturing & Wholesale R5_88
Successfully installed QODBC using Optimizer. Can query every table
with QODBC TEST...
TROUBLESHOOTING - QODBC DRIVER CRASHES QUICKBOOKS 2017 ON CLOSE
PROBLEM DESCRIPTION:
QODBC crashes QB Desktop 2017 after completing all SQL transactions.
Here are the details.
1. SQL command is sent to the QODBC connector
2. QODBC connector opens u...
TROUBLESHOOTING - [FIXED] MICROSOFT EXCEL/ACCESS 365/2016 - INVALID
CERTIFICATE ERROR/DIGITAL SIGNATURE ERROR/CERTIFICATE ERROR/GETTING
INVALID CERTIFICATE ERROR WHEN TRYING TO CONNECT USING MS ACCESS OR
EXCEL
PROBLEM DESCRIPTION:
I am using QODBC to e...
TROUBLESHOOTING - GETTING ERROR A FOUR-PART NAME WAS SUPPLIED, BUT
THE PROVIDER DOES NOT EXPOSE THE NECESSARY INTERFACES TO USE A CATALOG
OR SCHEMA.
PROBLEM DESCRIPTION:
I am using QODBC to fetch QuickBooks Data in SQL Server. I have
created Linked S...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE
PROBLEM DESCRIPTION:
I am using QODBC to access QuickBooks Data. I have linked all
QuickBooks tables using QODBC.
I want the Customer table to be Optimizer OFF and the rest to be
Optim...
HOW TO INSTALL QODBC READ-ONLY EDITION FOR QUICKBOOKS ENTERPRISE
EDITION
PROBLEM DESCRIPTION:
I am using QuickBooks Enterprise & I want to use QODBC read-only
edition for QuickBooks Enterprise.
How can I install QODBC read-only edition for QuickBooks...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com//support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net-VB.zip]
for down...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE INTO EXISTING
INVOICE
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample-VB.zip]
for downloading Sample Code.
Please refer be...
TROUBLESHOOTING - HOW TO TURN ON/OFF ENCRYPTION ON QREMOTE
PROBLEM DESCRIPTION:
I am using QRemote to access QuickBooks Data & I want to add security
when accessing my QuickBooks Data through QRemote.
How can I use Encryption in QRemote?
SOLUTION ...
TROUBLESHOOTING - HOW TO USE QREMOTESERVER WITH MULTIPLE WINDOWS USER
PROBLEM DESCRIPTION:
I have a server where multiple users are logged in.
I want to run QRemoteServer for each Windows User.
Can I configure QRemoteServer user-wise? So QRemote c...
TROUBLESHOOTING - HOW TO CHANGE THE CONNECTION STRING STORED IN EXCEL
PROBLEM DESCRIPTION:
I have changed the setting in QODBC Setup Screen from Open mode to the
same as the company file, but my Excel still does not takes the
changes and needs the comp...
TROUBLESHOOTING - [FIXED] QODBC EXTREMELY SLOW AFTER LATEST QUICKBOOKS
2017 R5 UPDATE
PROBLEM DESCRIPTION:
We updated to the latest QuickBooks 2017 Patch, officially known as
Release R5P. After running seemingly OK for two days, QODBC is
*extremely* slu...
HOW TO USE QODBC WITH LAYER2 CLOUD CONNECTOR SOLUTION
This article shows how you can easily integrate the QODBC driver for
QuickBooks into Layer2 Cloud Connector Solution.
1. Open Connection Manager by clicking on "Start Connection Manager."
Connecti...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET WEB APPLICATION
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVCW/QODBC-Invoice-Insert-Sample-Asp.net.zip]
to download Sample Code.
...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING
C#.NET
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVC/QODBC-Invoice-Insert-Sample.zip]
to download Sample Code.
Please refer below steps...
SAMPLE CODE FOR INSERTING INVOICELINE TO EXISTING INVOICE USING PHP
SAMPLE APPLICATION:
Please click here
[http://support.flexquarters.com/esupport/newimages/INVPHP/QODBC-Invoice-Insert-Sample-php.zip]
to download Sample Code.
Please refer below st...
TROUBLESHOOTING - GETTING ERROR SPECIFIED DRIVER COULD NOT BE LOADED
DUE TO SYSTEM ERROR 182
PROBLEM DESCRIPTION:
We upgraded to QuickBooks Enterprise 15, and now we cannot get
QReportBuilder to refresh data.
The error is
Error message: Could not crea...
TROUBLESHOOTING - CAN I USE DROPBOX/GOOGLE DRIVE WITH QUICKBOOKS &
QODBC?
PROBLEM DESCRIPTION:
Can I use Dropbox/Google Drive with QuickBooks & QODBC?
SOLUTION:
No, You can't use Dropbox/Google Drive with QuickBooks & QODBC because
Dropbox/Google Dri...
TROUBLESHOOTING - PERFORMANCE ISSUE QODBC TEST TOOL VERSUS MY C# APP.
PROBLEM DESCRIPTION:
I am running the same query on both returns, a big difference. The
QODBC Test Tool app takes around 7 seconds, and my C# app takes 1:20
minutes.
Are there any s...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN
SQL SERVER.
PROBLEM DESCRIPTION:
I am trying to create Linked Server on SQL Server.
QODBC TEST TOOL connects successfully to QREMOTE on QuickBooks Server.
Setting up the Linked se...
HOW TO USE QODBC WITH MICROSTRATEGY
QODBC enables access to various important data sources in business
intelligence tools such as Microstrategy. In this article, We will
show how to connect to QuickBooks data, import data with the UI or
query, and create...
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://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
HOW TO USE QODBC WITH TALEND ETL
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://docs.oracle.com/javas...
HOW TO USE QODBC WITH TIBCO SPOTFIRE
This article walks you through using the QODBC Driver for QuickBooks
in TIBCO Spotfire. You will use the data import wizard to connect to a
DSN (data source name) for QuickBooks and build on the sample
visualizations ...
TROUBLESHOOTING - LOGGING OUT THE QUICKBOOKS USER THROUGH QODBC
PROBLEM DESCRIPTION:
We created a user expressly for QODBC access.
How can we facilitate a way for our QuickBooks users to log this user
off when the single-user mode is needed?
SOLUT...
TROUBLESHOOTING - QREMOTE SERVER IS NOT RETURNING DATA TO SQL SERVER
PROBLEM DESCRIPTION:
Installed the server connection component and began the process of
reconnecting
I ran a really simple set of tests:
select * from C01...Terms Select * from op...
TROUBLESHOOTING - GETTING ERROR UNABLE TO BIND TO SPECIFIED IP
ADDRESS
PROBLEM DESCRIPTION:
QODBC stopped working, and I got IP errors. All fixes I can find on
support pages require that QRemote Server is started. QRemote Server
will not start.
I ge...
TROUBLESHOOTING - GETTING ERROR THIS FILE IS IN USE
PROBLEM DESCRIPTION:
We are trying to use your drivers to connect to 3 different
QuickBooks files. But when I browse to the first file to setup the
ODBC data source, I get this message:
We are dead...
TROUBLESHOOTING - ERROR: 1000 - THERE HAS BEEN AN INTERNAL ERROR WHEN
PROCESSING THE REQUEST
PROBLEM DESCRIPTION:
I get a very strange error... I have a development system and a dummy
QB file (copy of the company file) that runs fine. However, when I
m...
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://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bri...
HOW TO USE QREMOTE WITH COLDFUSION
INSTRUCTIONS ABOUT USING QREMOTE WITH COLDFUSION
Using ColdFusion on an internal Intranet or the World Wide Web
requires the Server Edition of QODBC. QuickBooks must be running with
the company file opened on the sys...
TROUBLESHOOTING - GETTING ODBC-CALL FAILED ERROR IN MS ACCESS WHEN
OPENING THE RECEIVEPAYMENTTODEPOSIT TABLE
PROBLEM DESCRIPTION:
I am trying to link the ReceivePaymentToDeposit table through the
linked table in MS Access. I can connect the ReceivePaym...
TROUBLESHOOTING - QODBC - USER RIGHTS WITHIN QUICKBOOKS
PROBLEM DESCRIPTION 1:
I want to be able to access QuickBooks to extract inventory data in
database format. I believe this is possible with QODBC. My issue is
that I do not want this person to hav...
HOW TO CONNECT AND USE FOXPRO WITH QODBC
Open Visual FoxPro from Start Menu:
FoxPro started:
Open "Command Window" from Windows Menu:
"Command Window" Opened. You can execute FoxPro commands from the
"Command Window."
You need to write FoxPro com...
QODBC EVALUATION PERIOD EXPIRED AFTER UPGRADE TO INTUIT ENTERPRISE.
PROBLEM DESCRIPTION:
An older trial installation of QODBC (from before QB Enterprise and
long expired) was once on this computer.
How do I proceed to install the QODBC driver include...
Help Desk Software by Kayako