[QODBC-ALL] HOW TO USE POWERSHELL WITH QODBC TO UPDATE RECORDS ONE BY
ONE
Download Sample
[http://support.flexquarters.com/esupport/newimages/3098/UpdateAccountDescription-OneByOne.ps1]
SAMPLE CODE FOR USING QODBC DSN:
# Array of ListIDs to be updated...
[QODBC DESKTOP] - HOW TO USE QODBC WITH AVANQUEST BOOKKEEPER USING
BOOKKEEPER QUICKBOOKS INTEGRATOR.
PROBLEM DESCRIPTION:
I would like to use the new QuickBooks integrator module from
Bookkeeper to allow me to import data directly into Bookkeeper.
SOL...
[QODBC ALL] - TROUBLESHOOTING - UNABLE TO VERIFY LICENSE /
SUBSCRIPTION IS INACTIVE / LICENSE VERIFICATION IS REQUIRED
PROBLEM DESCRIPTION:
QODBC stopped working this morning, and I got a message that / License
verification is required. I opened License...
TROUBLESHOOTING - HOW TO FREE DISK SIZE MESSAGE
PROBLEM DESCRIPTION:
When I connect to QODBC, I am prompted to free disk space.
SOLUTION:
Please ensure you have 1 GB of free space in your primary drive where
your Windows Profile / Roaming Profile or...
TROUBLESHOOTING - DEFAULT VALUE OF WINDOWS USER ACCESS CONTROL (UAC).
PROBLEM DESCRIPTION:
What should be the Default Windows User Access Control (UAC)?
SOLUTION:
The QODBC Driver for QuickBooks runs differently under Microsoft
Vista/W7 than other ve...
TROUBLESHOOTING - HOW TO FIX DUPLICATE RECORDS IN THE QODBC TABLE.
PROBLEM DESCRIPTION:
I want to cancel my QODBC Driver for QuickBooks Desktop monthly
subscription.
How do I cancel the subscription to QODBC Driver for QuickBooks
Desktop?
SOLUTION:...
[QODBC ONLINE] HOW TO INSERT DATA INTO THE VENDORCREDIT TABLE
PROBLEM DESCRIPTION:
How to insert data into the VendorCredit table
SOLUTION:
Open the "QODBC Online Test tool" from the start menu.
Click on the "Connect" button.
Used the below SQL ...
[QODBC-DESKTOP] HOW TO USE QODBC WITH ALTERYX DESIGNER
PROBLEM DESCRIPTION:
I want to export the QuickBooks data using Alteryx Designer Studio?
How can I use Alteryx Designer with the QODBC?
SOLUTION:
Alteryx Designer Studio is a 64-Bit applicatio...
[QODBC-ONLINE] TROUBLESHOOTING - PARTIAL DATA/INCOMPLETE DATA IN
GENERALLEDGER REPORT - UNABLE TO FETCH ALL ROWS
PROBLEM DESCRIPTION:
I am fetching one year of data from the QuickBooks Online General
Ledger report using QODBC Online.
I get partial dat...
[QODBC-DESKTOP] - HOW TO RENAME SOME OF MY BULK ITEMS (I.E., INVENTORY
ITEMS) AND THEIR RELATED CHILD ITEMS (I.E., ASSEMBLIES)
PROBLEM DESCRIPTION:
I would like to rename some of my bulk items (i.e., inventory items)
and their related child items (i.e.,...
[QODBC-ALL] TROUBLESHOOTING - LOAD UPDATED DATA DID NOT COMPLETE (3)
PROBLEM DESCRIPTION
When I try to run the optimizer from the QODBC configuration screen, I
get the following error when I click "Load Updated Data":
Load Updated Data did not comp...
[QODBC-ALL] TROUBLESHOOTING - TRAPPABLE ERROR (E06D7363) OCCURRED IN
AN EXTERNAL OBJECT
PROBLEM DESCRIPTION
A trappable error (E06D7363) occurred in an external object. The
script cannot continue running.
I receive this error when reading and writin...
[QODBC-DESKTOP] - DO I REALLY NEED TO PURCHASE QUICKBOOKS TO DEVELOP A
ONE OFF APPLICATION FOR A CLIENT?
PROBLEM DESCRIPTION:
I need to develop a one-off application for a client.
I have their QuickBooks Desktop company file. Can I develop on that
dat...
[QODBC ALL] - HOW TO INCREASE THE UPDATE OR DELETE SQL STATEMENT
PERFORMANCE.
PROBLEM DESCRIPTION:
Ran this SQL to move an invoice from one Customer to another:
Update invoice set CustomerRefListID = '1500' where TxnNumber = 8453
It took about 15+ min...
HOW TO INTUIT OR QUICKBOOKS DEVELOPERS AND REPORT FIELDS NOT AVAILABLE
IN QUICKBOOKS SDK OR QUICKBOOKS ONLINE API
ISSUE:
We noticed a field or feature is not available in QuickBooks SDK or
QuickBooks API. How can I contact Intuit and request to add the...
[QODBC-ALL] TROUBLESHOOTING - UNABLE TO EXECUTE UPDATE STATEMENT WHEN
USING SQL SERVER 2019 LINKED SERVER ON WINDOWS 11 OR WINDOWS SERVER
2019
ISSUE:
We recently upgraded our Windows OS to Windows 11 and SQL Server to
2019.
We can connect from SQL Se...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - UNABLE TO CHANGE THE DEFAULT
CONFIGURATION OF NEWLY CREATED QODBC DSN - BUILD 348
ISSUE:
We created a new QODBC 32-Bit DSN with the name "QODBC-MyCompany.
The DSN was created successfully.
We tried to chang...
[QODBC ALL] WHAT DOES 'RED TEXT' IN THE QODBC DRIVER DIALOGS MEANS
PROBLEM DESCRIPTION:
What does 'Red text' in the QODBC driver dialogs means
SOLUTIONS:
Whenever you run any query for the first time, QODBC will first build
the optimizer.
Please r...
[QODBC ONLINE] - UNABLE TO USE QODBC ONLINE ON WINDOWS 7
PROBLEM DESCRIPTION:
Unable to use QODBC Online on Windows 7
Error - session Failed. 653 - There was an error while communicating
with the Ids Server. - - The Response Stream was null or empty
...
TROUBLESHOOTING - HOW DO I UPDATE EXPIRED CREDIT CARD INFORMATION ON
YOUR SYSTEM?
PROBLEM DESCRIPTION:
I am using QODBC Online & QXL Online, and I am using my credit card
for payment.
How do I update expired credit card details on your system? My car...
Hello,
If you downloaded The QODBC Desktop product between October 7th and
9th, this urgent message might apply to you.
During the dates above, a possible trojan-infected software version
was uploaded to our hosting company, and you may have gotten th...
HOW QODBC TALKS TO QUICKBOOKS SDK TO GET SAFE/ENCRYPTED/BALANCED DATA
FROM QUICKBOOKS, PREVENTING DATA CORRUPTION.
PROBLEM DESCRIPTION
* How does QODBC validates all the business logic which are part of
the QuickBooks application?
* Can QODBC read o...
TROUBLESHOOTING - HOW TO CANCEL THE SUBSCRIPTION OF QODBC DRIVER FOR
QUICKBOOKS ONLINE
PROBLEM DESCRIPTION:
I want to cancel my QODBC Driver for QuickBooks Online monthly
subscription.
How to cancel the subscription of QODBC Driver for QuickBooks Onl...
TROUBLESHOOTING - [QODBC] INVALID OPERAND FOR THE OPERATOR:
PROBLEM DESCRIPTION:
I am getting the error "Invalid operand for the operator:
" while trying to insert an invoice line item:
INSERT INTO InvoiceLine ( CustomerRefL...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL
SERVER
PROBLEM DESCRIPTION:
So the QODBC works excellently running on the machine. We intend to
integrate into our website / Intranet to create customers or make
changes from the web. I...
TROUBLESHOOTING - SELECT STATEMENT IS NOT WORKING.
PROBLEM DESCRIPTION:
I am evaluating the product. When I made this SQL Statement:
Select * from Customer where ListId=557
I was getting a column not found the error. The QBO online
documentation says...
CONNECTING QODBC ONLINE DRIVER TO QUICKBOOKS ONLINE FOR THE FIRST
TIME (VIDEO)
For system requirement details of QODBC Online, click here
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2816].
How to install QODBC Onlin...
DIFFERENCE BETWEEN QODBC FOR QUICKBOOKS DESKTOP AND ONLINE.
TABLE DIFFERENCES:
Number of Tables available in
QODBC DESKTOP
QODBC ONLINE
150
83
List of Tables available in QODBC Desktop
[http://doc.qodbc.com/qodbc/usa/TableList.php?catego...
TROUBLESHOOTING - QREMOTE DOES NOT CONSIDER FQSAVETOCACHE WITH WORKING
WITH ODBCCOMMAND & PARAMETERS
PROBLEM DESCRIPTION:
QRemote Does not consider FQSaveToCache with working with OdbcCommand
& Parameters.
I have an application that creates Sales Orde...
PROBLEM DESCRIPTION:
How to use parameters in OPENQUERY
SOLUTIONS:
OPENQUERY does not accept variables for its arguments. You need to
Pass Basic Values as below example:
SELECT QUERY:
DECLARE @TSQL VARCHAR(8000), @ID VARCHAR(25)
SELECT @ID = '1...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR
PROBLEM DESCRIPTION:
I'm trying to establish a connection to QuickBooks using QRemote
Server. But when I tried to connect, I got the below error message:
"Wrong client Encyptkey setting"...
HOW TO USE QXL
STEP 1 - DOWNLOAD QXL
If you haven't already downloaded QXL, go to the download page
[http://qxl1.com/qxl-for-quickbooks-desktop-downloads/] now. Don't
forget to read the "Readme" file during installation for the latest
information on QX...
TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE VALUE IS NULL
PROBLEM DESCRIPTION:
I am trying to run a report that returns ItemInventory where
LastReceived is NULL. I have tried in vain to accomplish this. What
syntax do you use to select a blank/nu...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ
PROBLEM DESCRIPTION:
I have the invoice number (RefNumber) from my table outside
QuickBooks. But if a QuickBooks user creates invoices directly in
QuickBooks, then QuickBooks keeps new incrementing invoices
autom...
TROUBLESHOOTING - HOW TO TAKE A SCREENSHOT
PROBLEM DESCRIPTION:
How do I take an error screenshot?
SOLUTIONS:
If you've got a problem with a Windows program, you may wonder how to
show the errors you're receiving. Luckily, taking a screenshot of yo...
TROUBLESHOOTING - HOW TO ADJUST THE VALUE OF A STOCK ITEM WITHOUT
CHANGING THE STOCK QUANTITY
PROBLEM DESCRIPTION:
Can I adjust the value of a stock item without changing the stock
quantity?
SOLUTIONS:
Yes, you can adjust the value of a stock item ...
TROUBLESHOOTING - MS ACCESS CRASHES HARD ON DATE QUERY
PROBLEM DESCRIPTION:
I've linked all the QODBC tables into an Access 2010 DB. I have
created table subset queries on the original tables and would like to
do selects based on date ranges - other thi...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM A THE
CUSTOMER TABLE
PROBLEM DESCRIPTION:
How do I access the alternate email address 1 and 2 and the cc email
fields? I don't see them at the customer table.
SOLUTIONS:
You can get CC ...
TROUBLESHOOTING: UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER
PROBLEM DESCRIPTION 1:
I am using an MS SQL-linked server with QRemote.
I am updating a single EstimateItemLine, passing Ref Number and
ItemFullName (I also tried itemtxnlineid). Every...
HOW TO USE QLIKVIEW WITH QODBC
To use QlikView with QODBC, please follow the below steps.
1. Open QlikView & Create the new file.
2. Select Data Source. Click on Browse.
3. Please select the MS Excel file & click "Next."
4. Click "Next.
5. Save...
PROBLEM DESCRIPTION:
How can I trace the XML sent to/from QuickBooks by QODBC?
SOLUTION:
You can trace XML by the below steps:
1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver
for use with QuickBooks >> Configure QODBC Data Source...
PROBLEM DESCRIPTION:
When trying to connect to QuickBooks using QODBC Test Tool, I am
facing the error :
QB Begin Session Failed. Error Calling OpenQBConnection Returned
Error: 10061 - [10061] Connection refused
SOLUTION:
Please first keep QuickBoo...
HOW TO INSERT OPENING BALANCE IN CUSTOMER TABLE USING QODBC
PROBLEM DESCRIPTION
Initially, I received the error "[QODBC] Field not allowed in insert"
when I tried to insert data into the Customer table through QODBC. I
was trying to insert customer d...
Accessing QuickBooks Data Remotely using QODBC & QRemote
Using QuickBooks data remotely via QODBC
FOR USING QREMOTE OVER THE INTERNET & WITH DYNAMIC IP (NON-STATIC-IP):
You can make sure of services like Dynamic DNS (DDNS or DynDNS). It is
a method o...
How to Run VB Script on 64-bit Operating System
INSTRUCTION:
When running the VB Script on the 64-bit system, if you directly run
the Script by double-clicking the vbs file, the system will run the VB
Script as 64-bit. Then QODBC will report an error l...
HOW TO VIEW QODBC DRIVER DIGITAL CERTIFICATE
QODBC Driver does have a digital certificate. To verify or know more
about Digital Certificate details, Please right-click on
fqqb32.dll/properties in the Windows>System 32/SysWow64 Directory.
Below are det...
PROBLEM DESCRIPTION
Fields related to Balances and QuantityOnHand show a Null or Missing
Value, whereas QuickBooks shows the correct information.
e.g., When using the below query with Optimizer On, it does not show
the detail, but when Optimizer is tur...
HOW TO FIND OPTIMIZER FILE
INSTRUCTIONS
When the optimizer is on, QODBC automatically creates an opt file to
store the optimized data. When you reset the QODBC optimizer, deleting
the opt file is required. But we have received some reports that opt
file...
Transaction or TimeTracking table is blank or not showing any data
TRANSACTION OR TIMETRACKING TABLE IS BLANK OR NOT SHOWING ANY DATA
INSTRUCTIONS
Sometimes you can successfully connect to QuickBooks, but the
QuickBooks Application shows no response w...
HOW TO LOCATE LOG FILES OF QODBC FOR TROUBLESHOOTING
NOTE: The QODBC message, SDK message, and Detail Trace Log file could
help locate the issue of QODBC itself quickly. Below is an instruction
on how to locate them for troubleshooting.
CLEAR ALL MESSA...
INSTRUCTIONS ABOUT ASPCOMPAT
Using QODBC on ASP.NET is slow when retrieving field values. "SELECT
* FROM Vendor" took ASP.NET to retrieve a 3 to 5-second avg per record
or row. But switching to ASPCOMPAT="TRUE" will yield 45 to 60 records
per second. Re...
ERROR CODE INFORMATION FOR QODBC
QUICKBOOKS ENTERPRISE USER EXPIRED MESSAGE? CLICK HERE
[HTTP://WWW.QODBC.COM/QODBCUPGRADES_FLEXQUARTERS90.HTML]
NOTE: Each qbXML response message called by QODBC can include three
status attributes: statusCode, st...
Vista/Windows 7 and 64-bit and QODBC
SYSTEM ENVIRONMENT
Operating system: Windows Vista / Windows 7 64-bit
Software: QODBC version 9.0.0.259 (32-bit)
QuickBooks Enterprise Solutions 9.0 (USA Version)
SUMMARY OF USING 32-BIT ODBC DRIVER ON 64-BIT...
IMPORTANT NOTE: To see how to install QODBC and connect to QuickBooks
for the first time using Microsoft Windows Vista, click here: How to
install QODBC in Windows XP/Vista
[http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2...
INSTRUCTIONS FOR ALPHA FIVE AND QODBC
Alpha Five is a preferred partner of FLEXquarters.com LLC, and the
Alpha Five software is an excellent choice for end users to develop
web and desktop applications based on the QODBC Driver for QuickBooks.
We belie...
SAMPLE CODE FOR ASP C# QODBC CONNECTION
STEPS TO CREATING CONNECTION IN C#
Try adding a new data source to your project by selecting DATA -> ADD
NEW DATA SOURCE -> Selecting Database -> Next Clicking on the NEW
CONNECTION... button -> Selecting Data S...
QODBC PERFORMANCE INSTRUCTION
QODBC is a high-speed ODBC driver. The QODBC driver works with all
front-end applications which can access ODBC, some of which are faster
than others. The QuickBooks interface SDK, which uses XML, is not the
speediest file ...
NOTE: DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU
CAN USE QREMOTE.
Please refer to the articles for more information:
How to configure QRemote
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2...
WHAT TO EXPECT WHEN USING THE QODBC DRIVER WITH CRYSTAL REPORTS
Your QuickBooks Company File (.qbw) is a flat-file database. Having
an ODBC driver will not change it to a relational database. For this
reason, relating more than several tables will sever...
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 SETUP USER PROMPTED DATE RANGES IN CRYSTAL REPORTS
DATE RANGE SETUP WITH CRYSTAL REPORTS X AND BEFORE
SETUP AS PARAMETERS DATEFROM AND DATETO
With Crystal Reports X version and before, just set up DateFrom and
DateTo parameters to be used in ...
Help Desk Software by Kayako