RSS Feed
Knowledgebase : TroubleShooting > Connection
TROUBLESHOOTING: MODAL WINDOW CAUSES QBW32.EXE TO HANG IN BACKGROUND WHEN OPENED WITH QODBC PROBLEM DESCRIPTION 1 I'm running PHP scripts on a Win 2k server to access my company file, and export certain tables to CSV files. I've checked the option to a...
TROUBLESHOOTING: GET ERROR 8004040A AFTER UPDATE THE DRIVER PROBLEM DESCRIPTION 1 I updated the driver and now it will not connect to the company file. I'm getting error = 8004040a. It says that the company file is already open and is different from t...
TROUBLESHOOTING: BEGIN SESSION FAILED ERROR=80040154 PROBLEM DESCRIPTION If you receive an 80040154 error like below when connecting to QuickBooks, it's possible that something has undone your QuickBooks COM registrations (like installing a previous ...
TROUBLESHOOTING: COMPANY FILE SPECIFIED IS NOT AUTHORIZED FOR REMOTE ACCESS PROBLEM DESCRIPTION Have followed the instructions for the RDS setup, but get the following error: First, how to Authorize remote access? and how to fix this problem? SO...
TROUBLESHOOTING: CONNECTION ERROR AFTER QODBC OR QUICKBOOKS UPGRADE PROBLEM DESCRIPTION 1 Sometimes when upgrading to a new version of QODBC and then the connection test fails. Get error 80040154 (unknown error). If I go to the advanced tab in the set...
TROUBLESHOOTING: .NET FRAMEWORK INITIALIZATION ERROR WITH RDS PROBLEM DESCRIPTION Some people may get a .NET error as below when trying to launch RDS Server/Client after a successful installation of RDS applications: RDSServer.exe - ".Net Framework ...
TROUBLESHOOTING: RDS CLIENT IS NOT INSTALLED PROBLEM DESCRIPTION In a 64-bit system, I downloaded RDS client but when I launch odbc configuration it keeps on telling me the RDS client is not installed error. SOLUTIONS That was a bug on 64-bit machine...
TROUBLESHOOTING: CONNECTION LOST BETWEEN QODBC AND QUICKBOOKS / QUICKBOOKS ASKING FOR PASSWORD EVEN THOU CERTIFICATE IS ACCEPTED. PROBLEM DESCRIPTION We might always get an issue where every time we reboot our file server the connection between QODBC an...
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: When I attempt to configure driver and data source, only QRemote for QuickBooks driver is visible; please see below: Where can I find QuickBooks Data driver? Don't I need to configure QuickBooks Data driver instead of QRemote for Q...
PROBLEM Created a VBS referring - http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Arti...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM DSN WITH ANY APPLICATION OTHER THAN THE VB DEMO PROBLEM DESCRIPTION Testing under the 64-bit system, when using VB Demo test application, the user can see DSN (QuickBooks Data) in th...
Please Also Refer: Connecting QODBC Driver to QuickBooks for the First Time (Video) [http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2512] The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 t...
"HY111 database connector error invalid bookmark value" on crystal report when refreshing the report. SOLUTIONS This could be the issue with the company file or Optimizer. I kindly request you to follow steps and let us know if that resolves the iss...
HOW TO INSTALL QODBC POS AND CONNECT TO QUICKBOOKS POS ON WINDOWS VISTA/ WINDOWS 7 OPERATING  SYSTEM INSTALL QODBC POS Please download QODBC Installer from this site: http://www.qodbc.com/posDownload.htm [http://www.qodbc.com/posDownload.htm] Then...
HOW TO CREATE LINK SERVER WITH MS SQL 2005/2008/2012/2016 64-BIT USING QODBC/QREMOTE  For 32-bit Refer: How to create Link Server with MS SQL 2005/2008/2012/2016 32-bit Using QODBC/QRemote [http://support.flexquarters.com/esupport/index.php?/Default/Know...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION - QBOE PROBLEM DESCRIPTION: When trying to update memo field in the table Invoice or InvoiceLine, QODBC reports the error: [QODBC]Error:1030-Not Support It is not only in field me...
TROUBLESHOOTING:ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061 - 10061 CONNECTION REFUSED PROBLEM DESCRIPTION: When do a connection test using "Test Connection" button in QODBC Setup Screen->General Window, QODBC reports this error: --------...
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: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS FAILED" ERROR. PROBLEM DESCRIPTION: QODBC POS reports "Test Connection to QuickBooks POS failed" error when trying to connect to QuickBooks POS: SOLUTION: This error shows that th...
TROUBLESHOOTING: THIS APPLICATION IS NOT ALLOWED TO CHANGE ITS AUTHENTICATION PREFERENCES UNLESS QUICKBOOKS IS RUNNING WITH THE ADMINISTRATOR LOGGED IN PROBLEM DESCRIPTION: IsAService: False Begin Session Failed. S0000 00000 [QODBC] QB Begin Session F...
TROUBLESHOOTING - LISTENING FAILED. QREMOTE SERVER IS SHUTTING DOWN IN 15 SEC PROBLEM DESCRIPTION 1: When I start QRemote Server, I get QRemoteServer Started and it shows "Listening failed.QRemote Server is shutting down in 15 sec" PROBLEM DESCRIPTIO...
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...
QODBC SHOWS REGFILE1 LICENSE ERROR WHEN USING MS EXCEL 2013 OR ACCESS 2013  MS EXCEL 2013 OR ACCESS 2013 SHOWS THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION MS EXCEL 2013 OR ACCESS 2013 (OFFICE 365) CRASHES AS SOON AS TRYING T...
PROBLEM : QBXML components have not been installed. / Error Getting Version / QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks REASON : There have been few problems reported when Upgrading to QuickBooks 2013 R7. After auto upda...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE, TEST CONNECTION NOT WORKING The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security settings. If T...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC but I am unable to connect to QuickBooks. I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition. I am getting the error: "Er...
PROBLEM DESCRIPTION Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start QuickBooks. Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040408, Could not start Reckon Accounts. ...
TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED" WHEN WORKING WITH 64-BIT ACCESS OR EXCEL PROBLEM DESCRIPTION: Setup QRemote to work with 64-bit MS Excel. The Client DSN settings are correct. But when access to "QRemote Data 64-bit" ...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION PROBLEM DESCRIPTION When I try to run a command in VB Demo I am getting the error message " This function requires QODBC read-write or server version". I am tryi...
PROBLEM DESCRIPTION: I have closed QODBC connection to QuickBooks. But It still shows running in task manager QBW32.EXE keeps running even after QODBC closes the connection. SOLUTIONS: When Disconnect command is sent to QODBC, QODBC sends the same t...
TROUBLESHOOTING: THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR CHANGES IN CUSTOM FIELD PROBLEM DESCRIPTION: The QBReport Admin Group views are not updated for changes in custom field id's. The user can see QBReportAdminGroup and other tables in MS ...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS PROBLEM DESCRIPTION: When there are huge data in QuickBooks POS, QODBC POS not able to pull all data in Table SalesReceipt from QuickBooks POS. SOLUTION: 1.When there are huge data ...
PROBLEM: I have a customer who does their invoicing with an ASP.NET application and it flows into QuickBooks. I created the interface with QODBC and it works with no problem except that sometimes the processes will lock up and I have to remote into their...
PROBLEM DESCRIPTION: VB DemoTest Connection is crashing When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks but still, QODBC Test connection (also via VB Demo) is crashing. Also, I tried to run QODBC as Admin...
TROUBLESHOOTING: UNABLE TO CONNECT TO THE QUICKBOOKS DATABASE. PROBLEM DESCRIPTION: I installed the QODBC driver as a new install. I have configured the ODBC and I have made sure that the driver is referenced and checked in the Integrated Applications w...
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 CAN I USE QODBC WITH TWO DIFFERENT VERSIONS OF QUICKBOOKS INSTALLED? PROBLEM DESCRIPTION: I have two different versions of QuickBooks (i.e. QuickBooks Enterprise 2012 & QuickBooks Enterprise 2014) installed on my machine. I want to access both v...
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: SP_REPORT PROFITANDLOSSBUDGETPERFORMANCE IS RETURNING NO ROWS. PROBLEM DESCRIPTION 1: I am running ProfitAndLossBudgetPerformance through MS Query & It is returning no rows. But using QuickBooks UI I am able to get records from ProfitA...
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...
PROBLEM DESCRIPTION: When inserting an invoice via a looping SQL procedure, I have invoice lines (InvoiceLine table) items that can potentially be assigned to varying classes. Using the ClassRefListID field, I class the lines accordingly, and do not addr...
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 - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST PROBLEM DESCRIPTION: I have QuickBooks 2014 version & I am using QODBC latest version. I have a problem with querying customer table using QODBC. QODBC driver consistently gets stuck o...
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 - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run report query, query works very slow & take about 1-5 mins per simple report like: "sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-12'}, Dat...
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 - 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...
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...
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...
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 - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC PROBLEM DESCRIPTION: How to get Bank Reconciliation details using QODBC I've not had success identifying any field/flag that identifies the Bank Reconciled status. Is this informatio...
EXAMPLES OF CREATING INVOICE USING QREMOTE FROM SQL SERVER NOTE: For multi-line invoices, some may find it easier to NOT include the header information with each line item, but rather to have separate smaller commands for the Invoice Lines and a final ...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040410 PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through QODBC using VB Demo application. I am consistently getting "80040410" error. Begin Session Failed. S0000 00000 [QODBC] QB Beg...
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...
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...
GENERAL CONNECTION STRING INSTRUCTIONS The most difficult part of using QRemote in programming is the connection string. The simplest form includes a reference to a DSN. A system DSN called "QuickBooks Data QRemote" for 32-bit application & "QuickBooks...
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 GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME TIME PROBLEM DESCRIPTION: We are using a Visual Basic app which works with an SQL Server database to write data to QB through QODBC. We are executing two SQL statements as described...
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...
PROBLEM DESCRIPTION: I am are trying to use QODBC with Crystal Reports 11, but I'm also having the similar results with the VB Demo included with the driver. Many queries, such as "select * from invoice" cause the program to hang. With Crystal Reports, ...
PROBLEM DESCRIPTION: VB DemoTest Connection is crashing. When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks but still, QODBC Test connection (also via VB Demo) is crashing. Also, I tried to run QODBC as Admi...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I am unable to connect to QuickBooks. I have a Read Only Desktop edition of QODBC which is included with QuickBooks Enterprise Edition. I am getting the error: ...
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 - UNABLE TO IMPORT QUICKBOOKS ONLINE CONNECTION KEY USING QODBC ONLINE PREVIOUS VERSION PROBLEM DESCRIPTION: I am importing QBO connection key using QODBC Online latest version & I am getting below error: FILE CAN NOT CONTAIN PROPER K...
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 - GETTING TIMEOUT ERROR IN SQL SERVER'S LINKED SERVER USING QODBC PROBLEM DESCRIPTION: I recently upgraded from 1.0.0.7 to 1.0.0.312. Everything was pretty smooth, except for now all our Linked Servers timeout. I test the QODBC connect...
TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES PROBLEM DESCRIPTION: I have to update a field with specific data and for some records, one of the fields will have leading spaces that are required to be there. I have tried numerous ways to get...
TROUBLESHOOTING - "CANNOT UPDATE TABLE ITEMINVENTORY ERROR 10004" PROBLEM DESCRIPTION: I am trying to run an update on the Name field in ItemInventory. I've checked to see if it's updateable and it is. I get "Cannot update table ItemInventory Error 1...
TROUBLESHOOTING - GETTING UNEXPECTED EXTRA TOKEN ERROR IN DATE FIELD QUERY PROBLEM DESCRIPTION: I am trying to query the Transaction table based on the TxnDate field. I tried the below code. OdbcCommand SourceCmd = new OdbcCommand("Select * from Tra...
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 - FAULTING APPLICATION NAME: QREMOTESERVER.EXE PROBLEM DESCRIPTION: We have had a couple error messages pop up recently on the server related to the QODBC driver on our server and were wondering if you could provide any information as ...
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...
TROUBLESHOOTING - THIS RECORD HAS BEEN CHANGED BY ANOTHER USER SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I am using the QuickBooks Pro 2015 trial version and a purchased QODBC latest version. I have an Access database with linked QB tables. ...
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....
TROUBLESHOOTING - HOW TO STOP ANY QUERY ON VB DEMO APPLICATION PROBLEM DESCRIPTION: How to Stop any query on VBDEMO when it takes time. How to convert the date to QuickBooks date. I want to insert TxnDate in the ReceivePayment table, but it pops u...
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 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 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 - 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 - HOW DO I SEE BACKORDER ITEMS THAT HAVE BEEN INVOICED BUT NOT SHIPPED PROBLEM DESCRIPTION: Could someone kindly provide me with a sample, or is there a stored procedure that would allow me to only pull out back ordered invoices from t...
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 - 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...
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 - CONNECTION SERIAL, LIMITATION, QUEUE AND UPPER LIMIT PROBLEM DESCRIPTION: How many concurrent connections does the Server edition support? Is the product QB version specific, requiring additional purchase with each version. AKA. Up...
TROUBLESHOOTING - CODE DIFFERENCES BETWEEN QODBC DESKTOP AND QODBC ONLINE PROBLEM DESCRIPTION: I have an MS Access application using QODBC to connect to desktop QuickBooks. Can I use the QODBC Online driver to connect to QuickBooks Online without chan...
TROUBLESHOOTING - HOW TO CLOSE SQL LINKED SERVER CONNECTION PROBLEM DESCRIPTION: We are using QRemote with SQL Linked Servers with several different QuickBooks files. How can we close the connection to a QuickBooks file after the query has run, then o...
TROUBLESHOOTING - QODBC RECORD SET ISSUE PROBLEM DESCRIPTION: I am using below code it is returning records & giving me the correct result. But If I change query from "SELECT Name FROM customer" to "SELECT * FROM customer" it does not return any recor...
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...
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...
TROUBLESHOOTING - QB BEGIN SESSION FAILED. ERROR = 80040438 PROBLEM DESCRIPTION: I am testing connection of QODBC & I am getting QODBC test connection failed error: Can you advise what is error and solution for it? SOLUTION: The above error says t...
HOW TO USE POWERSHELL WITH QODBC Download Sample [http://support.flexquarters.com/esupport/newimages/PowerShell/DisplaySQL.zip] SAMPLE CODE FOR USING QODBC DSN: $connectstring = "DSN=QuickBooks Data;" $sql = "Select TOP 10 Name from Customer" $conn ...
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...