Knowledgebase
[QODBC-Desktop] How to use the VB Demo for testing
Posted by Juliet (QODBC Support) on 16 March 2010 05:56 AM

Open a company file in QuickBooks

     First, start QuickBooks and open a company file, your own or a sample company file, log into QuickBooks Company File as Admin.

 

Using VB Demo for testing

Running VB Demo

     Leaving your QuickBooks company file open -> click on Start -> All Programs -> locate the QODBC Driver for QuickBooks program group on your desktop.

     Click on the VB Demo icon to launch the Visual Basic Demo program supplied with QODBC.

     [ Note: For enterprise users - do not get a start menu option, but it is installed at: C:\Program Files\Intuit\QuickBooks Enterprise Solutions x\Components\QODBC\VBDemo32.exe ]

Establish a Connection

     From the menu bar select Connections -> Add a new connection -> select the Machine Data Source tab -> select the System DSN named QuickBooks Data -> Click OK.

    This will connect you to the current company file opened by QuickBooks. Please keep QuickBooks running, log into QuickBooks Company File as Admin. After you click OK if this is the first time this company file has been used by QODBC you will receive a popup from QuickBooks asking you to allow QODBC to run. Choose the Yes, Always option allow the Sensitive data option.

Running test query

     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" or stored procedure like "sp_report ProfitAndLossStandard". 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.

     If you double-click a table name it will alter the SQL to be a SELECT * FROM that table.

 

     And when a query is displayed, if you right click on the column heading you can get information about the column including if it is updateable, insertable and size and so on.

 

Disconnect

      To disconnect, you can either select Connections -> Remove the connection or Click the Disconnect button.

 

 

    See also: VB Demo is missing

(220 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).