RSS Feed
Knowledgebase : QODBC > Database & Company File
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 - 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 ...
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 & PRICELEVELFIXEDPERCENTAGE USING QODBC PROBLEM DESCRIPTION: How to create PriceLevelPerItem & PriceLevelFixedPercentage using QODBC. SOLUTION: To create a new PriceLevel and PriceLevelPerItem item (...
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...
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 to Save a SalesOrder with three SalesOrderLine ret...
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 - 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:...
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 - CANNOT LOAD CUSTOMER TABLE RECORDS PROBLEM DESCRIPTION: I am trying to query Customer table but it never opens for me in datasheet view either double-clicking the table or running a query - no error message is ever returned but the scr...
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 - 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 - 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...
USING OPTIMIZER OFF FOR SELECTED TABLES IN MS-ACCESS LINKED TABLE WITH QREMOTE PROBLEM DESCRIPTION: I am using QODBC access QuickBooks Data. I have linked all QuickBooks tables using QRemote DSN. I want to use Customer table to be Optimizer OFF and r...
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 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...