Knowledgebase
[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:

How to use QODBC Online with QuickBooks Online Edition (Apps.com)

How to Reconnect QODBC Online with QuickBooks Online Edition (Apps.com)

Problem Description:

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.

Solution 1:

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

or


SELECT * FROM Customer where ListID='000000-000000'

Solution 2:

Alternative is to generate Login Key and save to DSN Configuration/QODBC Setup Screen

 

Keywords: connect to on-line quickbooks

(0 vote(s))
Helpful
Not helpful

Comments (2)
AG Rana
29 April 2014 03:03 PM
QBO will not be accessible through QODBC after 15 May 2014.
Jack
07 July 2014 01:28 PM
Hi,

I would like to inform you that QuickBooks Online SDK is shutdown.

QODBC was built on the QuickBooks SDK (development kit) back in 2002 and support for the QuickBooks Online Edition was added later. At that time, one driver served both Desktop and Online editions of QuickBooks. With their new cloud version of QuickBooks Online, Intuit is phasing out that development kit and replacing it with a new developers system. This system is designed for desktop applications, not windows drivers like ODBC.

Please refer below mentioned article for more details:
http://news.qodbc.com/qodbc-for-quickbooks-online-sunsetting/



We are developing product in support of QuickBooks Harmony. Please refer below mentioned article for more details:

http://news.qodbc.com/qodbc-online-for-quickbooks-in-development/

I would like to inform you that currently we are in development phase. Earlier we have said that we will release a product on 15th June 2014. But We can't release it on 15th June 2014 due to some technical reason. We will soon release beta version for the same & inform you.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).