[QODBC-Online] Troubleshooting: Losing Connection to QuickBooks Online When QODBC is Idle for sometime
Posted by Rajendra Dewani (QODBC Support) on 11 January 2013 09:28 AM
This method is Discontinued, Please refer new product QODBC for QuickBooks Online:
When using QODBC to connect with QuickBooks Online, it works without any problems. But when there are no operations for about 2 to 3 hours, the connection will break. It works only when the user inputs login key again.
In order to use QODBC to access QuickBooks Online, user must keep logging into QuickBooks Online. Due to security reason QuickBooks Online Edition user gets automatically log out if there is no operation input for a certain time. This is a limit from QuickBooks Online Edition and QODBC has no authorities to modify it.
As a work through method, you can try to set a timer and run a simple query every 2 or 3 minutes to keep the connection alive. For example, you can run the simple select query like:
SELECT * FROM Customer
Alternative is to generate Login Key and save to DSN Configuration/QODBC Setup Screen
Keywords: connect to on-line quickbooks, QuickBooks Online, QBO, disconnect, remains idle