[QODBC-Desktop] How to Connect to QuickBooks for the First Time
Posted by Michael 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 VB Demo
Leaving your QuickBooks company to file open, click on Start --> Programs --> QODBC Driver for QuickBooks -->VB Demo
You can right-click on the VB Demo --> Send To --> DeskTop (create shortcut), create a VB Demo shortcut on DeskTop, then you can start it by clicking the shortcut only.
Click on the VB Demo icon to launch the Visual Basic Demo program supplied with QODBC.
Connect to QuickBooks
To establish a connection: From the menu bar select Connections --> Add a new connection
Select the Machine Data Source tab and QuickBooks Data System DSN, Click OK.
This will connect you to the current company file opened by QuickBooks after you click OK.
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 8004041d 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.
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 on 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 Query button and the requested query results will appear! In case you're wondering, the * in the select statement means all columns in that Table.
Alternatively, click on the Tables button to see a list of all the available QuickBooks tables. To disconnect, you can either select Connections --> Remove the connection or Click the Disconnect button.
You can also see: How to setup QODBC for Auto-login into QuickBooks for more details.
See also: VB Demo is missing
Tags: QuickBooks First time, QODBC First step, QuickBooks startup, Connect QuickBooks