RSS Feed
Knowledgebase : QODBC > Connection
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 includ...
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 "Command Window". You need to write FoxPro command...
TROUBLESHOOTING - QODBC - USER RIGHTS WITHIN QUICKBOOKS PROBLEM DESCRIPTION 1: I would like 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 ...
TROUBLESHOOTING - GETTING ODBC-CALL FAILED ERROR IN MS ACCESS WHEN OPENING RECEIVEPAYMENTTODEPOSIT TABLE PROBLEM DESCRIPTION: I am trying link ReceivePaymentToDeposit table through the linked table in MS Access. I am able to link ReceivePaymentToDeposi...
HOW TO USE QREMOTE WITH COLDFUSION INSTRUCTIONS ABOUT USING QREMOTE WITH COLDFUSION Using ColdFusion, 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 op...
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...
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 mo...
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 - GETTING ERROR UNABLE TO BIND TO SPECIFIED IP ADDRESS PROBLEM DESCRIPTION: QODBC stopped working and I get IP errors. All fixes that I can find on support pages requires that QRemote Server is started. QRemote Server will not start. ...
TROUBLESHOOTING - QREMOTE SERVER IS NOT RETURNING DATA TO SQL SERVER PROBLEM DESCRIPTION: Installed the server connection component, and began the process of reconnecting Ran a really simple set of tests: select * from C01...Terms Select * from ope...
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 single user mode is needed? SOLUTION:...
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 ...
HOW TO USE QODBC WITH TALEND ETL This article shows how you can easily integrate the QODBC driver for QuickBooks into your workflow in Talend. Follow the steps below to connect to the DSN and create real-time data visualizations: 1. Open Talend ETL & c...
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 MICROSTRATEGY QODBC enable access to a wide variety of 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 with a q...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN SQL SERVER. PROBLEM DESCRIPTION: I am trying to create Linked Server on SQL Server. VB DEMO connects successfully to QREMOTE on QuickBooks Server. Setting up the Linked server - I...
TROUBLESHOOTING - PERFORMANCE ISSUE VB DEMO VERSUS MY C# APP. PROBLEM DESCRIPTION: I am running the same query on both returns a big difference. The VB Demo app takes around 7 seconds and my C# app takes 1:20 minutes. Are there any settings which I ne...
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 - 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 creat...
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] for download Sample Code. Please refer below s...
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] for download Sample Code. Please refer below step...
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] for download Sample Code. ...
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...
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...
TROUBLESHOOTING - HOW TO CHANGE CONNECTION STRING STORED IN EXCEL PROBLEM DESCRIPTION:  I have changed setting in QODBC Setup Screen from Open mode to same as company file but my Excel still does not takes the changes and needs company file to be in mul...
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 TURN ON/OFF ENCRYPTION ON QREMOTE PROBLEM DESCRIPTION: I am using QRemote to access QuickBooks Data & I want to add security when I accessing my QuickBooks Data through QRemote. How can I use Encryption is QRemote? SOLUTIO...
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...
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...
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...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE PROBLEM DESCRIPTION: I am using QODBC access QuickBooks Data. I have linked all QuickBooks tables using QODBC. I want to use Customer table to be Optimizer OFF and rest of the tables t...
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...
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 - 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 - 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 VB Demo 32...
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 How to create Link Server with MS SQL 2005/2008/2012 64-...
TROUBLESHOOTING - QODBC 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 fe...
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 - QREMOTE FOR QUICKBOOKS NOT LISTED AS 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 Windo...
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 at the same time. Yesterday, I h...
TROUBLESHOOTING - HOW TO USE ANY OTHER QUICKBOOKS USER OTHER THAN ADMIN. PROBLEM DESCRIPTION: We have installed the QODBC and can read the tables in VB Demo. However, after doing the initial read as an admin to QuickBooks, we are unable to then read th...
HOW TO USE DBASE PLUS WITH QODBC PROBLEM DESCRIPTION: How to use dBase Plus with QODBC? SOLUTION: Please follow below steps for using dBase Plus with QODBC. Please start dBase Plus & create a new form by clicking "New Form". Select "Designer" opt...
HOW TO USE BARTENDER WITH QODBC PROBLEM DESCRIPTION: How to use BarTender with QODBC? SOLUTION: Please follow below steps for using BarTender with QODBC. Please start BarTender & create a new document by clicking "Start a new BarTender document..."...
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 QLIKSENSE DESKTOP WITH QODBC To use QlikSense Desktop with QODBC, Please follow the below steps. Open QlikSense Desktop & click on "CREATE A NEW APP" button. Enter app name and click "Create" button. A New application in QlikSense Deskto...
TROUBLESHOOTING - HOW TO ADD QREMOTE TO STARTUP PROBLEM DESCRIPTION 1: How to add QRemote to ALL users Startup? SOLUTION 1: You need to reinstall QODBC for adding QRemoteServer to ALL user Startup. Please reinstall QODBC. After installation of QOD...
TROUBLESHOOTING - DATA SOURCE NAME NOT FOUND AND NO DEFAULT DRIVER SPECIFIED PROBLEM DESCRIPTION: I have QODBC running on a terminal server. I can use 64-bit Excel to query QODBC via the "from other sources". I have set up a 64-bit remote DSN which t...
HOW TO CREATE OR CONFIGURE A QREMOTE DSN LAUNCH QODBC DATA SOURCE CONFIGURATION Locate the QODBC DRIVER FOR QUICKBOOKS program group from Startup Program: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source CR...
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 following below steps: You can start QRemoteServer from: Start >> All Programs >> QODBC Driver f...
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 USE M-FILES WITH QODBC PROBLEM DESCRIPTION: How to use M-Files with QODBC? SOLUTION: Please follow below steps for using M-Files with QODBC. 1. Open M-Files Admin. 2. In the left-side tree view, expand the desired connection to M-Files Ser...
TROUBLESHOOTING - QODBC HUNG UP OR EVERYTHING LOOKS LOCKED UP OR 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. Not sure...
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. VB Demo works fine when I use QuickBooks Data as connection source. If I use QRemote I get the "Evaluation Expired. QR...
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 "CREATE A NEW APP" button. Enter app name and click "Create" button. A New appl...
HOW TO USE QODBC WITH TABLEAU DESKTOP For using QODBC with Tableau Desktop, You need to use QODBC V 18.0.0.326 or later version. In case you are using an older version of QODBC, please upgrade your QODBC to the latest version. Click here [http://qodbc....