Knowledgebase
[QODBC-Desktop] How to setup QODBC to run without QuickBooks
Posted by Rajendra Dewani (QODBC Support) on 06 November 2013 11:42 AM

How to setup QODBC to run without QuickBooks

Problem Description

  • I want to use QODBC and does not have QuickBooks program on the machine.
  • Do I need QuickBooks installed on the machine to use QODBC?
  • Can QODBC read directly from QuickBooks company file (.QBW or .QBB)

Solution

QODBC works as a Windows ODBC driver (DLL) for accessing the data contained in QuickBooks. QuickBooks Accounting stores its data in its
own proprietary encrypted file system.

Due to the nature of accounting systems, balancing and transaction integrity, the QuickBooks system prevents all external applications
from directly accessing the data files used by QuickBooks, however, Intuit created a work-around called the QuickBooks SDK (software development kit) which resides inside the QuickBooks application interface.

QODBC allows users of any ODBC compliant front end application to read and write data contained in the QuickBooks system similarly to any other ODBC enabled database by processing commands via the QuickBooks SDK interface in the desktop application, so QODBC will not run if QuickBooks is not installed on the same machine or a connected machine (see: QRemote) because the SDK resides in the application
itself.

QODBC works by accepting SQL (structured query language) commands from applications through the ODBC interface, then converts those calls to navigational XML commands, passing them to the QuickBooks SDK for processing and then returning recordsets that qualify for the query results.

This driver is not a Client/Server product, or a direct database access tool because that method is prohibited by Intuit, but rather communicates directly with the QuickBooks application as it runs.

QuickBooks is a flat file database, and this driver will not change it into a relational database, so keep that in mind when developing with this driver.

QODBC acts as a 'wrapper' around the Intuit SDK so customers can finally get at their QuickBooks data using standard database tools; speeding development time.

When QODBC starts, it will check if QuickBooks is running or not, if not it will launch QuickBooks in the background. QODBC will ask the QuickBooks application to load a certain company file if the company file path is specified.

You can run QuickBooks on the desktop or you can run it in "hidden" mode (see links below). Either way it is running, the only difference is whether you see it on the desktop or not.

How to setup QODBC for Auto-login into QuickBooks

How to setup QODBC Driver to auto-connect to QuickBooks. (Video)

Note: QuickBooks requires you to approve the security settings for QODBC to allow it to access the data in QuickBooks one time for each application/company file combination. After this step, the connection to data in QuickBooks can be fully automated and not require user input.

 

 

Tags : QuickBooks start, QuickBooks autostart, QuickBooks startup, QuickBooks connect, Hidden QuickBooks,Quiet QuickBooks, Silent QuickBooks, Background QuickBooks, How to setup QODBC for Auto-login into QuickBooks, process for automatically start of QuickBooks, QuickBooks auto matic, automatic quick books, autostart QuickBooks,automatically start of Quickbooks, running QuickBooks automatic, autologin, Connection to data does not work unless Quickbooks is running even though I have that option turned on in the QODBC control panel, how to run without QuickBooks

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).