[QODBC-Online] QODBC Online Menu Items
Posted by Jack - QODBC Support on 24 August 2016 09:41 AM
QODBC Online Menu Items
When you install QODBC Online below menu items are created under QODBC Driver for use with the QuickBooks Online folder in the start menu.
1. Configure QODBC Online Data Source 64-bit
Configure QODBC Online Data Source 64-bit option will help you to create/configure QRemote 64-bit DSN, which is used in the 64-bit application.
2. Configure QODBC Online Data Source
Configure QODBC Online Data Source option will help you to create/configure QODBC & QRemote 32-bit DSN, which is used in the 32-bit application.
3. Purchase QODBC Online Now
The purchase QODBC Online Now option will navigate you to the QODBC website for purchasing a QODBC Online license.
4. QODBC Online Quick Start Guide
The QODBC Online Quick Start Guide option will open a start guide that will guide you on how to use QODBC Online.
5. QODBC Online Setup Screen
The QODBC Online Setup Screen option will help you configure different setup options in QODBC Online.
6. QODBC Online Support Wizard
QODBC Online Support Wizard is a tool available with QODBC, which is useful in testing the connection with QuickBooks. QODBC Online Support Wizard is verifying the configuration to connect to QuickBooks, which will help fix the issue. Link location:
7. QODBC Online Test Tool
QODBC Online Test Tool is a tool available with QODBC that is useful in testing queries with QuickBooks. QODBC Online Test Tool also can perform insert/update/delete operations using standard SQL language.
8. QRemote Server for QODBC Online
QRemote Server for QODBC Online will help you start QRemote Server if it is not running.
9. QuickBooks Online Table Schema
The QuickBooks Online Table Schema option will navigate you to QuickBooks Online table Schema/Data Layout page.
10. README File
README File option will open a readme file containing instructions on how to install the QODBC Online, how to use the essential functions of the QODBC Online, and what the QODBC Online does. It also includes a list of recent updates made to the QODBC Online.
11. Uninstall QODBC Online
Uninstall QODBC Online option will uninstall QODBC Online from System. If you are updating QODBC Online version, then you need to uninstall the older QODBC Online version & install the newer QODBC version. At that time, Uninstalling the QODBC Online option will help you.
12. VB Demo
VB Demo is a tool available with QODBC Online, which is helpful in testing connections with QuickBooks Online. VB Demo is also useful for query table data. VB Demo also can perform insert/update/delete operations using standard SQL language.
Tags: QuickBooks Online, QBO, QODBC Online menu, configure QODBC Online
Please refer below mentioned article for How to create Link Server with MS SQL 2005/2008/2012 Using QODBC Online/QRemote.
For 32-Bit SQL Server:
For 64-Bit SQL Server:
I. Is it possible to run a server with both the desktop and online server components loaded?
II. I currently insert invoices using the process you guys suggested of a. post and invoice line with header information, b. retrieve the last transactionid, and c. post the remaining items using the transactionid. Is that the recommended sequence to use with QBOL?
You can use QRemote Server for QODBC Online for working QuickBooks Online & can use QRemote Server for QODBC for working with QuickBooks Desktop.
For inserting Invoice through SQL Server, As this is SQL Server disconnect issue. You may be face same issue with QuickBooks Online also. So use the same sequence with QuickBooks Online.