RSS Feed
Knowledgebase : Tutorials > Setup
     

QXL - QuickBooks Data Export Made Easy Limited Use Software License LICENSE: LICENSER grants to you a limited, non-exclusive license to (i) install and operate the copy of the computer program contained in this package ("Program") on a single computer...
[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...
HOW TO USE THE COMPUTER NAME INSTEAD OF IP ADDRESS IN QREMOTE? PROBLEM DESCRIPTION 1: When running a QRemote Server or a query, the IP address changes randomly. SOLUTIONS:  If you are using a 32-Bit QODBC manager, Please follow the below steps: Ope...
USING MS ACCESS APP 64-BIT AND 32-BIT (DIFFERENT MACHINES) WITH QODBC PROBLEM DESCRIPTION: My MS Access application links to QuickBooks tables via the QODBC ODBC driver. The 64-bit QODBC calls the ODBC connection 'Quickbooks Data 64-Bit QRemote'. So my ...
LOCATE PROGRAM AND SELECT OPTIMIZER TAB Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your desktop. Click on the ODBC DATA SOURCE icon to launch the setup program supplied with QODBC. Please refer to How to locate Configure QODBC Data ...
THE INPUT STRING WAS NOT IN A CORRECT FORMAT / THE INPUT STRING WAS NOT IN THE CORRECT FORMAT PROBLEM DESCRIPTION: I am running QXL and MS Office 365. I have tried exporting to XLSX, XLS, and even CSV format, but only the file header row writes. Als...
HOW TO DEACTIVATE QODBC ONLINE DEACTIVATE QODBC ONLINE FROM YOUR COMPUTER You can Deactivate QODBC Online license from: Start >> All Programs >> QODBC Driver for QuickBooks Online>> Configure QODBC Data Source Go To "System DSN" Tab>> Select "Qui...
[QXL DESKTOP] HOW TO EXPORT QUICKBOOKS DATA TO GOOGLE SHEETS USING QXL PROBLEM DESCRIPTION: How to export QuickBooks Data to Google Sheets using QXL SOLUTIONS:  Install the Google Drive desktop application and authorize it to connect to your Google D...
[QODBC DESKTOP] MISSING QODBC MENUS IN THE START MENU PROBLEM DESCRIPTION: Missing QODBC Menus in the start menu SOLUTIONS:  Navigate to the path: C:UsersAdministrator In the Administrator folder, you will see the below options. Switch to the 'Vi...
TROUBLESHOOTING: UNABLE TO CONNECT TO QUICKBOOKS USING QODBC. QODBC FREEZE, QODBC HANGS, QODBC STUCK DURING CONNECTION. PROBLEM DESCRIPTION 1: I have the latest driver version and no errors during installation. When I tried to connect, it just stuck "c...
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...
HOW TO USE QODBC SUPPORT WIZARD PROBLEM DESCRIPTION: How to use QODBC Support Wizard? SOLUTION: Please follow the below-listed steps for using QODBC Support Wizard. The "QODBC Support Wizard" application is included with QODBC v18.0.0.325 and above...
There is no performance difference between the QODBC Server Edition license and QODBC Read/Write license. There is no difference in the commands, queries, data, or schema between the QODBC Server Edition license and QODBC Read/Write license. QODBC is ...
QODBC ONLINE MENU ITEMS When you install QODBC Online below menu items are created under QODBC Driver for use with the QuickBooks Online folder in the start menu. 1. CONFIGURE QODBC ONLINE DATA SOURCE 64-BIT Configure QODBC Online Data Source 64-bit...
QODBC POS MENU ITEMS When you install QODBC POS below menu items are created under QODBC Driver for use with the QuickBooks POS folder in the start menu. 1. CONFIGURE QODBC POS DATA SOURCE 64-BIT Configure QODBC POS Data Source 64-bit option will he...
QODBC MENU ITEMS When you install QODBC, the below menu items are created under QODBC Driver for use with the QuickBooks folder in the start menu. 1. CONFIGURE QODBC DATA SOURCE 64-BIT CONFIGURE QODBC DATA SOURCE 64-BIT will help you to view/create/...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://support.flexquarters...
HOW TO IMPORT QUICKBOOKS DATA TO SQL SERVER DATABASE (LOCAL TABLE) First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer to How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://sup...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using the MS Excel application, please ensure you have installed the MS Off...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. UNABLE TO LOAD COMPONENT PROBLEM DESCRIPTION: I am trying to connect to QuickBooks Online using QODBC Online. But I am getting the below error at the time of connection. Please help me to resolve this error...
CONNECTING MULTIPLE QUICKBOOKS COMPANIES VIA EXCEL Download Sample [http://support.flexquarters.com/esupport/newimages/MultipleCompany/MultipleQBCompanyConnection.zip] There is a limitation with the QuickBooks SDK: it can connect only one company file ...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL PACKAGE PROBLEM DESCRIPTION: I am getting Error SOCKET Closed because of an abnormal package in the QRemote client. I am accessing QuickBooks Data from the remote machine over the inter...
USING ADODC AND ADODB WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/VB6/QODBCVB6.zip] ADODB WITH QODBC Open VB6, you can find it via Windows Start->All Programs->Microsoft Visual Studio 6.0 : Create a New Standard EX...
TROUBLESHOOTING - QXL 80040414 MODAL POPUP ERROR PROBLEM DESCRIPTION: I am trying to export data from QXL. But when I clicked on the QXL export button, I got the below error message. Unable to connect to QuickBooks. Popup window(s) in the QuickBooks...
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 - CHANGES TO THE INTEGRATED APPLICATION AUTHENTICATION FOR QUICKBOOKS Intuit is reinforcing existing security features that help protect QuickBooks customers' sensitive information. Refer: Intuit's News: Changes to the Integrated Applic...
TROUBLESHOOTING - QODBC INSTALLER ERROR WINDOWS CANNOT FIND EXPLORER.EXE. COULD NOT EXECUTE THE EXTERNAL PROGRAM PROBLEM DESCRIPTION: We downloaded the QODBC trial from your website. At the end of the installation process - after clicking the 'finish'...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where the SSIS package will be developed and deployed, or SSIS services are installed. Development - On the machine, you are developing, the SSIS package should have QODBC ...
[QODBC-ONLINE] TROUBLESHOOTING - QUICKBOOKS MESSAGE 653-UNAUTHORIZED - 401 - FAULT EXCEPTION OF TYPE: AUTHENTICATION HAS BEEN GENERATED. QB BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401 PROBLEM DESCRIPTION: I was able to use QODBC Online. Suddenly, I g...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - DSN CONNECTION NOT CONSISTENT ACROSS MULTIPLE COMPUTERS PROBLEM DESCRIPTION: I have a pass-through query for access: Select * from Item The connection string is as follows: ODBC;DRIVER={QODBC Driver for QuickBooks};SERVER=QODBC;DF...
TROUBLESHOOTING - QODBC LOGGING IN WITH THE WRONG USER ACCOUNT PROBLEM DESCRIPTION: I am using ms access. I have the integrated application certificate set up correctly (see screenshot). The username for this certificate is "odbc." QuickBooks is clos...
TROUBLESHOOTING - QUICKBOOKS DISPLAYS A REVOKED CERTIFICATE WARNING PROBLEM DESCRIPTION: I am trying to connect to QuickBooks using QODBC. At a time of connection, QuickBooks Displays a Revoked Certificate Warning. SOLUTION: Please update your QODBC...
HOW TO SHARE/INVITE THE FLEXQUARTERS SUPPORT TEAM TO THE QUICKBOOKS ONLINE COMPANY FILE PROBLEM DESCRIPTION: How do I share/invite the FLEXquarters Support team to access my QBO company file? SOLUTION: Please follow the below steps to share/invite ...
HOW TO USE QODBC WITH MICROSOFT EXCEL 2016 (64-BIT) FOR MS ACCESS 64-BIT, PLEASE REFER: HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2771] SETUP QODBC TO US...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT FOR 32-BIT, PLEASE REFER: TO HOW TO CONFIGURE QODBC TO WORK WITH 32-BIT MS ACCESS [HTTP://SUPPORT.FLEXQUARTERS.COM/ESUPPORT/INDEX.PHP?/DEFAULT/KNOWLEDGEBASE/ARTICLE/VIEW/2470]. CREATING A TABLE IN MICR...
TROUBLESHOOTING - QREMOTESERVER HANG-ON CONNECTION PROBLEM DESCRIPTION: I am trying to connect to QuickBooks/QuickBooks POS using QRemote Server, But QRemoteServer is Having on Connection. SOLUTION: Please check if QuickBooks Or QuickBooks POS has ...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE ARRAY BOUNDS." WHEN USING THE IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I recently installed QODBC to get data out of a QuickBooks company file, but I get this error: "Index was outs...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATIONS UNDER QUICKBOOKS POS Please follow the steps to remove QODBC Related Certificates from the Integrated Application Under QuickBooks POS: Try removing all the integrated application en...
TROUBLESHOOTING - UPGRADING TO QUICKBOOKS AND QODBC PROBLEM DESCRIPTION: I have a custom program written in Access 2003 communicating with QuickBooks 2013 using QODBC 13, which works fine. Will upgrade to the latest QuickBooks and QODBC require any co...
HOW TO USE QODBC WITH MS EXCEL POWER QUERY NOTE: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click wi...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code that reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV us...
HOW TO CREATE OR CONFIGURE A QODBC ONLINE DSN PROBLEM DESCRIPTION: I have one QuickBooks Online login, which provides access to multiple QuickBooks Online companies. When I initially configured the connection, I selected one of the clients to that I ...
HOW TO CONNECT TO QODBC USING PYTHON Download Sample [http://support.flexquarters.com/esupport/newimages/python/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: import pyodbc cn = pyodbc.connect('DSN=QuickBooks Data;') cursor = cn.cursor() cursor....
TROUBLESHOOTING - I CANNOT CONNECT TO MY QUICKBOOKS ONLINE SANDBOX PROBLEM DESCRIPTION: I am trying to do some testing and now have access to a QBO Sandbox company. I have tried to connect to it in two different ways. 1. If I "Connect to QuickBooks" ...
HOW TO CONNECT TO QUICKBOOKS ONLINE SANDBOX COMPANY FILE. For installation & configuring QODBC Online to work with QuickBooks Online live company file. Please refer: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flex...
TROUBLESHOOTING - QUICKBOOKS UI GETTING LAUNCHED AFTER UPDATING QODBC VERSION. PROBLEM DESCRIPTION: We recently upgraded from QODBC 14 to 16.00.00.313. It is functioning normally, except now the QuickBooks window is opening up when it didn't use to. I...
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 - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE PROBLEM DESCRIPTION: I cannot find or configure the 32-bit ODBC Data Source Manager under a 64-bit System. I will be happy to remote access you and my server representatives to resolve this....
PROBLEM DESCRIPTION: We keep getting the "QB Begin Session Failed" error when opening a QODBC connection on a web page. --> It happens when several users are using QuickBooks at the same time. --> When it happens, We try to use the 'QODBC Test Tool,' and...
HOW TO CONNECT TO MULTIPLE COMPANY FILES AT THE SAME TIME/SIMULTANEOUSLY PROBLEM: There are multiple company files in QuickBooks. At a time, I can access only one company file. Is QODBC allow me to access multiple company files same time? SOLUTION: T...
TROUBLESHOOTING - VISUAL STUDIO CONNECTION TO QODBC PROBLEM DESCRIPTION: I am getting the following message from Visual Studio 2015 when trying to connect to QRemote using the ODBC data source: "An error occurred while retrieving the information fro...
HOW TO USE QODBC WITH WINDOWS SCHEDULER /  HOW TO USE Z-CRON WITH QODBC / HOW TO RUN QODBC APPLICATIONS ON A REPEATING/NIGHTLY BASIS PROBLEM DESCRIPTION 1: My application needs to read data from QuickBooks and update data in the SQL server. Up to this, ...
TROUBLESHOOTING - QREMOTE DOES NOT WORK WITH IIS PROBLEM DESCRIPTION: We've been having steady success with QODBC for a good while. We're running QB on a VM and our custom application that queries it on another VM; both VMs are Server 2012. All was wel...
TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO 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...
TROUBLESHOOTING - QODBC AUTO-CONNECTING WITH THE WRONG USER PROBLEM DESCRIPTION: We have a few stations where we utilize the read-only QODBC desktop version. On a station we just built, it keeps using the wrong QuickBooks user for the auto-login. I conf...
TROUBLESHOOTING - HOW TO USE QODBC ON MAC OR LINUX PROBLEM DESCRIPTION: I have MAC Operating System & I want to use QODBC on it. Is it possible to use QODBC on MAC? I have Linux Operating System & I want to use QODBC on it. Is it possible to use QODBC...
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...
TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES PROBLEM DESCRIPTION: I want to upgrade my Operating System to Windows 10 and know if any precautions/actions are required for QODBC to keep working. SOLUTIONS: STEPS BEFORE UPGRADING T...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY FILE PROBLEM DESCRIPTION: I have a question about setting ODBC to auto-login. I am trying to automate some tasks and wanted to auto-login. We have two different company files for accoun...
TROUBLESHOOTING - HOW TO RE-LINK QUICKBOOKS DATA IN MS ACCESS USING QODBC PROBLEM DESCRIPTION 1: We are adding invoice records to QuickBooks using an Access front end. When we create the records and try to insert them into QuickBooks, the line items see...
TROUBLESHOOTING - HOW TO RECORD THE ISSUE I AM FACING AND SHOW/SHARE THE SCREEN. PROBLEM DESCRIPTION: How to record the issue I am facing and show/share the screen. SOLUTIONS: Please follow below steps for recording the issue you are facing. 1) Dow...
TROUBLESHOOTING - HOW TO IDENTIFY IF THE APPLICATION IS 32-BIT OR 64-BIT PROBLEM DESCRIPTION: How can I Identify if the application is 32-bit or 64-bit? SOLUTIONS:  SQL SERVER If your application is SQL Server, you can identify it by Starting your "...
CONFIGURE QODBC ONLINE FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC Online with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC Online driver and Jitterbit connection. These steps wor...
CONFIGURE QODBC POS FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC POS with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC POS driver and Jitterbit connection. These steps work for QOD...
CONFIGURE QODBC FOR USE WITH JITTERBIT COMMUNITY EDITION 3.0.0 (QREMOTE) To use QODBC with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC driver and Jitterbit connection. These steps work for QODBC with Jitt...
SETUP IN ALPHA FIVE CREATE A NEW WORKSPACE Start Alpha Five and create a new workspace. It could be called Online. adb - a holder for the entire application. Click the WORKSPACE & TASKS tab -> Click -> choose to CREATE A NEW, EMPTY WORKSPACE -> cl...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am excited about the prospects. I've installed it and can get the fields and tables to appear in QODBC TEST TOO...
HOW TO USE QODBC ONLINE WITH QLIKVIEW To use QlikView with QODBC Online, 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 "N...
TROUBLESHOOTING - QUICKBOOKS DATA DSN NOT SHOWING UP IN ODBCAD32.EXE ODBC DATA SOURCE ADMINISTRATOR IN WIN8 PROBLEM DESCRIPTION: I can't configure QuickBooks Data DSN from Configure QODBC Data Source window. When I click on QuickBooks Data, configure is...
TROUBLESHOOTING - APPLICATION CONNECTIVITY DELAY PROBLEM DESCRIPTION: I have an inventory control system (c#, SQL Server) that needs Read Only access to four tables in the accounting system. I have deployed your multiuser version and can access the loca...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO SERVER/QREMOTESERVER." PROBLEM DESCRIPTION 1: I have tested using QODBC Test Tool and the QRemote DSN test connection. I cannot connect to QRemote DSN. I am getting the below error: PROBLEM DESCRIPT...
TROUBLESHOOTING: QODBC SHOWS ERRORS 11118,11119,11120,11121,11122  PROBLEM: I am getting an error "11118 - SYSTEM LICENSE ERROR." I am getting an error "11119 - REGFILE1 LICENSE OPEN ERROR" I am getting an error "11120 - REGFILE1 LICENSE ERROR" I...
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 - GETTING MULTIPLE-STEP OLE DB OPERATION GENERATED ERRORS IN SQL SERVER PROBLEM DESCRIPTION: Trying to insert into SalesOrderLine and getting a 'Multiple-step' error. INSERT INTO QBREMOTE...SalesOrderLine (CustomerRefListID, TemplateR...
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 the below error message: "Wrong client Encyptkey settin...
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 DO I CHECK WHICH REGION OF QUICKBOOKS IS INSTALLED PROBLEM DESCRIPTION: How do I check which region of QuickBooks is installed? SOLUTION: You can query the Host table using QODBC Test Tool & get detail about your QuickBooks ver...
HOW TO USE QODBC WITH QUICKBOOKS ONLINE EDITION SETUP OF QODBC ONLINE: First, we need to install QODBC Online. QODBC Online requires .NET Framework 4.0 or a later version. So, you need to install .NET Framework 4.0 to work with QODBC Online. Please re...
TROUBLESHOOTING - HOW TO VERIFY IF THE OPTIMIZER FILE IS CORRUPTED OR NOT PROBLEM DESCRIPTION: Is there any way to figure out when the Optimizer cache is corrupted, or is there a way we can avoid it altogether in the future? SOLUTIONS: Please refer...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When ting sets QODBC POS DSN to access the company file running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for th...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE PROBLEM DESCRIPTION: How do I run QODBC as windows services in the background? I noticed it required QuickBooks and windows server 2008 to be logged on. SOLUTIONS: QODBC and QuickBooks are deskt...
Connecting QODBC Driver to QuickBooks for the First Time (Video) Go to: How to set up the QODBC Optimizer and Where are the Optimizer options [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358] for the next step. Yo...
TROUBLESHOOTING - MULTIPLE TABLES EXIST ERROR IN THE LINKED SERVER PROBLEM DESCRIPTION: I am trying to run a query using an SQL Server database link to QuickBooks using QRemote. I can set up the linked server fine in SQL Server, and the connection has b...
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 USE QODBC FOR DEVELOPMENT WITH VISUAL STUDIO PROBLEM DESCRIPTION: I am trying to use a demo file for development, but QODBC is not allowing me to do this now that the evaluation period on my development machine has expired. Are ...
TROUBLESHOOTING - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC PROBLEM DESCRIPTION: We use software called RemiCrystal to generate reports for emailing. The words have always worked fine using QB 2013 Pro and QODBC v14 (I think v14). Then we upg...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417 PROBLEM DESCRIPTION: When using your QODBC Driver with my custom application, coded in Java, the application can connect and retrieve data if QuickBooks is running with the company file already...
TROUBLESHOOTING: MS ACCESS AS MIDDLEWARE IS NOT WORKING WITH MS SQL SERVER PROBLEM DESCRIPTION: I am trying to use MS Access as a middleware with MS SQL Server. I have created an MS Access database & linked all QODBC tables through QRemote DSN. After t...
TROUBLESHOOTING - ERROR [42S00] [QODBC] INSERT VALUE MUST BE A SIMPLE VALUE PROBLEM DESCRIPTION 1: We have a customer trying to import a credit memo from our database into QuickBooks using a vb.net program. They are getting the following error: ERROR [4...
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...
TROUBLESHOOTING: HOW TO ACCESS ACCOUNT NAME DETAILS FROM JOURNAL REPORT USING SQL SERVER PROBLEM DESCRIPTION: I need some guidance on extracting data from the general ledger. In particular, I need to see the FullName of GL account. Running sp_report Jo...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT PROBLEM DESCRIPTION: How can I get a Quick Report on an account from the Chart of Accounts? In Quick Books 2006 Premier, I opened a chart of accounts (Ctrl+A), selected an account, and then pressed Ctrl+Q. S...
HOW TO REMOVE QREMOTE FROM STARTUP PROBLEM DESCRIPTION: QRemote Initialization Error. QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. SOLUTION: QRemote Server reports "Error: Listening failed. Please re...
TROUBLESHOOTING: QUICKBOOKS CAN'T START BECAUSE IT IS ALREADY RUNNING. PROBLEM DESCRIPTION 1: I cannot Connect my trial version of QODBC to QuickBooks. I have gone through your tutorials but am unable to connect. I have never had the "Keep QuickBooks ...
QODBC LICENSING INFORMATION  Also Refer: QODBC with QRemote Licensing Information [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/] Different types of licenses are required depending on your requirement in QODBC; pl...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with the QRemote driver, it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You may...
HOW TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: Any errors related to the driver and custom software or packaged software that does not work properly with QODBC.Example, Prepared Statements in JDBCODBCDriver. Sample Connection qbCo...
HOW CAN I USE THE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use the same Excel files in 64 & 32-bit Systems? Is it possible to have a connection setup in an Excel file and be able to refresh on either a 64 or 32-bit syst...
HOW TO REMOVE OPTIMIZER FILE WHAT IS THE OPTIMIZER FILE? When you turn on the Optimizer, QODBC will bring some data to a local cache file (the optimizer file) to increase retrieval performance for queries. When you access any table, QODBC will gather...
HOW TO SETUP QODBC TO RUN WITHOUT QUICKBOOKS PROBLEM DESCRIPTION * I want to use QODBC, which does not have the QuickBooks program on the machine. * Do I need QuickBooks installed on the machine to use QODBC? * Can QODBC read directly from QuickBo...
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...
DCOM / SERVER EDITION TAB MISSING IN QODBC SETUP SCREEN We recommend you use QRemote instead of DCom. This is because QRemote is easy to configure and works for 32 & 64-bit applications. For SQL Server 64-bit, Click Here "How to create Link Server with...
PROBLEM I am unable to Activate/Deactivate the currently installed version. I am logged in as Administrator, with admin rights, and right-clicking on the Setup and selecting "Run As Administrator" does not change the result. You do not have Sufficient...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC Also, refer to Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/] QODBC has the abi...
INSTALLATION STEPS FOR WINDOWS 8 After you have downloaded QODBC Installer, navigate to the "Downloads" Folder or the location where you have saved QODBC Installer. Run the installer as administrator by Right-clicking on the installer and selecting "Run...
ACTIVATING QODBC STILL SHOWS THE EVALUATION VERSION IN THE QODBC SETUP SCREEN.  If you have activated QODBC with a purchased license CDKey and get the "Activation Successful" message and then run an application trying to use QODBC, you get the message t...
How to Get QODBC to go with 64-bit Applications HOW TO CONFIGURE QODBC TO WORK WITH 64-BIT APPLICATIONS INSTRUCTIONS 64 and 32-bit words are kept separate in the Microsoft Windows Operating System. QuickBooks 2022 and above are 64-Bit applications and...
HOW TO SETUP QODBC IN WINDOW SERVER 2003 SP2 SYSTEM NOTE: QuickBooks is running on the server console. QODBC DCOM SETTING Make sure Server Edition Use DCOM Servers is checked. Also refer : DCom Option / Server Edition Tab missing in QODBC Setup T...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH SSIS PROBLEM DESCRIPTION We are using the QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar da...
This method is Discontinued. Please refer new product QODBC for QuickBooks Online: How to use QODBC Online with QuickBooks Online Edition (Apps.com) [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2658] How to Reconnect...
NOTE: DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU CAN USE QREMOTE. Please refer to the articles for more information: Web Server How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video) [https:/...
QODBC SETUP OPTIONS QODBC GENERAL SETUP The first step in configuring the driver is to click on the QODBC Setup Screen, and the following general setup screen will become available. USING THE COMPANY FILE THAT'S NOW OPEN IN QUICKBOOKS allows QODBC ...
WHERE ARE THE OPTIMIZER OPTIONS LOCATE QODBC OPTIMIZER Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your desktop. CLICK ON THE QODBC SETUP SCREEN icon to launch the setup program supplied with QODBC. The following general setup scree...
How QODBC and QuickBooks SDK work Intuit QuickBooks SDK inside the QuickBooks application uses XML format to read and write QuickBooks data. QODBC uses the QuickBooks SDK to talk to QuickBooks data. QODBC acts as a 'wrapper' around the Intuit SDK so cu...
SETUP WITH ODBCINST.INI FILE ADD OPTION INTO ODBCINST.INI FILE Add the TraceWithXML=Yes option line to your: FOR WINDOWS XP SYSTEM C:Documents and SettingsAll UsersApplication DataQODBC Driver For QuickBooksodbcinst.ini file FOR WINDOWS VISTA SY...
LAUNCH QODBC DATA SOURCE CONFIGURATION Locate the QODBC DRIVER FOR THE QUICKBOOKS program group on your desktop. Click on the CONFIGURE QODBC DATA SOURCE icon to create or configure a QODBC Data Source Name (DSN). CREATE A NEW DSN Click on the SYST...
HOW TO TURN ON THE TRACE LOG You can Turn on Detail Trace from Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source. Go To the "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure." Navigate to the...
METHOD FOR STARTING QODBC SETUP SCREEN OF A SPECIFIED DSN PASS DSN ON A COMMAND LINE   You can pass your DSN on a command line via: START -> RUN... -> Input: "C:Program FilesQODBC Driver for QuickBooksEditQDSN.exe" QODBC Auto-Login SETUP A DES...