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.
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.
The Reckon Accounts Business Range 2014, 2015, 2016 and 2017 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
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 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 2016, 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 2017, QODBC will no longer work and you will have to purchase a CD-Key for QODBC for Reckon Accounts 2017.
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