[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.
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
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.
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.
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.
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.
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.
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
Tags: QuickBooks First time, QODBC First step, QuickBooks startup, Connect QuickBooks, how to use qodbc