RSS Feed
Knowledgebase : TroubleShooting > Connection
     

[QODBC DESKTOP] - TROUBLESHOOTING - THE CERTIFICATE WAS REVOKED BY ITS CERTIFICATION AUTHORITY. REVOKED SECURITY CERTIFICATE. PROBLEM DESCRIPTION: We get an error message in QuickBooks saying that the application FLEXquarters QODBC's certificate was rev...
SOLVED: [QODBC-DESKTOP] TROUBLESHOOTING - QUICKBOOKS 2022 - COULD NOT START QUICKBOOKS - WINDOWS SERVER 2012 R2 & WINDOWS SERVER 8 ISSUE: We upgraded our QuickBooks Enterprise from 2020 to 2022. We were using QuickBooks 2020 and the QODBC driver versio...
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...
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 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 - QB BEGIN SESSION FAILED. ERROR = 80040438 PROBLEM DESCRIPTION: I am testing the connection of QODBC & I am getting the QODBC test connection failed error: Can you advise what is error and the solution for it? SOLUTION: The above ...
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...
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 How to insert an Invoice in QuickBooks using the data available in an Exc...
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...
TROUBLESHOOTING - QODBC RECORD SET ISSUE PROBLEM DESCRIPTION: I am using the below code. It is returning records & giving me the correct result. But If I change the query from "SELECT Name FROM customer" to "SELECT * FROM customer," it does not return...
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 - 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 - 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 purchases with each version? AKA. ...
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 - 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...
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 ...
TROUBLESHOOTING - CAN I USE QODBC WITH QBB ( QUICKBOOKS BACKUP ) FILE PROBLEM DESCRIPTION: I am trying to find a way to pull data from a . QBB file without having to restore the. QBB file and going through QuickBooks. Is QODBC capable of doing so? I...
[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 - 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 - 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 ...
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 ...
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...
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 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 ...
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 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 - ANOTHER USER HAS CHANGED THIS RECORD SINCE YOU STARTED EDITING IT. PROBLEM DESCRIPTION: I used the QuickBooks Pro 2015 trial version and purchased QODBC's latest version. I have an Access database with linked QB tables. I also have ...
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 - FAULTING APPLICATION NAME: QREMOTESERVER.EXE PROBLEM DESCRIPTION: We recently had a few error messages pop up on the server related to the QODBC driver on our server. We were wondering if you could provide any information as to what ...
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 and says it has a connection but does nothing...
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 - "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...
TROUBLESHOOTING - UPDATE QUERY TRUNCATING LEADING SPACES PROBLEM DESCRIPTION: I have to update a field with specific data; for some records, one of the fields will have leading spaces that are required to be there. I have tried numerous ways to get th...
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 our Linked Servers timeout now. I test the QODBC connection,...
TROUBLESHOOTING - MICROSOFT  EXCEL 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION TROUBLESHOOTING - MICROSOFT  ACCESS 2013 (OFFICE 365 / 2016) CRASHES / REQUIRED ACTIVATION PROBLEM DESCRIPTION 1: I have been having significant difficulties wit...
TROUBLESHOOTING - UNABLE TO IMPORT QUICKBOOKS ONLINE CONNECTION KEY USING QODBC ONLINE PREVIOUS VERSION PROBLEM DESCRIPTION: I am importing the QBO connection key using QODBC Online's latest version & I am getting the below error: THE FILE CAN NOT CON...
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...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot link to QuickBooks. I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition. I am getting the error: "Error =...
NOTE: VB DEMO IS DEPRECATED. Please refer to How to use the QODBC Test Tool for testing [https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/3069/] PROBLEM DESCRIPTION: VB DemoQODBC Test ToolTest Connection was crashing Wh...
PROBLEM DESCRIPTION: I am trying to use QODBC with Crystal Reports 11, but I'm also having similar results with the QODBC TEST TOOL included with the driver. Many queries, such as "select * from invoice," cause the program to hang. With Crystal Reports,...
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 GET VBA TO EXECUTE TWO STATEMENTS AT THE SAME TIME PROBLEM DESCRIPTION: We use a Visual Basic app with an SQL Server database to write data to QB through QODBC. We are executing two SQL statements as described in your help. We ...
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...
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 applications & "QuickBook...
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 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...
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 a later version. So you need to install .NET Framework 4.6.1 t...
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 - QB BEGIN SESSION FAILED. ERROR = 80040410 PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through QODBC using the QODBC TEST TOOL application. I am consistently getting an "80040410" error. Begin Session Failed. S0000 00000...
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 - HOW TO GET BANK RECONCILIATION DETAILS USING QODBC PROBLEM DESCRIPTION: How to get Bank Reconciliation details using QODBC I've not successfully identified any field/flag identifying the bank reconciliation status. Is this informatio...
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...
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 - 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...
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 supports only one region; thus, we had only one part in QODBC Onli...
HOW TO USE QODBC WITH PHP INSTRUCTIONS FOR USING QODBC WITH PHP: Using PHP on an internal Intranet or the World Wide Web requires the Server Edition of QODBC. QuickBooks must be running with the company file open. Download Sample [http://support.flex...
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 - HOW TO ACCESS QUICKBOOKS DATA USING 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 T...
TROUBLESHOOTING - FREEZING QUICKBOOKS, SLOW QUERY RUNNING. PROBLEM DESCRIPTION: When I run a report query, the query works very slowly & takes about 1-5 mins per simple report like: "sp_report ARAgingSummary show Current parameters DateFrom={d'2014-11-...
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 - INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST PROBLEM DESCRIPTION: I have QuickBooks 2014 version & I am using QODBC's latest version. I have a problem with querying the customer table using QODBC. QODBC driver consistently gets 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...
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 addre...
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 ...
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 can get records from the ProfitAnd...
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 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 ...
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...
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 made sure that the driver is referenced and checked in the Integrated Applications window i...
PROBLEM DESCRIPTION: VB DemoQODBC Test ToolTest Connection was crashing When I tried to connect to QuickBooks using QODBC. I have tried to reinstall QODBC & QuickBooks, but the QODBC Test connection (via VB Demo or QODBC Test Tool) is still crashing. A...
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 th...
NOT ABLE TO PULL ALL DATA IN TABLE SALESRECEIPT FROM QUICKBOOKS POS PROBLEM DESCRIPTION: When there is huge data in QuickBooks POS, QODBC POS cannot pull all data in Table SalesReceipt from QuickBooks POS. SOLUTION: 1. When there are huge data in Qu...
TROUBLESHOOTING: THE QBREPORTADMINGROUP VIEWS ARE NOT UPDATED FOR CHANGES IN THE 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...
PROBLEM DESCRIPTION: I have closed the QODBC connection to QuickBooks. But It still shows running in task manager QBW32.EXE keeps running even after QODBC closes the connection. SOLUTIONS: When the Disconnect command is sent to QODBC, QODBC sends th...
TROUBLESHOOTING: THIS FUNCTION REQUIRES ACTIVATION OF QODBC READ WRITE OR SERVER EDITION PROBLEM DESCRIPTION When I try to run a command in QODBC Test Tool, I get the error message "This function requires QODBC read-write or server version." I am try...
TROUBLESHOOTING: QREMOTE REPORTS "CONNECTION TO DATA SOURCE FAILED" WHEN WORKING WITH 64-BIT ACCESS OR EXCEL PROBLEM DESCRIPTION: Set up QRemote to work with 64-bit MS Excel. The Client DSN settings are correct. But when access to "QRemote Data 64-bit,...
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. ...
PROBLEM DESCRIPTION: I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot connect to QuickBooks. I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition. I am getting the error: "Error ...
CONNECTING TO QUICKBOOKS FAILED BECAUSE OF A WINDOWS SECURITY ISSUE. THE TEST CONNECTION WAS NOT WORKING. The QODBC Driver for QuickBooks runs differently under Microsoft Vista/W7 than other versions of Windows because of its new strict security setting...
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 a few problems reported when Upgrading to QuickBooks 2013 R7. After auto up...
QODBC SHOWS A 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 WHEN TRYING TO C...
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 - 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 DESCRIPT...
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: QODBC POS REPORTS "TEST CONNECTION TO QUICKBOOKS POS FAILED" ERROR. PROBLEM DESCRIPTION: QODBC POS reports a "Test Connection to QuickBooks POS failed" error when trying to connect to QuickBooks POS: SOLUTION: This error shows a pro...
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: ERROR CALLING OPEN QBCONNECTION RETURNED ERROR: 10061 - 10061 CONNECTION REFUSED PROBLEM DESCRIPTION: When doing a connection test using the "Test Connection" button in QODBC Setup Screen->General Window, QODBC reports this error: ...
TROUBLESHOOTING: CANNOT UPDATE INVOICE IN QUICKBOOKS ONLINE EDITION - QBOE PROBLEM DESCRIPTION: When trying to update the memo field in the table Invoice or InvoiceLine, QODBC reports the error: [QODBC]Error:1030-Not Support It is not only in the ...
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...
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...
"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 follow the steps and let us know if that resolves the is...
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...
TROUBLESHOOTING: CANNOT FIND QODBC DRIVER/QUICKBOOKS DATA UNDER SYSTEM DSN WITH ANY APPLICATION OTHER THAN THE QODBC TEST TOOL PROBLEM DESCRIPTION Testing under the 64-bit system, when using the QODBC Test Tool application, the user can see DSN (QuickBo...
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...
PROBLEM DESCRIPTION: When I attempt to configure the driver and data source, only QRemote for the QuickBooks driver is visible; please see below: Where can I find QuickBooks Data, the driver? Don't I need to configure the QuickBooks Data driver instead...
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. Created q...
TROUBLESHOOTING: CONNECTION LOST BETWEEN QODBC AND QUICKBOOKS / QUICKBOOKS ASKING FOR PASSWORD EVEN THOUGH CERTIFICATE IS ACCEPTED. PROBLEM DESCRIPTION We might get an issue where every time we reboot our file server the connection between QODBC and Qui...
TROUBLESHOOTING: RDS CLIENT IS NOT INSTALLED PROBLEM DESCRIPTION In a 64-bit system, I downloaded the RDS client, but when I launch the odbc configuration, it keeps on telling me the RDS client is not installed error. SOLUTIONS That was a bug on 64-b...
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: CONNECTION ERROR AFTER QODBC OR QUICKBOOKS UPGRADE PROBLEM DESCRIPTION 1 Sometimes when upgrading to a new version of QODBC, the connection test fails. If I go to the advanced tab in the setup, I get an error about NOT FINDING A DLL -...
TROUBLESHOOTING: COMPANY FILE SPECIFIED IS NOT AUTHORIZED FOR REMOTE ACCESS PROBLEM DESCRIPTION I have followed the instructions for the RDS setup but got the following error: First, how to Authorize remote access? and how to fix this problem. S...
TROUBLESHOOTING: BEGIN SESSION FAILED ERROR=80040154 - CREATE QUICKBOOKS COM INSTANCE ERROR=80040154 OR CLASS NOT FOUND PROBLEM DESCRIPTION. Suppose you receive an 80040154 error like the one below when connecting to QuickBooks. In that case, somethin...
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 the company file is already open and different from the one ...
TROUBLESHOOTING: MODAL WINDOW CAUSES QBW32.EXE TO HANG IN THE 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 specific tables to CSV files. I've checked the option ...