QODBC - ODBC Driver for Reckon Accounts & QuickBooks
QODBC - ODBC Driver for Reckon Accounts & QuickBooks
QODBC is an ODBC (Open DataBase) Connector for Reckon Accounts Business Range without multi-currency support that allows you to work with Reckon Accounts data directly using software tools such as Microsoft Excel, Microsoft Access, Visual Basic, Crystal Reports and many other ODBC compliant applications.
Many applications have ODBC support built-in and can automatically use QuickBooks or Reckon Accounts data with wizard ease once this driver has been installed.
It is also compatible with Australian, New Zealand and Singapore editions of QuickBooks 2012/13, 2011/12, 2010/11 and 2009/10 without multi-currency support, 2008/09, 2007/08, 2006/07, 2005/06, 2004 and 2003 Pro, Premier, Accountant and Enterprise.
QODBC v21 doesn't work with QuickBooks or Reckon Accounts EasyStart, Accounting (formally known as Lite), Plus or Small Business Editions. In 2015 Reckon Accounts Pro was renamed to Reckon Accounts Premier (2 user).
QRemote Server and Client
Since the release of QODBC version 12, QODBC added support for communication with 64 bit applications such as Microsoft Access, Microsoft Excel and SQL Server. This feature called QRemote Server and Client allowed 64 bit applications to talk to QODBC and QuickBooks data in the 32 bit world via advanced communications methods. QODBC version 16 added much faster performance to the QRemote feature!
The initial release of QRemote only supported 64 bit operating systems and in this new release a 32 bit version of QRemote Client and Server is also installed allowing remote communication between 32 bit operating systems.
In addition to 64 bit application support, QRemote also handles remote access to QuickBooks data residing on another machine anywhere as long as it can communicate to the internet.
Now, QuickBooks / Reckon Accounts data can be accessed from any location on any flavour of Windows OS at no extra charge, a normal license of QODBC is all that is required on each machine.
QODBC Server/Terminal Edition
Our Server/Terminal Edition of QODBC will allow you to set up a Web Server and use any web tool you wish to use (PHP, ASP, ADO, Cold Fusion) to access data live from QuickBooks via ODBC without conversion in real time. If your customers need to know what's in stock right now or you need to know "Today's" sales while out of the office, then this is the product for you!
Those using Multi-User products such as Terminal Services, RDS or Citrix to allow multiple users to use a single copy of QODBC on a server should be using the Server/Terminal Edition of QODBC.
The Server/Terminal Edition also works with data server applications running on Windows 2008 Server, Windows 2003 Server, Windows 2000 Server, or Windows NT Server, such as Microsoft SQL Server. The Desktop Edition is not designed to handle multiple threads and communications from a protected background server process, but the Server/Terminal Edition can operate in this mode.
Attention All Reckon Accounts Users:
The Reckon Accounts Business Range 2014, 2015, 2016, 2017, 2018, 2019 and 2020 Premier and Enterprise Editions no longer includes a FREE Desktop Read Only version of QODBC (without the QRemote feature). To continue using QODBC you will need to have your own licensed copy of QODBC. In 2015 Reckon Accounts Pro was renamed to Reckon Accounts Premier (2 user).
What is ODBC?
ODBC (Open Data Base Connectivity) is a specification designed by Microsoft to allow Windows applications to access multiple database systems through a single method with no regard for various file formats. SQL (Structured Query Language) is used as the method for accessing data through ODBC. Vendors of ODBC drivers (like this one) follow the specifications for ODBC so that any ODBC compliant application can access the data available through the driver.
ODBC compliant applications include: Microsoft Access, Word, Excel, PowerBuilder, Borland Delphi, Crystal Pro Report Writer, Visual Basic and hundreds of others. Users of these applications do not need to learn SQL language to access these database files, they are simply presented on the desktop for the user to manipulate with wizards and icons.
What is QODBC?
QODBC is an ODBC driver (DLL) for QuickBooks or Reckon Accounts Accounting format files. QuickBooks and Reckon Accounts Accounting stores it's data in it's own proprietary DBMS file format. This driver allows users of any ODBC compliant front end application to read and write data contained in QuickBooks or Reckon Accounts Accounting format files similarly to any other ODBC enabled database.
QODBC works by accepting SQL commands from applications through the ODBC interface, then converting those calls to navigational XML commands to the QuickBooks or Reckon Accounts Accounting DBMS and returning record sets that qualify for the query results. This driver is not a Client/Server product, but rather communicates directly with the QuickBooks or Reckon Accounts application as it runs. QuickBooks is a flat file database, and this driver will not change it into a relational database, so keep that in mind when developing with this driver. QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools; speeding development time.
What can I do with QODBC?
QODBC opens up the Reckon Accounts or QuickBooks Accounting files created by thousands of custom programs to the new world of database connectivity. In the same way that Windows has created an environment where all applications have a similar look and feel, ODBC drivers make all database formats look the same.
- A user in Microsoft Office can use Excel to pull company accounting or invoice information directly into a spreadsheet and create a chart.
- Microsoft Word can do a customer mail merge directly from QuickBooks Accounting files.
- Crystal Pro Report writer can create multi-file reports from QuickBooks Accounting data.
- Microsoft Access or Borland Delphi can be used to merge QuickBooks Accounting data with other data sources to produce complex reports, or to run mass file updates based on multiple criteria.
Best of all, this driver is transparent and works in exactly the same fashion of ODBC drivers from other vendors. QuickBooks Accounting developers now can offer this driver to their customers to allow them direct access to their important data.
Free Evaluation Version
We also offer a FREE QODBC Read-Write trial copy of the software limited to 30 days of use. The evaluation version of QODBC is limited to 30 days of use and 20 write operations to Reckon Accounts / QuickBooks per session, otherwise fully functional including server mode.
A FAQ section and a free support knowledgebase is available for those evaluating QODBC. All customers can obtain free technical support via the FLEXquarters Support Ticket System. Program anomalies will be addressed at no charge and updaters posted on their web site. Support issues specific to your application or requirements may be subject to a USD$75 per incident consulting fee.
For QODBC support please visit: http://qodbc.com/support.htm
Upgrading Reckon Accounts means upgrading QODBC as well!
The #1 reason why customers contact our Support Desk is to report that QODBC stops working after installing a new or upgraded version of Reckon Accounts. It is important to remember that when you purchase a CD-Key to activate QODBC, you are purchasing a license for the version of QODBC supporting the current version of Reckon Accounts available at that time, and back to the earliest version listed on the web site and the help system.
For example, if you bought QODBC for Reckon Accounts 2020, it will work with that version of Reckon Accounts, as well as the previous ones listed on our web site. If you upgrade to Reckon Accounts 2021, QODBC will no longer work and you will have to purchase a CD-Key for QODBC for Reckon Accounts 2021.
Because either Intuit and Reckon Accounts adds new features, tables, fields and reports to Reckon Accounts whenever they release a major upgrade, FLEXquarters puts in a significant amount of work to update QODBC to match. When you upgrade to a new version of Reckon Accounts, you must also purchase a new CD-Key for the matching version of QODBC to bring it up to date.
Minimum CPU required: Pentium II processor 450 MHz or better
Minimum memory required: 64 MB
Minimum hard disk space required: 15 MB
Operating system version: Windows 98SE/2000/ME/NT 4.0/XP/Vista/Win7/Win8/Win10