Knowledgebase: Connection
[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 connect QODBC to QuickBooks for the First Time

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. Open your QuickBooks company file, or one of the sample company files that came with QuickBooks, as shown here. Log in to the QuickBooks company file as QuickBooks user "Admin" Administrator, and open your company file, or one of the sample company files that came with QuickBooks, as shown here. 

Running QODBC Test Tool

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

     

     Click on the "QODBC Test Tool" or "QODBC 32-Bit Test Tool" icon to launch the program supplied with QODBC.

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

 

When the driver starts, QuickBooks will ask permission for the driver to access your QuickBooks data. Answer “Yes, Always” to this, and the QODBC driver is added to the Integrated Application list.

This will allow applications to integrate with QuickBooks data when QuickBooks is running on the desktop.

There may be 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 on the company file. Also, QuickBooks need not be running on the desktop for ODBC compliant applications to access the data files while set in this mode, because QODBC will start it up in background/hidden mode.

Choose "Yes, always; allow access even if QuickBooks is not running"

Click on the "Yes" button.

If you have multiple users configured in the QuickBooks company file, you may choose the QuickBooks user to be used for auto login. Please choose a user with sufficient permission or may choose "Admin".

Click on the button "Done".

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

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.

 To disconnect, Click the “Disconnect” button.

 

Allowing applications to log in 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.

To change any of these options, from the QuickBooks Edit menu, select Preferences, and then select Integrated Applications.

If you have already configured an auto login user and wish to change the user associated, you may choose a QuickBooks user from the list.

 

Check “Allow this application to access this company file.”

Uncheck “Prompt before Allowing Access.”

Check “Allow this application to log in automatically.”

Check “Allow this application to access Social Security Numbers, cc information, and other personal data if appropriate.

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

Additionally, if you plan to modify the files, you will also need to choose “Multi-User Mode” from the Files menu in QuickBooks to allow this.

 

Testing Your Connection.

After making any changes to the integrated application, please test the connection again.

 

 

 

Add QODBC Test tool to Taskbar.

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

 

 

Troubleshooting Your Connection

Trouble1

Problem Description

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

Solutions

     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.

Trouble2

Problem Description

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

Solutions

     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 is running, then try to connect it again. And we suggest you make sure you have selected the "use the company file that open......." option on the QODBC Setup Screen -> General page.

Trouble3

Problem Description

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

Solutions

     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.

 

Trouble4

Problem Description

     When I try to connect using my application, I get "Application with no certificate":

Solutions

QODBC does have a digital certificate (right-click on fqqb32.dll/properties in the Windows>System 32 Directory), but since your application is trying to access QuickBooks through QODBC and your application does not have a valid digital signature (your application is not signed digitally), QuickBooks will generate the "Application with No Certificate" popup.

It is not mandatory to sign your application, you may continue using QODBC and accept the integrated application certificate. Please refer to the below section.

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.

 

Note: QODBC does have a digital certificate (right click on fqqb32.dll/properties in the Windows>System 32 Directory), but since another application is trying to access QuickBooks through QODBC and QuickBooks does not know what the application is, it generates that message.

     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 the Done button. If it's wrong for you, please click Go Back.

 

 

Connection Related Knowledge Base Articles


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

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

    For troubleshooting connection issues, 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 set up 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))
Helpful
Not helpful

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