RSS Feed
Knowledgebase : TroubleShooting > Setup
TROUBLESHOOTING: WAITING ALL DAY FOR A QUERY PROBLEM DESCRIPTION I wrote a process that would retrieve RefNumber from QuickBooks Invoices and save them to an external reporting system. It was working just fine, taking on average 2 seconds per record to...
TROUBLESHOOTING: QB OPEN CONNECTION FAILED. ERROR = 8004042F PROBLEM DESCRIPTION When trying to connect to Australian QuickBooks file (version 2007/08 trial) and getting the following error. Test Connection to QuickBooks Failed. [QODBC] QB OPEN C...
TROUBLESHOOTING: IDENTITY IS INCORRECT AND CREATE DCOM INSTANCE ERROR = 8000401A PROBLEM DESCRIPTION 1 When using link server, get the following errors: SQLSetConnectAttr failed QB Open Connection Failed. Create DCOM Instance Error = 8000401A, Unk...
TROUBLESHOOTING: ERROR [00000] [QODBC] QB BEGIN SESSION FAILED. ERROR = 80040414 PROBLEM DESCRIPTION The QODBC program used to work well so far but now I get following error: ERROR [00000] [QODBC] QB Begin Session Failed. Error = 80040414, A modal dia...
TROUBLESHOOTING: BEGIN SESSION FAILED. ERROR = 8004041D, 80040418, 8004041A, 80040430 PROBLEM DESCRIPTION: Get the following errors from QODBC driver: ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041d,80040418 This application is not a...
TROUBLESHOOTING: QB BEGIN SESSION FAILED. ERROR = 8004041C PROBLEM DESCRIPTION When I run a report in my Java file using QODBC to connect to QuickBooks I get the following error: java.sql.SQLException: [QODBC] QB Begin Session Failed. Error = 80040...
TROUBLESHOOTING: LOAD UPDATED DATA DID NOT COMPLETE (3) AND RELOAD ALL DATA DID NOT COMPLETE (3) PROBLEM DESCRIPTION Sometimes you get the following error by clicking LOAD UPDATED DATA or RELOAD ALL DATA when you try to run the optimizer from the QODB...
TROUBLESHOOTING: SDK MESSAGES LOG ERROR 3260 - INSUFFICIENT PERMISSION LEVEL TO PERFORM THIS ACTION PROBLEM DESCRIPTION If QODBC attempts an operation where the QuickBooks logged in user doesn't have the correct permissions, you will receive the status...
TROUBLESHOOTING: CREATING OPTIMIZE TABLE FAILED PROBLEM DESCRIPTION Can query from VBDemo, but when trying to run a full sync on any table get the message below: "CREATING OPTIMIZE TABLE FAILED" SOLUTIONS You must have full create/read/write per...
TROUBLESHOOTING: CREATE DCOM INSTANCE ERROR = 80070005 PROBLEM DESCRIPTION All worked fine on QuickBooks and QODBC version 9, integrated to a web shipping system that is all hosted on XP PC. After upgrade both QuickBooks and QODBC to version 10, got th...
TROUBLESHOOTING: FIRST TIME OPTIMIZER RUNS "WAITING ON QUICKBOOKS" FOR A LONG TIME PROBLEM DESCRIPTION I am using QODBC with RDS server. I have 1 workstation that runs the optimizer and queries just fine. I installed QODBC on a second with the exact s...
Can't Change the Integrated Application Name in QuickBooks TROUBLESHOOTING: CAN'T CHANGE THE INTEGRATED APPLICATION NAME IN QUICKBOOKS PROBLEM DESCRIPTION I am using QODBC data driver to access to QuickBooks, no matter what kind of applications I am u...
VB Demo is missing TROUBLESHOOTING: VB DEMO IS MISSING PROBLEM DESCRIPTION I have installed QODBC, but can't find the VB Demo in the program group of QODBC Driver for QuickBooks. Where can if find VB Demo? SOLUTION For QuickBooks Enterprise users: ...
TROUBLESHOOTING: CREATE DCOM INSTANCE ERROR = 80070005 , UNKNOWN ERROR.. CREATED QBXMLRP2 OK. PROBLEM DESCRIPTION: When trying to use SQL Server via QODBC, It reports the error like this: Create DCOM Instance Error = 80070005 , Unknown error.. Creat...
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...
PROBLEM DESCRIPTION: I have installed the QODBC and QuickBooks I have set the Company Preferences / Integrated Applications to Allow Access to FLEXQuarters QODBC. When I hit the Test Connection to QuickBooks button I get a message from QuickBooks saying ...
HOW TO SETUP QODBC TO ACCESS QUICKBOOKS WHEN THERE IS NO-ONE LOGGED IN INSTRUCTION: To use QODBC to access QuickBooks, a QB instance must be running at front or background for accessing. QuickBooks is not a windows service, so it cannot run when there ...
TROUBLESHOOTING: QUICKBOOKS REPORTS "THE CERTIFICATE IS INVALID" PROBLEM DESCRIPTION: When first using the application to access QuickBooks via QODBC, it will pop up a window to ask the user to give the certificate to this application. But now facin...
PROBLEM DESCRIPTION: I called QuickBooks and they said we can run QuickBooks Canada 2005 alongside QuickBooks USA 2004 on the same computer no problem. They said the problems happen when you try to run USA/Canada QuickBooks on the same computer when bot...
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...
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...
PROBLEM DESCRIPTION: I can change the optimizer settings when I run the program as an administrator but it never really gets saved. Everything I run the Setup Screen again the settings are back to the original settings and my changes aren't saved. Do I ...
PROBLEM DESCRIPTION: We modified an invoice in QuickBooks and we are trying to get the data out in Excel, but QODBC gives us the old data still. Why? SOLUTIONS: QODBC failed to return full records is usually caused by either corruption of QODBC opti...
TROUBLESHOOTING - UNABLE TO FIND TABLE QBADVANCEDREPORTGROUP. PROBLEM DESCRIPTION 1: 1. I'm attempting to utilize your ODBC driver for reporting through Excel from QuickBooks Enterprise. The tables listed in your report help guide aren't accessible to m...
TROUBLESHOOTING - APP_ALREADY_PURCHASED ERROR WHEN TRY TO AUTHORIZE QODBC IN QUICKBOOKS ONLINE PROBLEM DESCRIPTION: We have some other users of QuickBooks online for the same company file. And when any other user tries to authorize and connect it throu...
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 ACCESS QUICKBOOKS DATA USING 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 app...
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 - 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...
HOW TO USE QODBC WITH PHP INSTRUCTIONS FOR USING QODBC WITH PHP: Using PHP, whether it's an internal Intranet or on the World Wide Web, requires the Server Edition of QODBC. QuickBooks must be running with the company file open. Download Sample [http...
TROUBLESHOOTING - CAN QODBC ONLINE HAVE REGION WISE FIELDS? PROBLEM DESCRIPTION: Can QODBC Online have region wise fields like QODBC Desktop driver? SOLUTIONS: QuickBooks online API is supporting only 1 region and thus we had only 1 region in QODBC...
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...
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": ...
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 QUICKBOOKS ONLINE EDITION (APPS.COM) SETUP OF QODBC ONLINE: The first step is to download and install QODBC Online. QODBC Online requires .Net Framework 4.6.1 or later version. So you need to install .Net Framework 4.6.1 to ...
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 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...
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 - MICROSOFT  EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT  ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I am having significant difficulties with QODBC...
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 - QODBC/QREMOTE TRIES TO CONNECT FOR 2 MINUTES OVER AND OVER PROBLEM DESCRIPTION: I am using QRemote DSN to connect to QuickBooks. QODBC/QRemote tries to connect for 2 minutes over and over, says it has a connection but does nothing. I...
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...
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 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...
TROUBLESHOOTING - CAN I USE QODBC WITH QBB ( QUICKBOOKS BACKUP ) FILE PROBLEM DESCRIPTION: I am trying to find a way we can pull data from a .QBB file without having to restore the .QBB file and/or go through QuickBooks. Is QODBC capable of doing so...
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...
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 ...
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...
HOW TO INSERT INVOICE USING EXCEL - VBA Download Sample [http://support.flexquarters.com/esupport/newimages/InsertInvoiceVBA/Insert_Invoice.zip] In this example, We will show you that How to insert Invoice in QuickBooks using the data available in Exce...
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...
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 ...