[QODBC-Desktop] How to use the QODBC Test Tool for testing
Posted by Rajendra Dewani (QODBC Support) on 27 December 2022 12:08 PM
|
|
[QODBC-Desktop] How to use the QODBC Test Tool for testingProblem Description:How to use QODBC Test Tool to test my SQL statement? How to test QODBC connection with QuickBooks Data? Solution:Open a company file in QuickBooks. Start QuickBooks and open a company file, your own, or a sample company file. Log into QuickBooks Company File as QuickBooks user "Admin".
Using the QODBC Test Tool for testingRunning the QODBC Test ToolLeaving your QuickBooks company file open ->, click on Start -> All Programs -> locate the QODBC Driver for the QuickBooks program group on your desktop.
Click on the QODBC 32-Bit Test Tool icon to launch it.
Establish a ConnectionFrom the first dropdown, select DSN. From the other dropdown, select the System DSN named QuickBooks Data -> Click Connect.
This will connect you to the current company file opened by QuickBooks. If this is the first time QODBC has used this company file, you will receive a popup from QuickBooks asking you to allow QODBC to run. Choose the, Yes, Always option to allow the Sensitive data option. Running test queryNow that you have successfully established a connection to your QuickBooks data, it's time to type in your desired SQL query. Click on the Run button, and the requested query results will appear! 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." If you're wondering, the * in the select statement means all columns in that table.
Alternatively, Select the Show me the list of tables from the dropdown. OR type in sp_tables command to see a list of tables available in QuickBooks.
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, size, and so on.
DisconnectClick the Disconnect button to disconnect.
Also, refer to
| |
|