RSS Feed
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 VB Demo, I am facing the error : QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused SOLUTION: Please first keep QuickBooks runni...
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 SUBSCRIPTION OF QODBC DESKTOP DRIVER FOR QUICKBOOKS ONLINE PROBLEM DESCRIPTION: I want to cancel my QODBC Online monthly subscription. How to cancel the subscription of QODBC Desktop Driver for QuickBooks Online? SO...
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? M...