RSS Feed
Knowledgebase : QODBC > Setup
     

QODBC QUICK START GUIDE Download: QODBC 2023 Quick Start Guide [https://qodbc.com/download/QODBCQuickStartGuide.pdf] (PDF) QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM] INTRODUCTION WHAT IS ODBC? ODBC (OPEN DATABASE CONNECT...
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...
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...
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...
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 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...
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 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...
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...
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...
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 - 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...
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...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS EXCEL REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into MS Excel Report. The attached invoice is similar to what we need to export to MS Excel...
TROUBLESHOOTING - GETTING ERROR [HY004] [MICROSOFT][ODBC DRIVER MANAGER] SQL DATA TYPE OUT OF RANGE (0) (SQLBINDPARAMETER) WHEN RUNNING PYTHON SCRIPT PROBLEM DESCRIPTION: I am using Python script to access QuickBooks Data. I can select QuickBooks Data ...
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 OPTIMIZER WORKS PROBLEM DESCRIPTION: I am using QODBC to access QuickBooks Data. I am using optimizer & I want to know How Optimizer Works. SOLUTION: The optimizer brings some data to a local cache to increase query retrieval performance. Below ...
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 - MS ACCESS AND QUICKBOOKS FREEZE (NOT RESPONDING) WHEN ACCESSING THE FIRST TIME PROBLEM DESCRIPTION: When pushing data from the access database to QuickBooks, the QODBC message indicates waiting on QuickBooks, and both Access and Quick...
QODBC READ-ONLY TABLE LIST PROBLEM DESCRIPTION: I am using QODBC & trying to modify data in QuickBooks. In a few tables, I can't insert/update records. I am getting a "[QODBC] Not supported" error when inserting records. Also, I have noticed "Error ...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN CRYSTAL REPORT USING QODBC PROBLEM DESCRIPTION: How to Auto Add relationship Between two tables in Crystal Report using QODBC? SOLUTION: A relationship can be extracted using the ODBC function "SQLFo...
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...
MICROSOFT WINDOWS VISTA UPDATE ALERT AS OF DATE: 2007-03-29 For QuickBooks users within the USA With Microsoft's release of Windows Vista, we wanted to ensure that all our users are informed about using QuickBooks on Windows Vista. First and foremost,...
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 - 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 - 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...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE WITH QREMOTE PROBLEM DESCRIPTION: I am using QODBC to access QuickBooks Data. I have linked all QuickBooks tables using QRemote DSN. I want to use the Customer table to be Optimizer OF...
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...
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...
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 the "CREATE A NEW APP" button. Enter the app name and click the "Create" button. A New application in Qlik...
HOW TO AUTO ADD RELATIONSHIP BETWEEN TWO TABLES IN QLIKSENSE DESKTOP USING QODBC PROBLEM DESCRIPTION: How to Auto Add relationship Between two tables in QlikSense Desktop using QODBC? SOLUTION: Please create a new application in QlikSense Desktop & c...
TROUBLESHOOTING - HOW CAN I COMBINE TWO REPORTS AND GET A CUSTOMER'S TRANSACTIONS REPORT? PROBLEM DESCRIPTION: I need a report by a particular Customer showing the beginning balance, payments made by the Customer, invoices with details showing the expe...
TROUBLESHOOTING - HOW TO ADD QREMOTE TO STARTUP PROBLEM DESCRIPTION 1: How to add QRemote to ALL users Startups? SOLUTION 1: It would be best if you reinstalled QODBC for adding QRemoteServer to ALL user Startups. After installation of QODBC, QRem...
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 USE PROMPTED DATE RANGES IN MS EXCEL WITH SP_REPORTS PROBLEM DESCRIPTION: I am using QODBC for exporting QuickBooks reports in MS Excel. I am using the BalanceSheetStandard report for specific date ranges as below. sp_report ...
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....
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 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 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...
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 ...
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 - VEHICLEMILEAGE TABLE SHOWING DELETED RECORDS PROBLEM DESCRIPTION: I am using QODBC for working with QuickBooks. I can delete the VehicleMileage record. But After that, when I query the VehicleMileage table, it still shows deleted hist...
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...
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...