[QODBC-Desktop] How to Connect to QuickBooks for the First Time
Posted by Michael (QODBC Support) on 29 April 2009 09:37 AM

How to do the connection

Start QuickBooks before using QODBC

     Once the FLEXquarters QODBC Driver for QuickBooks has been successfully installed on your computer, you can begin to use it immediately using the FREE "once-off" 30 Day QODBC Server Edition Evaluation mode.
     To start using QODBC, you first need to run QuickBooks on your computer logged in as an Administrator, and open your company file, or one of the sample company files that came with QuickBooks, as shown here. This is for security reasons.

Running QODBC Test Tool

     Leaving your QuickBooks company to file open, click on Start --> Programs --> QODBC Driver for QuickBooks -->QODBC Test Tool

     You can right-click on the QODBC Test Tool -->>More-->> Pin to taskbar, create a QODBC Test Tool shortcut on taskbar, then you can start it by clicking the shortcut only.

     Click on the QODBC Test Tool icon to launch the program supplied with QODBC.

     To establish a connection, from the dropdown list, select the "QuickBooks Data" DSN, Click on "Connect”.

Connect to QuickBooks

     This will connect you to the current company file opened by QuickBooks after you click Connect.


Troubleshooting Your Connection


Problem Description

     If you receive a QB Open Connection Failed error 80040154 like this:


     Before connecting to QuickBooks, you should check whether QuickBooks is already installed on your computer, if not, please install QuickBooks first, and start QuickBooks before using QODBC, then try to connect it again.

     Or please see Troubleshooting: Begin Session Failed Error=80040154 for more.


Problem Description

     If you receive a QB Open Connection Failed error 80040408 like this:


     Before connecting to QuickBooks, you should check whether your QuickBooks is running, if it is not running or not opening successfully, please check the reason and make sure it running, then try to connect it again. And also we kindly suggest you make sure you have selected the "use the company file that open......." option in QuickBooks Setup Screen -> General page.


Problem Description

     If you receive a QB Begin Session Failed error 80040430 | 80040401d | 80040401a like this:


     You have to authorize QODBC to log into QuickBooks automatically. To do this you must restart QuickBooks and log in as an Administrator and then follow the instructions below.

     Or please see Troubleshooting: Begin Session Failed. Error = 8004041d, 80040418, 8004041a, 80040430 for more.


QuickBooks Integrated Applications with No Certificate

     When QODBC starts, QuickBooks will ask you permission for this driver to access your QuickBooks data. Check the Yes, always allow access even if QuickBooks is not running options and Click Continue to this and the QODBC driver is added to the Integrated Application list.

     Confirm that you want to allow this access by clicking on Yes. This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop.



Check the information, if it's right for you please click Done button, if it's wrong for you please click Go Back.


Allowing Applications to Login Automatically

     From the QuickBooks Edit menu, select Preferences, and then select Integrated Applications. There are often instances in which you want an integrated application designed to share data with QuickBooks to access QuickBooks files automatically, without user intervention. This might permit, for example, a particular application to run during the night when there is no other activity in the company file. Also, QuickBooks doesn't need to be running in the foreground for ODBC compliant applications to access the data files using QODBC while setting in this mode.

    Click the Company Preferences tab and make sure that the Don't allow any applications to access this company file checkbox isn't checked.
    The Notify the user before running any applications whose certificate has expired checkbox can be checked. If it is, however, automatic access will be suspended if the application's certificate expires.
    Select the FLEXquarters QODBC driver you want to run automatically and click Properties.

    Make sure the Allow this application to read modify this company file checked.

    This procedure needs only be done once for each QODBC application to be able to connect with the QuickBooks data from any other ODBC compliant application in the future.

Testing Your Connection

    Now that you have successfully established a connection to your QuickBooks data, it's time to type in your desired SQL query, for example, you can use the default "SELECT * FROM Customer" or type in another table like stock by entering "SELECT * FROM ItemInventory". Click on the Run button and the requested query results will appear! In case you're wondering, the * in the select statement means all columns in that Table.


    Go to: How to setup the QODBC Optimizer and Where are the Optimizer options for the next step.

    You can also see: How to setup QODBC for Auto-login into QuickBooks for more details.

    For troubleshooting connection issue refer: How to use QODBC Support Wizard

    See also: VB Demo is missing

Videos :

Connecting QODBC Driver to QuickBooks for the First Time (Video)

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


Tags: QuickBooks First time, QODBC First step, QuickBooks startup, Connect QuickBooks, how to use qodbc

(372 vote(s))
Not helpful

Comments (1)
20 September 2012 03:26 PM
Now we know who the snseible one is here. Great post!
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).