Added Run 2.1 Compatibility Checkbox on QODBC Setup Screen->”Advanced” button. This causes QODBC to run without FetchScroll and reports ODBC versions as 2.1. This feature is for some development environments like Cold Fusion.

Added stored procedure sp_qbfilename to return a recordset with the current company name (OS file path name) in it.

Added a new table called CustomField. It is an insert only table. Used to insert or update data in Custom Fields directly. Useful for updating custom data on tables that cannot be modified like Sales Receipt. An example is: INSERT INTO CustomField (OwnerID, Name, TxnType, TxnID, Value) VALUES (‘0’, ‘Spouse”s Name’, ‘SalesReceipt’, ‘3D82-1071533509’, ‘Test Add Of Spouse’)

 OwnerID  VARCHAR 50 Remarks: Always set to 0 
 Name   VARCHAR 31 Custom Field Name
 EntityType  VARCHAR 23 “Customer”, “Employee”, “Vendor”, “OtherName”, “Item”, “Account”
 EntityRefListID  VARCHAR 36                                
 EntityRefFullName VARCHAR 159      
 TxnType  VARCHAR 23 “Bill”, “BillPaymentCheck”, “BillPaymentCreditCard”, “Charge”, “Check”, “CreditCardCharge”, “CreditCardCredit”, “CreditMemo”, “Deposit”, “Estimate”, “InventoryAdjustment”, “Invoice”, “ItemReceipt”, “JournalEntry”, “PurchaseOrder”, “ReceivePayment”, “SalesOrder”, “SalesReceipt”, “SalesTaxPaymentCheck”, “VendorCredit”
 TxnID   VARCHAR 36
 TxnLineID  VARCHAR 36
 OtherType  VARCHAR 7 “Company”
 Value   VARCHAR 4095

Moved Include Raw Files from QODBC Setup Screen->”Messages” button to QODBC Setup Screen->Advanced Button.
Changed PurchaseOrder custom fields to be Other1 and Other2 in the header. They were incorrectly set to the custom fields from Vendor.

Updated the Command Parser to XERCES 2.6. Version 2.5 seemed to run slow at times. This new version does sometimes return the XML version string differently than previous versions, meaning, if you run an old version of QODBC with this parser, some multi line item saves may fail. If you go back a version on QODBC you will need to go back at least one version of XERCES-com.dll.

Includes a new version of Connector.exe (Remote Connector) and ibizqb3.dll and ipwsll6.dll. Fixes some issues with error 851, Permanent connection lost.

Removed Login User from QBOE connection information on the QODBC Setup Screen->”Advanced” button. If your company file has authorized “QODBC Driver” to log in without security, the login box no long appears and the user is automatically logged in. For this to work, the Login GUID must be blank.

Changed the DATABASE function to return the path of the current company file, not the value passed in to open QuickBooks.

Changed the way QODBC works with FileDSN. Now the entire QODBC Setup Screen appears, not just the company path. Now all parameters can be set and will be stored in the FileDSN when called.

The QODBC Setup Screen does not allow you to change the DSN name if it is in edit mode. This is the correct behavior as previously changing the DSN had unpredictable results.

Corrected errors with Excel connecting to QODBC from MSQRY when using a new data source.

Now correctly uses the SDK 4 interface for connecting to QuickBooks 2005. It also correctly detects SDK 4.0  before requesting the first return values.

Corrected the Primary index on many of the line item tables in QB2002. This allows updates or selection of line items. The limitation is if two lines have the same item reference.

Fixed Item and Entity queries. FullName was only 41 characters and did not allow selecting records where the FullName was longer than 41 characters.