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...
[QODBC-Desktop] Troubleshooting - Creating PO using Alpha Five basic scripting not working correctly
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...
Help Desk Software by Kayako