RSS Feed
Knowledgebase : QODBC
   

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...
TROUBLESHOOTING - HOW DO I KNOW WHICH VERSION OF QUICKBOOKS MY QODBC LICENSE WORKS WITH? PROBLEM DESCRIPTION: How do I know which version of QuickBooks my QODBC license works with? SOLUTION: To find out which version of QuickBooks with your QODBC l...
QODBC QUICK START GUIDE Download : QODBC 2017 Quick Start Guide [http://qodbc.com/download/builds/319/QODBC%202017%20Quick%20Start%20Guide.pdf] (PDF) QODBC DRIVER LICENSE AGREEMENT [HTTP://WWW.QODBC.COM/LINKS/2479.HTM] INTRODUCTION WHAT IS ODBC? ...
TROUBLESHOOTING - MS ACCESS DISPLAYS "#DELETED" IN EVERY FIELD PROBLEM DESCRIPTION: Using QuickBooks Accountant, QODBC and MS Access Linked table. Sometimes, e.g. at present working with the InventoryAdjustment table, a table view or query returns t...
TROUBLESHOOTING - HOW TO ZIP AND UPLOAD THE COMPANY FILE PROBLEM DESCRIPTION: How to zip and upload the company file on http://qodbc.com/send SOLUTION: Please download [http://www.7-zip.org/download.html] & install 7-zip if you don't have any zip so...
TROUBLESHOOTING - HOW TO ENABLE DETAIL ROWS FOR BALANCESHEETDETAIL, GENERALLEDGER, JOURNAL, PROFITANDLOSSDETAIL, TXNDETAILBYACCOUNT REPORTS PROBLEM DESCRIPTION: I am executing BalanceSheetDetail, GeneralLedger, Journal, ProfitAndLossDetail, TxnDetail...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM BILLTOPAY TABLE USING QODBC PROBLEM DESCRIPTION: In the BillToPay Table - How can we select invoices for payment using QODBC? We would like to have the Checkmark Selected for the respect...
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 linked table in MS Access. I am able to link ReceivePaymentToDeposit ta...
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...
HOW TO INSERT SALESORDERLINE ITEM TO AN EXISTING SALESORDER PROBLEM DESCRIPTION: I routinely create new sales orders with queries similar to this: INSERT INTO SalesOrderLine ( "CustomerRefListID", "RefNumber", "SalesOrderLineItemRefListID", "SalesOrd...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM & PRICELEVELFIXEDPERCENTAGEUSING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (a...
TROUBLESHOOTING - CREATING PO USING ALPHA FIVE BASIC SCRIPTING NOT WORKING CORRECTLY PROBLEM DESCRIPTION: I am using Alpha 5 version 10.5 xbasic scripting to export our data to QB Enterprise 2016. I have successfully exported our customer and invento...
TROUBLESHOOTING - CREDITCARDINFOCREDITCARDNUMBER RETURNS ******1234 PROBLEM DESCRIPTION: This used to work and I have no idea why it now blinds all reads of the CreditCardInfoCreditCardNumber field in the Customer table. I had used QODBC previously t...
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 - EASIEST WAY TO MAKE REPORT SHOWING AVERAGE TIME BETWEEN RECEIPT AND INVOICE OF ITEM PROBLEM DESCRIPTION: TI'd like to make a report to show me which items are selling quickly, and which are selling slowly. I figure the thing I need to...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO ALLOWANCE,BENEFITS,FEDERAL INCOME ETC PROBLEM DESCRIPTION: How we can update Insert PayrollItemNonWage field as Auto Allowance,Benefits,Federal Income etc. if we add,Item Name -- Amo...
TROUBLESHOOTING - WHERE IS RETAINED EARNINGS DATA FOUND? PROBLEM DESCRIPTION: I cannot find a table with the retained earnings listed in it. Furthermore, I find no transactions for this account, yet QB reports 2 closing entries? In the account table,...
TROUBLESHOOTING - CHECK ISTOBEPRINTED UPDATE QUERY PROBLEM DESCRIPTION: I'm having the problem running this SQL statement in VB Demo. The application returns an error message: [QODBC] Not supported. UPDATE Check SET IsToBePrinted = 1 WHERE TxnID = 'B...
TROUBLESHOOTING - ERROR 3180 - THE CREDIT LIMIT FOR THE NAME ON THIS TRANSACTION HAS BEEN EXCEEDED PROBLEM DESCRIPTION: We use QOBDC Read Write 8.00.00.234 With QuickBooks Enterprise 2007. When trying Save a SalesOrder with three SalesOrderLine retur...
TROUBLESHOOTING - DOES QODBC SUPPORT "LIKE 'I%'"? PROBLEM DESCRIPTION: How should the following SQL query be written to work with QODBC, using the "like" filter to restrict records? SELECT Sales.RefNumber,Sales.BillAddressAddr1,Sales.Type,Sales.TxnDa...
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 IN 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:...
TROUBLESHOOTING - UNABLE TO LOAD ALL CUSTOMER RECORDS DUE TO CUSTOMERSHIPPINGADDRESS PROBLEM DESCRIPTION: I am unable to load all customer records through QODBC. I have a large number of ship to address of Customers. I have tried to execute the qu...
TROUBLESHOOTING - REFUNDING CREDIT CARDS - THERE WAS AN ERROR WHEN PARSING THE PROVIDED XML FILE. PROBLEM DESCRIPTION: Hello I am trying to refund CC payments in QuickBooks. I am able to create the credit memo, however when attempting to add the refu...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING NONEXISTING COLUMN NAME IN LEFT OUTER JOIN QUERY PROBLEM DESCRIPTION: I am executing below query in VB Demo. But VB Demo is crashing at the time of execution. I have checked the same query in MS Access ...
TROUBLESHOOTING - GETTING ERROR [QODBC] REQUIRES AT LEAST ONE CHILD. CANNOT DELETE LAST LINE PROBLEM DESCRIPTION: I entered a series of purchase orders with queries that look like this: INSERT INTO PurchaseOrderLine ("VendorRefListID", "RefNumber","P...
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 - HOW TO TELL WHAT VERSION OF QODBC I AM USING PROBLEM DESCRIPTION: How to tell what version of QODBC I am using? SOLUTION: To find out which version of QODBC you are using please follow below steps: 1. Click START -> ALL PROGRAMS -...
TROUBLESHOOTING - GETTING ERROR INVALID AUTHORIZATION SPECIFICATION IN SQL SERVER. PROBLEM DESCRIPTION: I am trying to create Linked Server in SQL Server. VB DEMO connects successfully to QREMOTE on QuickBooks Server. Setting up Linked server - I get...
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 - UPDATE QUERY OPTIMIZATION. PROBLEM DESCRIPTION: Can you give me some insights on how to optimize an update query to the PriceLevelPerItem table? I am trying to update all of my existing pricelevels and I'm looping through each invento...
TROUBLESHOOTING - RUNTIME ERROR (28) WHEN USING WINDOWS XP, BUT NOT WINDOWS 2000. PROBLEM DESCRIPTION: We have four machines using the ODBC driver with Quickbooks and Access 2003 that work perfectly fine. The odd machine is a slightly higher version of ...
TROUBLESHOOTING - HOW DO I RUN A COLLECTIONS REPORT? PROBLEM DESCRIPTION: How do I run a Collections Report? SOLUTION: A typical Collections Report in QuickBooks looks like this: With QODBC the same report can be generated using stored procedure re...
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 can not get QReportBuilder to refresh data. The error is Error message: Could not crea...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS PROBLEM DESCRIPTION: I am trying query Customer table but it never opens for me in datasheet view either by double clicking the table or running a query - no error message is ever returned but the scr...
TROUBLESHOOTING - HOW DO I GET COMPANY BUSINESS NUMBER PROBLEM DESCRIPTION: In QuickBooks enterprise, the company information form shows me the company's business#. In a custom report, the field is displayed as blank. In VBDEMO, the field shows as bla...
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 - IS THERE A SALES JOURNAL REPORT BY CLASS PROBLEM DESCRIPTION: For months I've been trying to get a Sales journal report. All I seem to get is either too detailed (by items), or too summary (sum by customer). I need a list of invoices b...
TROUBLESHOOTING - HOW TO FIND ITEM NOT SOLD AFTER A CERTAIN DATE AND MARK IT AS INACTIVE. PROBLEM DESCRIPTION: We would wish to make items that have not sold after a certain date inactive. Is this possible? If so, any help would be appreciated. SOLUTI...
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 mult...
TROUBLESHOOTING - ERROR 3120 - OBJECT X SPECIFIED IN THE REQUEST CANNOT BE FOUND. PROBLEM DESCRIPTION: I could link all tables to an MS Access DB from QuickBooks Database. But I got the following error when I try to open ItemAssembliesCanBuild table...
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...
TROUBLESHOOTING - HOW TO RUN PROFITANDLOSSBUDGETOVERVIEW BY CLASS REPORT TYPICAL PROFIT & LOSS BUDGET OVERVIEW BY CLASS REPORT (FOR THE CURRENT FISCAL YEAR TO DATE) IN QUICKBOOKS NOTE: The QuickBooks Sample files set the QuickBooks date to December 15...
SAMPLE VB.NET SOURCE CODE FOR INSERTING INVOICELINE TO 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 belo...
SAMPLE VB.NET WEB APPLICATION FOR INSERTING INVOICELINE TO 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 downlo...
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 CRYSTAL REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into Crystal Report? The attached invoice is similar to what we are needing to export to Cry...
HOW TO EXPORT QUICKBOOKS INVOICES INTO MS ACCESS REPORT FORMAT PROBLEM DESCRIPTION: I would like to know if QODBC will convert QuickBooks Pro Desktop invoices into Microsoft Access? The attached invoice is similar to what we are needing to export to...
TROUBLESHOOTING - QODBC CUSTOMSUMMARY REPORT NOT RECONCILING WITH QUICKBOOKS CUSTOMSUMMARY. PROBLEM DESCRIPTION: I am running the QODBC report "CustomSummary" and comparing to what should be the identical report in QuickBooks and I am encountering an ...
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 are needing to export to M...
TROUBLESHOOTING - HOW TO ADD MULTIPLE FILTER ON PARAMETER IN SP_REPORT PROBLEM DESCRIPTION: I am using sp_report through QODBC & I have noticed that using QuickBooks UI we can add multiple TxnFilterTypes like 'Invoice', 'CreditMemo' and 'SalesReciept' ...
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 ...
TROUBLESHOOTING - "TRANSACTIONS" TABLE, BUT THEY DON'T APPEAR TO "BALANCE" PROBLEM DESCRIPTION: I am attempting to extract data from a client's hosted QuickBooks Enterprise system. I need every transaction in the system as we are transitioning to a dif...
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...
HOW OPTIMIZER WORKS PROBLEM DESCRIPTION: I am using QODBC access QuickBooks Data. I am using Optimizer & I want to know about How Optimizer Works. SOLUTION: The Optimizer brings some data to a local cache to increase retrieval performance for querie...
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...