RSS Feed
Knowledgebase : QODBC
   

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...
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 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...
TROUBLESHOOTING - HOW TO APPLY PAYMENT TO MULTIPLE INVOICE PROBLEM DESCRIPTION: How can a payment be applied to multiple invoices? Scenario 1 - 3 Invoices are created. - A payment is received that covers 2 of the invoices, but not necessarily in ...
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 - EXCEL ONLY RETURNING AMOUNT_1 AND NOT AMOUNT_1 THROUGH AMOUNT_12. PROBLEM DESCRIPTION: I am working in Excel. I have set up three pass-through queries and had them work on referencing cells for DateFrom and DateTo parameters. The quer...
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 ...
TROUBLESHOOTING - SERIAL NUMBER/LOT NUMBER QUANTITY ON HAND DOES NOT MATCH THE QUICKBOOKS REPORT. PROBLEM DESCRIPTION: I recently ran into an issue when querying the inventory for each lot number. In QuickBooks, there is a report called "Lot Numbers in...
TROUBLESHOOTING - HOW WOULD I PRODUCE A TRANSACTION LIST THAT INCLUDES THE CLASS FIELD? PROBLEM DESCRIPTION: I am working on the transactions table but do not see a "class" field. How would I produce a transaction list that includes the class field? ...
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 if you reinstalled QODBC for adding QRemoteServer to ALL user Startups. After installation of QODBC, QRem...
TROUBLESHOOTING - HOW CAN I EXTRACT BUDGET DATA PROBLEM DESCRIPTION: I'm trying to extract QuickBooks budget data to SQL for reporting purposes. However, I don't see any tables that would hold the budget. My research is telling me this may not be possi...
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...
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...
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...
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...
TROUBLESHOOTING - WHERE ITEM SERIAL NUMBERS OR LOT NUMBERS ARE STORED PROBLEM DESCRIPTION: I'm having trouble finding where an Item's serial numbers are stored in the QuickBooks database. I have gone through your table schema online here http://doc.qod...
TROUBLESHOOTING - ERROR 3180 - THERE WAS AN ERROR WHEN SAVING A DATA EXTENSION NAMED ". "QUICKBOOKS ERROR MESSAGE: ATTRIBUTE WITH THE SPECIFIED NAME ALREADY EXISTS. PROBLEM DESCRIPTION: I am using QODBC for creating Invoices in QuickBooks. I am using C...
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 ...
QUICKBOOKS SPECIFICATIONS FOR MAXIMUM NUMBER OF RECORDS OR TRANSACTIONS AS OF DATE: 2007-07-25 QuickBooks can handle a maximum of 2 billion transactions. The maximum number of transactions is limited more by your computer's disk space and memory than ...
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,...
INTUIT ANNOUNCES QUICKBOOKS 2007 NEW FEATURES AND INTEGRATED SERVICES SOLVE SMALL BUSINESSES' MOST IMPORTANT PROBLEMS MOUNTAIN VIEW, Calif.--(BUSINESS WIRE)--Intuit Inc. (Nasdaq: INTU) today announced the availability of QuickBooks(R) 2007. The new li...
QUICKBOOKS SDK 6.0 FOR U.S. EDITIONS OF QUICKBOOKS 2007 AS OF DATE: 2006-07-13 QUICKBOOKS SDK 6.0 FEATURE LIST QuickBooks SDK 6.0, scheduled to be released in the fall of 2006, will include a number of new features requested by IDN member developers...
QUICKBOOKS SDK 5.0 FOR U.S. EDITIONS OF QUICKBOOKS 2006 AS OF DATE: 2006-07-13 QUICKBOOKS SDK 5.0 FEATURE LIST QuickBooks SDK 5.0, available to IDN members for download [https://developer.intuit.com/], includes a number of new features requested by ...
MICROSOFT WINDOWS VISTA, VERSIONS OF QUICKBOOKS BEFORE 2007, AND QODBC AS OF DATE: 2006-12-16 IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks for the first time using Microsoft Vista, click here: How do I install and connect QODB...
QUICKBOOKS SDK 4.0 FOR U.S. EDITIONS OF QUICKBOOKS 2005 QUICKBOOKS SDK 4.0 FEATURE LIST QuickBooks SDK 4.0 includes a number of new features requested by IDN member developers. Of course, SDK 4.0 also supports all parts of our previous versions of the...
TROUBLESHOOTING - HOW CAN I ADD A LINE TO AN EXISTING CHECK PROBLEM DESCRIPTION: Is it possible to add a line to a check that already exists? Here is an example from the QB Sample file. Below is a check for $500.00 Now I want to add additional item...
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 - HOW CAN I ACCESS ONLINE BANKING ALIASES USING QODBC PROBLEM DESCRIPTION: Does anybody know which table the Online Banking Aliases data is stored in QuickBooks? To see what I'm talking about, go to the "Additional Info" tab of the "E...
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 - HOW TO LOCATE EMPLOYEE EMERGENCY CONTACT INFORMATION USING QODBC PROBLEM DESCRIPTION: Is it possible to retrieve an employee's emergency contact information? If so, from what table? SOLUTION: Employee Emergency Contact Information ...
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 - HOW TO RECEIVE INVENTORY WITHOUT PURCHASE ORDERS PROBLEM DESCRIPTION: Is it possible to register an item's arrival without the purchase order? If yes, can I insert the rows in the "ItemReceiptItemLine" table using the reference to B...
TROUBLESHOOTING - DOES SP_REPORT SUPPORT LIKE QUERY PROBLEM DESCRIPTION 1: Does sp_report support "Like" in the parameter? For example, sp_report CustomTxnDetail shows Text, Blank, TxnType, Date, RefNumber, Name, Memo, Account, ClearedStatus, SplitAc...
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...
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 ...
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...
TROUBLESHOOTING - HOW TO FIND AN ESTIMATE FOR INVOICE CONVERSION TIME PROBLEM DESCRIPTION: I am using MS Excel to access QuickBooks Data through QODBC. I have Estimate & some of the Estimates are converted to QuickBooks. I want to know how many Estimat...
TROUBLESHOOTING - WHO CREATED AN INVOICE/SALESORDER PROBLEM DESCRIPTION: We don't have an operational problem, just a SQL/technical question -- we are currently pulling invoices like this: SELECT * FROM Invoice WHERE RefNumber ='221206' (works great)...
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...
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 ...
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...
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 di...
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 - 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...
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 - QODBC CUSTOMSUMMARY REPORT IS NOT RECONCILING WITH QUICKBOOKS CUSTOMSUMMARY. PROBLEM DESCRIPTION: I am running the QODBC report "CustomSummary" and comparing it to what should be the identical report in QuickBooks. I am encountering ...
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 need to export to Access...
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 Reports. The attached invoice is similar to what we need to export to Crystal R...
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 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...
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 - 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 tried to open the ItemAssembliesCanBuild...
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...
TROUBLESHOOTING - HOW TO FIND AN ITEM NOT SOLD AFTER A SPECIFIC DATE AND MARK IT INACTIVE. PROBLEM DESCRIPTION: We would wish to inactive items that have not sold after a certain date. Is this possible? If so, any help would be appreciated. SOLUTION: ...
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 by...
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 - HOW DO I GET THE 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...
TROUBLESHOOTING - CANNOT LOAD CUSTOMER TABLE RECORDS. PROBLEM DESCRIPTION: I am trying to query the Customer table. The Title Bar of the Access Application says Not responding. Still, it never opens for me in the datasheet view, either double-clicking t...
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 - 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 r...
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 A...
TROUBLESHOOTING - UPDATE QUERY OPTIMIZATION. PROBLEM DESCRIPTION: Can you give me some insights on optimizing an update query to the PriceLevelPerItem table? I am trying to update all of my existing price levels, and I'm looping through each inventory ...
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...
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 the below steps: 1. Click START -> ALL PROGR...
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 - GETTING ERROR [QODBC] REQUIRES AT LEAST ONE CHILD. I CANNOT DELETE THE LAST LINE PROBLEM DESCRIPTION: I entered a series of purchase orders with queries that look like this: INSERT INTO PurchaseOrderLine ("VendorRefListID", "RefNumb...
TROUBLESHOOTING - VB DEMO IS CRASHING WHEN USING THE NON-EXISTING COLUMN NAME IN THE LEFT OUTER JOIN QUERY NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Kn...
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 can create the credit memo. However, when attempting to add the refund us...
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 addresses customers. I have tried to execute the que...
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...
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.Tx...
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 to Save a SalesOrder with three SalesOrderLine, re...
TROUBLESHOOTING - CHECK THE ISTOBEPRINTED UPDATE QUERY PROBLEM DESCRIPTION: I'm having a problem running this SQL statement in QODBC TEST TOOL. The application returns an error message: [QODBC] Not supported. UPDATE Check SET IsToBePrinted = 1 WHERE ...
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 two closing entries. In the account tabl...
TROUBLESHOOTING - HOW TO INSERT UPDATE PAYROLLITEMNONWAGE LIKE AUTO ALLOWANCE, BENEFITS, FEDERAL INCOME, ETC PROBLEM DESCRIPTION: How can we update the Insert PayrollItemNonWage field as Auto Allowance, Benefits, Federal Income, etc.? Suppose we add,...
TROUBLESHOOTING - EASIEST WAY TO MAKE A REPORT SHOWING THE AVERAGE TIME BETWEEN RECEIPT AND INVOICE OF THE ITEM PROBLEM DESCRIPTION: I want to make a report to show me which items are selling quickly and slowly. I figure I need to look at the length of...
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 - 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 previously used QODBC to t...
TROUBLESHOOTING - CREATING PO USING ALPHA FIVE BASIC SCRIPTING IS NOT WORKING CORRECTLY PROBLEM DESCRIPTION: I am using Alpha 5 version 10.5 basic scripting to export our data to QB Enterprise 2016. I have successfully exported our customer and inven...
TROUBLESHOOTING - HOW TO CREATE PRICELEVELPERITEM & PRICELEVELFIXEDPERCENTAGE USING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (...
HOW TO INSERT A SALESORDERLINE ITEM INTO AN EXISTING SALESORDER PROBLEM DESCRIPTION: I routinely create new sales orders with queries similar to this: INSERT INTO SalesOrderLine ("CustomerRefListID," "RefNumber," "SalesOrderLineItemRefListID," "Sales...
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...
TROUBLESHOOTING - HOW CAN WE SELECT INVOICES FOR PAYMENT FROM THE 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 resp...
TROUBLESHOOTING - HOW TO ENABLE DETAIL ROWS FOR BALANCESHEETDETAIL, GENERALLEDGER, JOURNAL, PROFITANDLOSSDETAIL, TXNDETAILBYACCOUNT REPORTS PROBLEM DESCRIPTION: I am executing BalanceSheetDetail, GeneralLedger, Journal, ProfitAndLossDetail, and TxnDe...
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 haven't installed zip...
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...
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...
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 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...