Knowledgebase : Tutorials > Others
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 ...
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...
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 begin...
NOTE: DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU
CAN USE QREMOTE.
Please refer articles for more information:
How to configure QRemote
[http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2483]
H...
QODBC PERFORMANCE INSTRUCTION
QODBC is a very fast ODBC driver. The QuickBooks interface SDK, which
uses XML, is not the speediest file system available, but it does the
job. The QODBC driver works with all front-end applications which can
access ODBC, ...
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...
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...
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/21...
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 ABOUT USING 32-BIT ODBC DRIVER ON 64-...
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...
INSTRUCTIONS ABOUT ASPCOMPAT
Using QODBC on ASP.NET is slow when retrieving field values. "SELECT
* FROM Vendor" took ASP.NET to retrieve 3 to 5-second avg per record
or row. But switching to ASPCOMPAT="TRUE" will yield 45 to 60 records
per second. Retr...
HOW TO LOCATE LOG FILES OF QODBC FOR TROUBLESHOOTING
NOTE: The QODBC message, SDK message and Detail Trace Log file could
always help to quickly locate the issue of QODBC itself. Below is an
instruction on how to locate them for troubleshooting.
CLEAR ...
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 when trying
to access some specific tables, bo...
HOW TO FIND OPTIMIZER FILE
INSTRUCTIONS
When optimizer is on, QODBC will automatically create an opt file to
store the optimized data. When you reset QODBC optimizer, deleting the
opt file is required. But we have received some reports that opt files
ca...
PROBLEM DESCRIPTION
Fields related to Balances and QuantityOnHand is showing Null value or
is Missing Value, wherein QuickBooks is showing the correct
information.
e.g. When using below query with Optimizer On it does not show the
detail but when Optim...
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...
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 error like...
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 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...
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...
PROBLEM DESCRIPTION:
How can I trace the XML that is sent to/from QuickBooks by QODBC?
SOLUTION:
You can trace XML by following below steps:
1) Turn on Detail Trace from: Start >> All Programs >> QODBC Driver
for use with QuickBooks >> Configure QOD...
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 MS Excel file & click "Next".
4. Click "Next.
5. Save Qli...
TROUBLESHOOTING: UPDATE QUERY SCANNING ALL RECORDS IN LINKED SERVER
PROBLEM DESCRIPTION 1:
I am using MS SQL linked server with QRemote.
I am updating a single EstimateItemLine, passing Ref Number and
ItemFullName (also tried itemtxnlineid). Every time...
TROUBLESHOOTING - HOW TO GET ALT.EMAIL1,2 & CC EMAIL FIELDS FROM
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 Email ...
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 ADJUST VALUE OF A STOCK ITEM WITHOUT
ADJUSTING STOCK QUANTITY
PROBLEM DESCRIPTION:
Can I adjust the value of a stock item without adjusting the stock
quantity?
SOLUTIONS:
Yes, you can adjust the value of a stock item withou...
TROUBLESHOOTING - HOW TO TAKE SCREENSHOT
PROBLEM DESCRIPTION:
How do I take an error screenshot?
SOLUTIONS:
If you've got a problem with a program in Windows, you may be
wondering how to show the errors you're receiving. Luckily, taking a
screensho...
TROUBLESHOOTING - INVOICE REFNUMBER FAQ
PROBLEM DESCRIPTION:
I have invoice number (RefNumber) from my own table outside of
QuickBooks. But if QuickBooks user creates invoices directly in
QuickBooks then QuickBooks keeps new incrementing invoices
autom...
TROUBLESHOOTING - HOW TO SELECT RECORD WHEN VALUE IS NULL
PROBLEM DESCRIPTION:
I am trying to run a report which returns ItemInventory where
LastReceived is NULL I have tried in vain to accomplish this. My
question is what syntax do you use to select a...
HOW TO USE QXL
STEP 1 - DOWNLOAD QXL
If you haven't already downloaded QXL, do it now by going to the
download page [http://qxl1.com/qxl-for-quickbooks-desktop-downloads/].
Don't forget to read the "Readme" file during installation for the
latest infor...
TROUBLESHOOTING - GETTING "WRONG CLIENT ENCYPTKEY SETTING" ERROR
PROBLEM DESCRIPTION:
I'm trying to establish the connection to QuickBooks using QRemote
Server. But when I tried to connect I got below error message:
"Wrong client Encyptkey setting":
...
PROBLEM DESCRIPTION:
How to use parameter 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 = '19...
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 Order...
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...
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 Online...
TROUBLESHOOTING - SELECT STATEMENT IS NOT WORKING
PROBLEM DESCRIPTION:
I am evaluating the product. When I did this SQL Statement:
select * from Customer where ListId=557
I was getting a column not found the error. The QBO online
documentation says ...
TROUBLESHOOTING - AUTO LOGIN AS SERVICE AND SYNCING TABLES TO SQL
SERVER
PROBLEM DESCRIPTION:
So the QODBC works great running on the machine. We have the intent to
integrate into our website / Intranet to create customers or make
changes from the web...
TROUBLESHOOTING - [QODBC] INVALID OPERAND FOR OPERATOR:
PROBLEM DESCRIPTION:
I am getting the error "Invalid operand for operator: "
while trying to insert an invoice line item:
INSERT INTO InvoiceLine ( CustomerRefListID, T...
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...
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 or...
Hello,
If you downloaded The QODBC Desktop product between the dates of
October 7th and 9th, this urgent message may apply to you.
During the dates above a possible trojan infected version of the
software was uploaded to our hosting company and you ma...
TROUBLESHOOTING - HOW DO I UPDATE AN 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 an expired credit card details on your system? ...
[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
...
[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...
Help Desk Software by Kayako