Archive for the ‘Support’ Category

Important Update for QODBC Desktop and POS Driver Users

Monday, July 15th, 2024

Security Update: Action Required

We strongly recommend users of QODBC Driver for QuickBooks Desktop and Point of Sale (POS) build 352, 353, 354, or 355 to the latest version as soon as possible.

Why the Update is Necessary

The latest version, QODBC Driver 356, addresses a security issue that has been identified in previous builds. This security fix is essential to ensure the safety and integrity of your data and systems.

Action Required

Please be aware that builds 352, 353, 354, and 355 will stop working on July 31, 2024. To avoid any disruption in your services, it is crucial to update to QODBC Driver 356 before this date.

Applicable Products

This update applies to the following products:
• QODBC Driver for QuickBooks Desktop
• QODBC Driver for QuickBooks POS

How to Update

You can download the updated QODBC Driver from the following links
Download QODBC Driver for QuickBooks Desktop
Download QODBC Driver for QuickBooks POS

Steps to Update

  1. Click on the provided link to download the latest driver.
  2. Follow the installation instructions to update your current QODBC Driver.
  3. Restart your system to ensure the update is properly applied.

Need Assistance?

If you encounter any issues or have any questions regarding the update process, please do not hesitate to contact our support team. We are here to assist you and ensure a smooth transition to the latest version.

Best regards,
The QODBC Team

Important: Recent Changes to QuickBooks

Thursday, June 20th, 2024

Recently Intuit announced changes to several of the QuickBooks product lines.

QuickBooks 2021:

If you are currently using QuickBooks 2021 (only this year), Intuit is closing support and downloads for this specific version including QuickBooks Desktop Pro, Premier, and Enterprise Solutions. You will no longer have access to add-on services for QuickBooks 2021 including bank downloads and payroll services.

The QuickBooks software other than downloads and updates will continue to work as normal and QODBC and QXL subscriptions will continue to work as expected with this version and others, including our OEM partners.

QuickBooks Pro and Premiere:

Intuit will discontinue sales of QuickBooks Pro Plus, Premier Plus, Mac Plus, and Desktop Enhanced Payroll to new U.S. subscribers after September 30, 2024, although we will continue to support renewals.

QuickBooks Enterprise customers are not affected by this change. See details here.

If you continue your existing subscription to these products past the deadline date, these products will continue to work as normal and QODBC and QXL subscriptions will continue to work as expected with this version and others, including our OEM partners.

For more information regarding other changes being made to QuickBooks 2022-2024 products please see the following article from Intuit:

Thanks for being a customer of QODBC and QXL!

Why have you switched QODBC Desktop Edition to subscription billing?

Saturday, September 23rd, 2023

Throughout our history, for the QODBC product line, we have followed the patterns set by Intuit – the maker of QuickBooks. If Intuit made a change, we made a similar change. We figure that they are a multi-billion dollar company, so how far wrong can we go by following their moves right?

So last year, QuickBooks went entirely to a subscription model for the Windows Desktop product line, so the question came up, should we switch to a subscription model also? Initially, there was a lot of resistance because it’s a big change, and we don’t want to mess up our current customers or their needs.

But we also need to realize that, at some point, people will need to get a new version of QODBC. Right now, we’re using the major version number inside the QuickBooks product (2023, 2024) to determine what version of QuickBooks is being used so that the matching QODBC version is correct for this user. Now that QuickBooks billing is on a subscription, we feel that Intuit may stop updating this number in the future since version/year is no longer a selling point on in-store boxes, for example, so we need to plan for this eventuality.

Because the QuickBooks database format changes on a regular basis, it is best to use the QODBC version which matches that version of the QuickBooks database. Keeping the QODBC Driver up to date is the easiest way to make sure you are getting the latest database details from QuickBooks as well as the latest bug fixes available. So that’s why when it’s 2022, and you have a version for 2021, you can’t use it on the 2022 QuickBooks because the databases have changed, and QODBC needs to be updated to handle those new modifications.

Also, we had a problem with people who would find out about us and buy QODBC in August or September, only to have another version of QuickBooks come out very quickly, and after installing that upgrade, having to purchase ANOTHER copy of QODBC for the newer version of QuickBooks. This issue had to be handled manually by our support team, taking much time and effort and causing grief for the customer.

These various issues cost us and our customers time and money, and the smoother way to move forward seems to be the subscription model since it matches up with QuickBooks and synchronizes the relationship between QODBC and QuickBooks so they are both always the latest version and can be updated at any time.

You can go forwards or backwards on both – it doesn’t matter which version you have of either product as long as the subscription is active – you can choose which version of each product is working best for your needs. So, since we couldn’t depend on QuickBooks continuing to keep putting out new revisions and updating the major version number, we thought it was best to go with a subscription model. We have been using an identical subscription model on the QuickBooks Online edition for a few years now, and there have been very few issues with licenses – it just works.

We attempted to keep the pricing as similar as possible, and even with inflation running high, we still are using the same pricing as we have had for 21 years, since 2002. We wanted to make it as similar to the previous product as we could, so we made it yearly billing with no price change.

Other than that, we think this change makes life easier for QODBC users and consultants, and instead of being forced to upgrade when new QuickBooks versions are released, we let you decide if or when you want to upgrade your QODBC version. If it is working well, no need to touch anything under the subscription model.

Not everyone will be happy with this change, but we think they will get used to the simplicity of never again having to think about license issues – you will be automatically billed each year with no need to take any action, and your subscription will continue. In addition, you will get an email one week before your subscription renewal, just in case you want to cancel the renewal or use a new credit card for billing. If all goes well on the renewal, you will see no service outages from QODBC.

This has been a difficult transition for us, but we hope it is easier for most customers in the long run, and we hope to be your go-to choice for QuickBooks database access for some time to come – your feedback is always appreciated, and if you have any further questions, Please don’t hesitate to ask.

Thanks for being a customer of QODBC!

Bradley Waddell

Managing Director, Limited – home of QODBC and QXL

[QODBC Desktop] – Troubleshooting – The certificate was revoked by its certification authority.

Wednesday, August 23rd, 2023

Please click here to view more information.

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

Thursday, April 13th, 2023

Please click here to view more information.

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

Monday, November 14th, 2022

Please click here to view more information.

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

Friday, September 2nd, 2022

Please click here to view more information.

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

Friday, September 2nd, 2022

Please click here to view more information.

[QODBC-Desktop] Troubleshooting – Could not start QuickBooks – Windows Server 2012 R2 – QuickBooks 2022

Thursday, November 11th, 2021

Please click here to view more information.

Troubleshooting – Excel crash when using SQL statement with two inner joins along with unoptimized

Wednesday, October 21st, 2020

Please click here to view more information.