RSS Feed
Latest Updates
Sep
27
Hot Topics
Posted by Rajendra Dewani (QODBC Support) on 27 September 2013 08:15 AM

Hot Topics

[QODBC-Desktop] Troubleshooting - CDKEY has an invalid checksum.

[QODBC-Online] Troubleshooting - Unable to connect to QuickBooks Online - Error message: Unauthorized - 401 - Fault exception of type: AUTHENTICATION has been generated.

[QODBC-POS] Troubleshooting - Unable to connect to QuickBooks POS 2015 (12.0) using Office 365 / 2016

[QODBC-Desktop] Troubleshooting - Changes to the Integrated Application Authentication for QuickBooks.

[QODBC-Desktop] Troubleshooting - Microsoft Access/Excel 2013 (Office 365 / 2016) Crash/QODBC ask for Activation/RegFile1 License error

 

Solved: [QODBC-Desktop] Troubleshooting - The certificate was revoked by its certification authority. Revoked Security Certificate.

Solved: [QODBC-Desktop] Troubleshooting - No data returned - Unable to execute - InventoryStockStatusByItem

Solved: [QODBC-ALL] Troubleshooting - Windows cannot find fqqbsav.exe

Solved: [QODBC-Desktop] Troubleshooting - Unable to change the default configuration of newly created QODBC DSN - Build 348

Solved: [QODBC-ALL] Troubleshooting - Unable to execute update statement when using SQL Server 2019 linked server on Windows 11 or Windows Server 2019

[QODBC-Online]  Troubleshooting - QODBC Online - There was an error while communicating with the Ids Server


Read more »



Aug
23
FAQ
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 10:14 AM

 

Installation Issues
First Time / Demonstration
Activation / Deactivation
QODBC Server Edition
MS Access/Excel
Misc. Technical
SQL Language Support (Syntax)
Troubleshooting

 

Installation Issues

Test Connection Button on QODBC Setup Is Greyed/Disabled

QODBC hung up, or everything looks locked up, or the Application is Not Responding when fetching QuickBooks Data

why is the QODBC driver so slow

QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator

VB Demo is missing

Cannot find QODBC Driver/QuickBooks Data under system DSN with any application other than the VB Demo

Connecting to QuickBooks failed because of a Windows security issue

Unable to Activate/Deactivate QODBC even when running as Administrator/You do not have Sufficient Permissions

QODBC Shows the login page & login window when connecting with QuickBooks Online Edition

DCom Option / Server Edition Tab missing in QODBC Setup Tab

 

 

First Time / Demonstration

Connecting QODBC Driver to QuickBooks for the First Time using QODBC Support Wizard

Connecting QODBC Driver to QuickBooks for the First Time (Video)

How to set up QODBC Driver to auto-connect to QuickBooks. (Video)

How to setup QODBC to run without QuickBooks

Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video)

How to install QODBC Online & Using Microsoft Excel/Access with QODBC (Video)

 

Activation / Deactivation

Unable to Activate/Deactivate QODBC even thou running as Administrator/You do not have Sufficient Permissions

How to deactivate QODBC and How to transfer the license to a new computer

This function requires activation of QODBC ReadWrite or Server Edition

Authorized Quantity for CDKey: has been exhausted

More FAQ - Activation / DeActivation

 

 

QODBC Server Edition

How to create a Link Server with MS SQL 2005/2008/2012 64-Bit Using QODBC/QRemote

How to create a Link Server with MS SQL 2005/2008/2012 32-Bit Using QODBC/QRemote

How to create a Link Server with MS SQL 2005/2008/2012 32-Bit Using QODBC using DCom

Using QuickBooks data with MS SQL Server using QODBC Driver and QRemote (Video)

How to do INSERTs, UPDATEs, and DELETEs using OPENQUERY with Linked MS SQL Servers

 

 

MS Access/Excel - 64-Bit - For QuickBooks 2022 or above

How to Use QODBC with MS Excel 2016 / 365 / 2013 / 2019 64-Bit (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 64-bit (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 64-bit (Import Tables) (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

 

MS Access/Excel - 32-Bit

How to Use QODBC with MS Excel 2016 / 365 / 2013 / 2019 32-Bit

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 32-bit

How to Use QODBC with MS Access 2016 / 365 / 2013 32-bit (Import Tables)

How to Use QODBC with MS Excel 2010

How to Use QODBC with Microsoft Access 2010

How to Use QODBC with MS Excel 2007

How to Use QODBC with Microsoft Access 2007

Accessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)

How to Use QODBC with MS Access

 

MS Access/Excel - 64-Bit - For QuickBooks 2021 and older 

How to Configure QODBC to Work with Excel 2016 64-bit

How to Configure QODBC to Work with Access 2016 64-bit

How to Configure QODBC to Work With 64-bit MS Excel

How to Configure QODBC to Work With 64-bit MS Access

 

MS Access/Excel - Troubleshooting 

MS Excel 2013 or Access 2013 (Office 365) crashes when trying to connect to QuickBooks Data.

QODBC shows a RegFile1 License error when using MS Excel 2013 or Access 2013

QODBC shows a RegFile1 License error when using MS Excel 2013 or Access 2013, Excel Crash, Access Crash (Video)

MS Excel 2013 or Access 2013 shows This function requires activation of QODBC Read-Write or Server Edition.

 

 

QODBC / QRemote license

QODBC Licensing Information

QODBC with QRemote Licensing Information

 

Misc. Technical

How to get information on QODBC Tables and Columns

SQL ODBC Syntax Details

QODBC Setup Options - QODBC For QuickBooks Enterprise Users

How to use the QuickBooks Reporting Engine with QODBC

How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables

Getting a limited number of records or Few of the records is Missing in QODBC Table result

How to use QODBC and does not have a QuickBooks program on the machine

How to configure QODBC to work with 64-bit applications

How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video)

Unrecoverable error when opening QuickBooks after updating to 2012 R14

QBXML components have not been installed. / Error Getting Version /QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks

Error after QuickBooks 2014 R6 Update, The procedure entry point EnumProcessModuleEx could not be located in the dynamic link library PSAPI.DLL

QODBC Evaluation Period Expired after upgrade to Intuit Enterprise 2014 (QBES 14.0)

Known issues with QuickBooks 2014 SDK

QODBC Online version 14 is Discontinued

QODBC is missing tables and fields after upgrading to QuickBooks 2014 R6

QRemote Error "Could not connect to server/QRemoteServer"

How to remove QODBC Related Certificates from Integrated Applications under QuickBooks

How to cancel the subscription of QODBC Driver for QuickBooks Online

How to cancel the subscription of QXL Online for QuickBooks Online

 

 

SQL Language Support (Syntax)

SQL Language Support (Syntax) [QODBC-ALL] & [QXL-ALL]

[QODBC-ALL] Stored Procedures Command List

[QQODC- ALL] Function List

[QXL-ALL] Stored Procedures Command List

[QXL- ALL] Function List

SQL ODBC Syntax Details

 

 

Troubleshooting

Troubleshooting - [Fixed] QODBC Extremely Slow After Latest QuickBooks 2017 R5 Update

Troubleshooting - [Fixed] Microsoft Excel/Access 365/2016 - Invalid Certificate error/Digital Signature error/Certificate Error

Troubleshooting - QODBC licensing issues with Windows 10 upgrades


Read more »