QODBC is a fully functional ODBC driver for reading and writing QuickBooks 2015-2002 accounting data files by using standard SQL queries.It requires an ODBC compliant front-end application such as Microsoft Word, Microsoft Excel, Microsoft Access, Visual Basic, PowerBuilder or Delphi. Once installed, it will allow these applications to read and write QuickBooks Accounting files in the same fashion as other file formats installed on your computer. Using the official QuickBooks SDK interface, we are able to offer our customers total compatibility with all QuickBooks file formats.
With 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 64bit applications to talk to QODBC and QuickBooks data in the 32 bit world via advanced communications methods. Since the initial version 12 release, QODBC version 14 now adds 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 data can be accessed from any location on any flavor of Windows OS at no extra charge, a normal license of QODBC is all that is required on each machine.
There is currently an issue with the QuickBooks SDK (developerís kit) which requires a session of QuickBooks to be running on certain systems in order for an application to make a connection to the company file.
If QuickBooks is not running and the SDK tries to open QuickBooks or launch a session of QuickBooks and fails, a connection can not be made. This behavior happens most often for customers using the Terminal Services version of Windows.
In this version, if you select Force Start QuickBooks on the Advanced Tab of the QODBC Setup Screen, QODBC will detect if a session of QuickBooks of QuickBooks is running, if not it will start a session of QuickBooks and then attempt to connect to the company file rather than having the SDK make the attempt and fail.
For quite some time now QuickBooks users have had some issues closing QuickBooks when using an external application is accessing the data.
The QuickBooks SDK (developerís kit) would think that an application was still trying to access the data even after the application was closed and you would have to wait for quite some time for QuickBooks to realize that there was no application trying to access the data and would then close.
We have added a new feature to QODBC version 13 on the Advanced Tab of the setup screen which will force QuickBooks to close in these type situations with no harm to QuickBooks, when selected.
QODBC adds the Serial Number and Lot Number related fields to the tables.
The read-only desktop edition of QODBC has again been chosen to be included as a feature in the QuickBooks Enterprise Edition 2015 product, on the main file menu under Utilities. If you need a read-only edition of QODBC and have this version of QuickBooks, you are ready to go, no purchase required! We have also now been chosen to be included in QuickBooks Enterprise Editions in UK, Canada and Australia.
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.
QODBC is an ODBC driver (DLL) for QuickBooks Accounting format files. QuickBooks 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 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 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 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.
QODBC opens up the 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.
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.
All of our products support QuickBooks USA versions 2015-2002, UK or Canadian 2015-2003. QuickBooks Pro, Premiere, Enterprise and Simple Start editions are supported. QuickBooks Online edition is supported.
SQL and ODBC are the corporate data access standard
No training required
ODBC level 2 support
Read-only, Read-Write and Internet versions available
Note: QuickBooks does not support writing to all areas of the accounting database, some areas are protected.
Today's end users are extremely sophisticated, requiring up-to-the-minute data to make a significant number of business decisions. Business people cannot afford to wait for their computer departments or CPA's to service a request for accounting data. The data must be available on the desktop instantly. ODBC is the solution for all Windows applications, and QODBC is the solution for QuickBooks Accounting users and developers needing a standard way to access data in all of their applications.
All QuickBooks data elements supported by the QuickBooks SDK are supported by the QODBC Driver for read and write capability (depending on the license of QODBC purchased).
QuickBooks Pro Advisors and consultants can configure reports and spreadsheets with live QuickBooks data for their customers, increasing billing hours. Developers can create applications which use QuickBooks data with ease, using QuickBooks data via existing ODBC data controls and methods. End user customers can use wizards and mail merge capabilities in Windows standard applications to merge QuickBooks data in their daily routine with just a few mouse clicks.
We also offer a FREE QODBC Pro 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 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 our Support Ticket System. Program anomalies will be addressed at no charge and updaters posted on our web site. Support issues specific to your application or requirements may be subject to a $75 per incident consulting fee.
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
QODBC version 15 works with the following QuickBooks Editions:
|AU, NZ, Asia|
|Note: Includes Pro, Premier and Enterprise Solutions. The QODBC Read Only Edition is included with Enterprise Editions 2006-2015|
All of our products support QuickBooks USA versions 2015-2002, UK or Canadian 2015-2003. QuickBooks Pro, Premiere and Enterprise editions are supported.
USA, Canada and UK editions are available via this web site.Other editions are available through our regional distributor for the Asia Pacific region.
|QODBC Desktop Edition Read Only Driver for QuickBooks||$149.00|
|QODBC Desktop Edition Read Write Driver for QuickBooks||$199.00|
|QODBC Server Edition Read Write Driver for QuickBooks||$499.00|