RSS Feed
Knowledgebase : Tutorials > Setup
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...
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 "System DSN" Tab, Select "QuickBooks Data" DSN & click "Configure". Navigate to "Messag...
LAUNCH QODBC DATA SOURCE CONFIGURATION Locate the QODBC DRIVER FOR 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 SYSTEM D...
SETUP WITH ODBCINST.INI FILE ADD OPTION IN TO 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 S...
How QODBC and QuickBooks SDK works Intuit QuickBooks SDK inside of the QuickBooks application uses XML format for reading and writing QuickBooks data. QODBC uses the QuickBooks SDK to talk to QuickBooks data. QODBC acts as a 'wrapper' around the Intuit...
LOCATE PROGRAM AND SELECT OPTIMIZER TAB Locate the QODBC DRIVER FOR 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 screen will become availa...
WHERE ARE THE OPTIMIZER OPTIONS LOCATE QODBC OPTIMIZER Locate the QODBC DRIVER FOR 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 screen wi...
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. USE THE COMPANY FILE THAT’S NOW OPEN IN QUICKBOOKS allows QODBC to ...
NOTE: DCOM COMPONENT IS DEPRECATED. AS AN ALTERNATIVE TO DCOM, YOU CAN USE QREMOTE. Please refer articles for more information: Using QuickBooks data remotely via QODBC [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/...
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...
TROUBLESHOOTING: QUICKBOOKS DATA RETURN AS NULL(NVARCHAR ONLY) WITH SSIS PROBLEM DESCRIPTION We are using QODBC driver for connecting QuickBooks with SSIS. I can able to connect with QuickBooks through SSIS. But Quick books Ex: LIST ID) nvarchar data c...
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 Ta...
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 worlds are kept totally separate in the Microsoft Windows Operating System. QuickBooks is a 32-bit application, so in o...
ACTIVATING QODBC STILL SHOWS 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 to Purc...
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...
QREMOTE TUTORIAL: USING QUICKBOOKS DATA REMOTELY VIA QODBC Also refer: Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2517/] QODBC has the abilit...
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...
DCOM / SERVER EDITION TAB MISSING IN QODBC SETUP SCREEN We recommend you to 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 wi...
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 SETUP QODBC TO RUN WITHOUT QUICKBOOKS PROBLEM DESCRIPTION * I want to use QODBC and does not have QuickBooks program on the machine. * Do I need QuickBooks installed on the machine to use QODBC? * Can QODBC read directly from QuickBooks com...
HOW TO REMOVE OPTIMIZER FILE WHAT IS 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 dat...
HOW CAN I USE SAME EXCEL FILES IN 64 & 32-BIT SYSTEMS PROBLEM DESCRIPTION: How Can I use 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 system? I...
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 TO USE MS ACCESS AS MIDDLEWARE WITH QODBC PROBLEM DESCRIPTION: When using Prepared Statements with QRemote driver then it throws an error called ODBC driver not supported. How can I use Prepared Statements with QODBC/QRemote? SOLUTIONS: You may...
QODBC LICENSING INFORMATION  Also Refer: QODBC with QRemote Licensing Information [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2568/] There are different types of License required depends on your requirement in QODBC,...
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 unable to connect. I have never had the "Keep QuickBooks ru...
HOW TO REMOVE QREMOTE FROM STARTUP PROBLEM DESCRIPTION: QRemote Initialization Error. QRemote Error: Listening failed. Please restart application QRemote Closing in 15 Seconds. SOLUTION: There might be multiple instances of QRemoteServer.exe run...
TROUBLESHOOTING: QUICK REPORT ON AN ACCOUNT PROBLEM DESCRIPTION: How can I get a Quick Report on an account from Chart of Accounts? In Quick Books 2006 Premier, I opened chart of accounts (Ctrl+A) then selected an account and then pressed Ctrl+Q. SOLU...
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 the GL account. Running sp_repor...
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 - 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: 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 MS Access database & linked all QODBC tables through QRemote DSN, After that...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040417 PROBLEM DESCRIPTION: When using your QODBC Driver with my custom application, coded in Java, the application is able to connect and retrieve data if QuickBooks is running with the company file ...
TROUBLESHOOTING - SCHEDULED TASK JOB NOT WORKING AFTER UPGRADING QODBC PROBLEM DESCRIPTION: We use software called RemiCrystal to generate reports for emailing. The reports have always worked fine using QB 2013 Pro and QODBC v14 (I think v14). Then we u...
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 - 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 - MULTIPLE TABLES EXIST ERROR IN 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 been t...
Connecting QODBC Driver to QuickBooks for the First Time (Video) Go to: How to setup the QODBC Optimizer and Where are the Optimizer options [http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358] for the next step. You...
TROUBLESHOOTING - CAN QODBC / QREMOTE RUN AS A SERVICE PROBLEM DESCRIPTION: How do I run QODBC as windows services in the background? I notice it required QuickBooks to be logged and windows server 2008 to be logged on. SOLUTIONS: QODBC and QuickBoo...
QODBC POS COULD NOT ACCESS TO QUICKBOOKS POS COMPANY FILE PROBLEM DESCRIPTION: When set QODBC POS DSN to access the company file that is running in QuickBooks POS (Version 10), it will fail to connect to the company file. QuickBooks POS will search for ...
TROUBLESHOOTING - HOW TO VERIFY IF OPTIMIZER FILE CORRUPTED OR NOT PROBLEM DESCRIPTION: Is there any way to figure out when the Optimizer cache is corrupted or if there's a way we can avoid it altogether in the future? SOLUTIONS: Please refer below...
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 later version. So you need to install .Net Framework 4.0 to work with QODBC Online. Please refer...
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 Host table using VB Demo & get detail about your QuickBooks version. If y...
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": ...
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...
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: QODBC SHOWS ERROR 11118,11119,11120,11121,11122 PROBLEM: I am getting error \"11118 - SYSTEM LICENSE ERROR\" I am getting error \"11119 - REGFILE1 LICENSE OPEN ERROR\" I am getting error \"11120 - REGFILE1 LICENSE ERROR\" ...
TROUBLESHOOTING - QREMOTE ERROR "COULD NOT CONNECT TO SERVER/QREMOTESERVER" PROBLEM DESCRIPTION 1: I cannot connect to QRemote DSN. I have tested using VB Demo application as well as using QRemote DSN test connection. I am getting below error: PROBLEM...
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 get to the loca...
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...
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 MS Excel file & click "Next". 4. Click "Next"...
TROUBLESHOOTING - HOW TO USE QODBC ONLINE WITH FILEMAKER PROBLEM DESCRIPTION: I downloaded the trial version of your driver this morning and am really excited about the prospects. I've installed it and am able to get the fields and tables to appear in ...
SETUP IN ALPHA FIVE CREATE A NEW WORKSPACE Start Alpha Five and create a new workspace, it could be called Online.adb - it is a holder for the entire application. Click the WORKSPACE & TASKS tab -> Click -> choose CREATE A NEW, EMPTY WORKSPACE -> ...
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 Jitte...
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 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...
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, then you can identify it by Starting y...
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 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 into QB the line items seem to go but wh...
TROUBLESHOOTING - HOW TO USE QODBC WITH MULTIPLE QUICKBOOKS COMPANY FILE PROBLEM DESCRIPTION: I have a question about setting ODBC to auto login. We have two different company files for accounting purpose. I am trying to automate some of the tasks and I...
TROUBLESHOOTING - QODBC LICENSING ISSUES WITH WINDOWS 10 UPGRADES PROBLEM DESCRIPTION: I want to upgrade my Operating System to Windows 10 and want to know is there any precautions/actions required for QODBC to keep working. SOLUTIONS: STEPS BEFORE U...
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 - HOW TO USE QODBC ON MAC PROBLEM DESCRIPTION: I have MAC Operating System & I want to use QODBC on it. Is it possible to use QODBC on MAC? SOLUTIONS: Yes, you can use QODBC on MAC. But you have to load some tools to use it. You can ...
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 that we just built, it keeps to using the wrong QuickBooks user for the auto-login...
TROUBLESHOOTING - QODBC CONNECTION TO TALEND OPEN STUDIO PROBLEM DESCRIPTION: QuickBooks Enterprise comes with a tool called QODBC that enables connecting to a QB database to read and write data. I have installed it, and I can successfully see QB data ...
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...
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 read data from QuickBooks and update data in SQL server, up-to this I can ab...
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 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...
PROBLEM DESCRIPTION: We keep getting "QB Begin Session Failed" error when trying to open QODBC connection in a web page. --> It happens when there are several users using QuickBooks at the same time. --> When it happens, We tried to use the 'VB Demo' and...
TROUBLESHOOTING - HOW TO LOCATE CONFIGURE QODBC DATA SOURCE PROBLEM DESCRIPTION: I am unable to find or configure the 32-bit ODBC Data Source Manager under a 64-bit System. I will be more than happy to remote access to you and my server representativ...
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 - 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. In...
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 - 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 two different ways. 1. If I "Connect to QuickBooks" on th...
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....
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 that I hav...
HOW TO IMPORT DATA TO QUICKBOOKS THROUGH CSV USING QODBC NOTE: QODBC does not support direct import, But you can write VBA code which reads a CSV / Excel file & generates insert statements. There are two ways to Import data to QuickBooks through CSV u...
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...
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 upgrading to latest QuickBooks and QODBC require any code ...
HOW TO REMOVE QODBC RELATED CERTIFICATES FROM INTEGRATED APPLICATION UNDER QUICKBOOKS POS Please follow the steps to remove QODBC Related Certificates from Integrated Application Under QuickBooks POS: Try removing all the integrated application entries...
TROUBLESHOOTING - GETTING ERROR "INDEX WAS OUTSIDE THE BOUNDS OF THE ARRAY." WHEN USING IMPORT/EXPORT TOOL IN SQL SERVER PROBLEM DESCRIPTION 1: I just recently installed QODBC to try to get data out of a QuickBooks company file but I get this error: "...
TROUBLESHOOTING - QREMOTESERVER HANG ON CONNECTION PROBLEM DESCRIPTION: I am trying to connect to QuickBooks/QuickBooks POS using QRemote Server, But QRemoteServer is Hang on Connection. SOLUTION: Please check if QuickBooks Or QuickBooks POS is hav...
HOW TO USE QODBC WITH MICROSOFT ACCESS 2016 64-BIT FOR 32-BIT, PLEASE REFER: 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 MICROSOF...
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 SHARE/INVITE FLEXQUARTERS SUPPORT TEAM TO QUICKBOOKS ONLINE COMPANY FILE PROBLEM DESCRIPTION: How do I share/invite FLEXquarters Support team to access my QBO company file? SOLUTION: Please follow below steps to share/invite FLEXquarters Sup...
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...
TROUBLESHOOTING - QODBC LOGGING IN WITH 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 closed. ...
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...
SAMPLE CODE FOR C++ WITH QODBC #include #include #include #include #include #include #include #include using namespace std; void ConvertTimeStampStructToString(TIMEST...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR - UNAUTHORIZED-401 PROBLEM DESCRIPTION: I was able to use QODBC Online. Suddenly, I am getting below error when I tried to connect QBO using QODBC Online. It was working properly. No known changes to Wi...
HOW TO USE QODBC WITH SSIS Either QODBC or QRemote is required on the machine where SSIS package will be developed, deployed or SSIS services are installed. Development - On the machine, you are developing SSIS package - You should have QODBC install...
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'...
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 - 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...
TROUBLESHOOTING - QXL 80040414 MODAL POPUP ERROR PROBLEM DESCRIPTION: I am trying export data from QXL. But when I click on QXL export button I got below error message. Unable to connect to QuickBooks. Popup window(s) in the QuickBooks application M...
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 New Standard EXE ...
TROUBLESHOOTING - GETTING ERROR SOCKET CLOSED BECAUSE OF ABNORMAL PACKAGE PROBLEM DESCRIPTION: I am getting Error SOCKET Closed because of abnormal package in QRemote client. I am accessing QuickBooks Data from the remote machine over the internet (WA...
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 that it can connect only 1 company fil...
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 below error at the time of connection. Please help me to resolve this error. ...
EXCEL AUTOMATION - HOW TO OPEN, REFRESH AND CLOSE A COMPANY FILE Download Sample [http://support.flexquarters.com/esupport/newimages/ExcelAutomation/ExcelAutomation.zip] Before using MS Excel application, please make sure you have installed MS Office C...
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 How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://suppor...
ACCESSING QUICKBOOKS DATA REMOTELY VIA SQL SERVER First, you need to create Linked Server in SQL Server. For 32-bit SQL Server. Please refer How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote [http://support.flexquarters.co...
QODBC MENU ITEMS When you install QODBC below menu items are created under QODBC Driver for use with QuickBooks folder in start menu. 1. CONFIGURE QODBC DATA SOURCE 64-BIT CONFIGURE QODBC DATA SOURCE 64-BIT will help you to view/create/configure 64-...
QODBC POS MENU ITEMS When you install QODBC POS below menu items are created under QODBC Driver for use with QuickBooks POS folder in start menu. 1. CONFIGURE QODBC POS DATA SOURCE 64-BIT Configure QODBC POS Data Source 64-bit option will help you t...
QODBC ONLINE MENU ITEMS When you install QODBC Online below menu items are created under QODBC Driver for use with QuickBooks Online folder in start menu. 1. CONFIGURE QODBC ONLINE DATA SOURCE 64-BIT Configure QODBC Online Data Source 64-bit option ...
There is no performance difference between QODBC Server Edition license and QODBC Read/Write license. There is no difference in the commands, queries, data or schema between QODBC Server Edition license and QODBC Read/Write license. QODBC is a client-...
HOW TO USE QODBC SUPPORT WIZARD PROBLEM DESCRIPTION: How to use QODBC Support Wizard? SOLUTION: Please follow below-listed steps for using QODBC Support Wizard. "QODBC Support Wizard" application is included with QODBC v18.0.0.325 and above. In cas...
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...
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 try to connect, it just stuck "con...