Knowledgebase
[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:
For 32-bit System:
C:\Program Files (x86)\QODBC Driver for QuickBooks Online\QSW\QODBCSupportWizard.exe

For 64-bit System:
C:\Program Files\QODBC Driver for QuickBooks Online\QSW\QODBCSupportWizard.exe

 

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



(0 vote(s))
Helpful
Not helpful

Comments (4)
lee church
08 September 2016 07:14 PM
does the menu option "QRemote Server for QODBC online" imply that SQL server scripts can be used to extract/insert data to online QB?
Jack
09 September 2016 11:18 AM
Yes, You can use QRemote Server for QODBC online for extract/insert data to QuickBooks Online using 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:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2666

For 64-Bit SQL Server:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2667
Lee Church
09 September 2016 03:00 PM
So two followups:
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?
Jack
12 September 2016 09:56 AM
Hi Lee,

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.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).