RSS Feed
Knowledgebase : QODBC > Database & Company File
     

HOW TO EXPORT TO ORACLE PROBLEM DESCRIPTION: I am using QXL & I want to export QuickBooks Data to Oracle. How can I export QuickBooks Data to Oracle using QXL? SOLUTION: You can export QuickBooks Data to Oracle using QXL. First, You need to cre...
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 - 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 - 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 - [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 - 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 - 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 - 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 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 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 - 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 - 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 - 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...