QODBC is a fully functional ODBC driver for reading and writing QuickBooks 2006-2002 accounting data files by using standard SQL queries. The program requires an ODBC compliant front-end software like Microsoft Office Word, Excel, Access, Visual Basic, Delphi and PowerBuilder .

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.

QODBC version 6 is a revolutionary version which is 10 times faster to use than previous editions due to the use of Optimizer technology. The first time you access a given QuickBooks table, QODBC optimizes access to that data and the next time you need data from that table, it will be very fast.

QODBC works with all versions of QuickBooks, but QuickBooks 2006 provides the best performance due to changes in the way our tools can access the data inside QuickBooks.

QODBC has also been chosen to be included as a feature in the QuickBooks Enterprise Edition 2006 product, on the main file menu under Utilities.

Limitations:

· 30-day trial

What's New in This Release: [ read full changelog ]

· Increased internal Cache size for faster optimization and retrieval times.
· Fixed bug with max SQL length greater than 32767.
· SalesRepEntityRefFullName - size changed from 31 to 209 to match Entity full name.
· Fixed Panel Total Record count on line item tables.
· Item table now has CustomFields and most fields from all the individual item tables.
· SalesOrder and Estimates Sync using InvoiceLinkedTxn table.
· Set Pragma Cache back off/Iterator size back to 100
· Set Pragma Cache back on at 20000/Iterator size back to 500
· Added Chunk key word to help with out of memory issue.
· Added index on ListDeleted ListDelType, TimeDeleted
· Changes to database engine to fix speed issue on some multitable joins.
· JournalEntryLine table complete
· Fixed issues with Optimized SQL using IN statements not selecting records
· Fixed issue with PriceLevelPerItem updates needing ItemRef copied to the output buffer.
· Changed ReceivePayment and ReceivePaymentLine to never use iterators to avoid the SDK bug.
· Changed behaviour of Encryption Checkbox. Will open the .OPT no matter what the current setting is. Uses the encryption setting only when creating the .OPT file.
· Fixed Remaining Field value on Sales table for SalesReceipt type to correctly return 0.
· Fixed bug with blank dates in crystal.
· Incremented internal version number of cache so would force reoptimiztion of all tables on first use.
· Corrected issues with 30 - Update Error message, from setting the system clock forward and back.
· Corrected issue with not being able to clear the QODBC Messages when error 30 - Update Error message appeared.
· Added automatic COM retry logic so RETRY or SWITCH TO messages will not appear on long queries.
· Added support for NULL or empty values to be skipped in sp_report parameters section.
· Fix to sp_report summaryrowsby parameter returning 0 rows
· Addes SalesLine view.
· Fixed issues with SP_LASTINSERTID invoiceline failing to return value.
· Corrected issue that gave an XML error when inserting a new line into SalesReceiptLine.
· Corrected issue with long fields not returning all data when calling optimized data from an app like MSQRY.EXE that requests long fields in chunks.
· Issue with Optimized "Order By" being slow has been resolved.
· SP_COLUMNS stored procedure now accepts a string pattern as the table name parameter. It also accepts a table or string called "ALL". So sp_columns 'Bill%' will return all tables that start with "Bill". SP_COLUMNS will also accept a second parameter that is the pattern for the column name. So sp_columns 'Bill' 'Txn%' would return all columns in the Bill table that start with "Txn"
· SP_TABLES stored procedure now accepts a string pattern as the table name parameter, a Table Name or ALL. So sp_tables 'Bill%' will return all tables that start with "Bill"
· Fixed SalesLine table. Was only displaying one line of from each SaleReceipt and CreditMemo.
· Allowed PriceLevel header to be saved when a FixedPercent is used.
· Turned on FullName Jumpin for PriceLevel and PriceLevelPerItem
· On all subtables, deletes all records for parent ID when starting to load a new record. Example, when reloading an InvoiceLine for a given invoice all InvoiceLines with the same TxnID are removed before the invoice is loaded. This corrects leaving residule deleted lines in the optimizer table.
· SP_REPORTS. This new stored procedure works similar to SP_TABLES but lists available sp_reports.
· SP_PARAMETERS. This new stored procedure works similar to SP_COLUMNS but lists parameters available for a given SP_REPORTS. The VALUES column lists available values that can be used with the parameter.
· Fixed issue with CreditCardTxnInfoResultTxnAuthorizationStamp field not saving correctly. Driver was returning not capable when saving data to this field.