Jargon Software Jargonsoft Help Desk Knowledgebase Server Side Middleware
QODBC QB Driver
Suggested knowledgebase articles:

Knowledgebase Server Side Middleware QODBC QB Driver

Articles in this category

QODBC How to Connect to QuickBooks (QB) for the First Time

The following two links are useful in initially configuring the QODBC DSN: How to Connect to QB for the first time

2,133
(650)
QODBC - Quickbooks (QB) - Upgrading Quickbooks

  We strongly recommend contacting us in advance of upgrading your QuickBooks. QODBC licensing is not upward compatible only backwards, meaning you would need a registe

663
(746)
QODBC Optimizer and misc notes

NOTE:  (Abrar) Strange QODBC behavior can occur if the optimizer file is located in it's default folder, i.e. a folder in "appdata", which is a system folder. Remove this possibility for problems...

5,302
(721)
QODBC - Cannot connect to Quickbooks - possible cause

  This error: "

879
(655)
QODBC DCOM Errors - Helpful hints

The following QODBC error: [QODBC] QB Open Connection Failed. Create DCOM Instance Error = 8000401a, Unknown error.. Created qbXMLRP2 OK.  can be vexing, intermittent, and difficult to solve. ...

1,163
(685)
QODBC - keep alive PHP script maintains DCOM object for connect errors

Sometimes, the QODBC DCOM object times out after a period of no activity. the MS DCOM manager is supposed to relaunch the DCOM instance if another request is made, and the object is not available. Som...

834
(589)
QODBC XML Error on Write

QODBC error on writing Invoice records could be a result of creating a custom field in QuickBooks that is named the same as that used internally by QODBC. Example of the error message: [insert into ...

661
(889)
QODBC - PHP long column names

When using QODBC with PHP, it's important to note if using PHP v5.5.6 or later:   Version 5.5.6   14-Nov-2013     . . .   ODBC:

397
(563)
Strategy to avoid QODBC cache corruption

Use the attached .bat to run .php script to selectively or fully rebuild the QODBC cache. This  cache can become corrupted and unpredictable data results can occur. Do not run these .bat proced...

10,252
(715)
Bad interaction: win task scheduler running PHP code accessing QODBC DSN

From testing the following replicable behavior occurred when running a .bat file via the Windows task scheduler that in turn runs ForceField PHP code that accesses QB tables via QODBC (using win serve...

1,154
(654)
QB QODBC how to ensure additional reliabilty -

Suggestion from Abrar (PCC) on how to improve the stability of QODBC driver:   He writes: I changed the scheduler's timings for uploading unposted orders and for creating new files for the sal...

334
(636)
QODBC DSN for QRemote acting strangly, gives bad results, invoice processing fails

If a DSN (not necessarily QDDBC) begins to behave badly after (perhaps) working for the longest time, the problem could be DSN corruption.   Solution: delete and then re-add the offending DSN. ...

335
(618)
QODBC query to find invoices with duplicate RefNumbers

use:   select a.RefNumber, a.CustomerRefFullName, a.TimeCreated from Invoice a, Invoice b where a.RefNumber = b.RefNumber and a.TimeCreated <> b.TimeCreated and ( a.TxnDate > {d'2021-...

245
(521)