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 sales persons everyday.

I made it so the timings do not clash with each other. If you look at our scheduler now it says unposted orders are uploaded from 8am to 6pm. The new files to download are scheduled to be created at 630pm.

My reasoning behind this was I noticed while the files were being created for the sales people the QODBC would pause it and run the upload orders check. Even when it finished the creating of new files hanged for a good 40 minutes then continued making files.

After these few updates and changes, I've had 0 issues for the past two weeks.

Third party job scheduler which supports the ability to do what Abrar mentioned above is at:

http://www.splinterware.com/

 

 Also, see: 

http://www.jargonsoft.com/support/knowledgebase.php?article=227

 

Article Details

Article ID:
243
Date added:
2015-06-24 16:35:09
Views:
261
Rating (Votes):
(572)