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 QuickBooks Online folder in 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

Purchase QODBC Online Now option will navigate you to QODBC website for purchasing a QODBC Online license.  

4. QODBC Online Quick Start Guide

QODBC Online Quick Start Guide option will open a start guide which will guide you to how to use QODBC Online.  

5. QODBC Online Setup Screen

QODBC Online Setup Screen option will help you to configure different setup option in QODBC Online.  

6. QRemote Server for QODBC Online

QRemote Server for QODBC Online option will help you to start QRemote Server if it is not running.  

7. QuickBooks Online Table Schema

QuickBooks Online Table Schema option will navigate you to QuickBooks Online table Schema/Data Layout page.  

8. README File

README File option will open a readme file which contains information about instructions on how to install the QODBC Online, how to use the basic functions of the QODBC Online, and what the QODBC Online does. It also includes a list of recent updates made to the QODBC Online.  

9. 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 older QODBC Online version & install newer QODBC version at that time Uninstall QODBC Online option will help you.  

10. VB Demo

VB Demo is testing tool is available with QODBC Online which useful in testing connection with QuickBooks Online. VB Demo also useful query table data. VB Demo also can perform insert/update/delete operation using standard SQL language.

(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).