Quick Start page for QODBC Driver for QuickBooks


Short tutorials to help you get started with QODBC.

1) Pre-requisites

Introduction about how to use QODBC.

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Client application.

View documentation

2) Installing QODBC Driver for QuickBooks

Information regarding how to install, configure and test QODBC for QuickBooks Desktop.

Tools: Windows Administrator access, QODBC Desktop installer.

View documentation

3) Understanding License Types

Information about different QODBC License Types with diagram.

Topics: QODBC Read Only License, QODBC Read Write License, QODBC Server/Terminal Edition License, QRemote License.

View documentation

4) Activation of a license

Information about how to Activate QODBC License

Topics: Permissions, 32 bit ODBC Administrator

View documentation

5) Deactivation of a license

Information about how to Deactivate QODBC License

Topics: Permissions, 32 bit ODBC Administrator

View documentation

6) Understanding the Optimizer

Information about how QODBC Optimizer works.

Topics: Brief information about how to increase retrieval performance for queries using QODBC Optimizer.

View documentation

7) Connecting to QuickBooks for the first time

Information about how to Connect QuickBooks using QODBC.

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Client application

View documentation

8) Connecting with MS Excel

Information about how to Use QODBC with Microsoft Excel

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Microsoft Excel.

View documentation

9) Connecting with MS Access

Information about how to use QODBC with Microsoft Access

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Microsoft Access.

View documentation

10) Connecting with MS SQL Server

Information about how to create Linked Server with MS SQL

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Microsoft SQL Server.

View documentation

11) Connecting with Terminal Services

Accessing QuickBooks Data Remotely using QODBC & QRemote

Tools: QODBC Desktop, Network connectivity for Remote Computer, Client application.

View documentation

12) Using Programming Language – C# .NET

Sample Code for Inserting InvoiceLine to existing Invoice using C#.NET

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, Visual Studio.

View documentation

13) Using Programming Language – VB.NET

Sample Code for Inserting InvoiceLine to existing Invoice using VB.NET

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, VB.NET.

View documentation

14) Using Programming Language – PHP

Sample Code for Inserting InvoiceLine to existing Invoice using PHP

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, PHP.

View documentation

15) Using Programming Language – VBA

Sample Code for Inserting InvoiceLine to existing Invoice using VBA

Tools: QuickBooks Desktop, QODBC Desktop, QuickBooks company file “Admin” access, VBA.

View documentation

16) Sample Insert queries

Examples of Creating Invoice using QODBC

Tools: QuickBooks Desktop, QODBC Desktop, Client application

View documentation

17) Sample Reports

Information about how to use the QuickBooks Reporting Engine with QODBC

Tools: QuickBooks Desktop, QODBC Desktop, Client application

View documentation

18) Troubleshooting Speed or missing records

Troubleshooting for slow performance of QODBC or missing records problem.

Tools: QuickBooks Desktop, QODBC Desktop, QODBC 32-Bit Test Tool

View documentation

19) How to contact Technical support

Contact QODBC Technical Support team for issue related to conneting QuickBooks.

Topics: Submit Ticket to QODBC Technical Support.

View documentation

20) How to contact Sales/Activation Support

Contact QODBC Sales/Activation Support team for issue related to Sales – Registration – Activation.

Topics: Submit Ticket to QODBC Sales/Activation Support.

View documentation

21) Data Layouts

General table information and How QODBC Interfaces with QuickBooks.

Topics: DETAILED TABLE/FIELD INFORMATION.

View documentation

22) QODBC Quick Start Guide PDF document

QODBC opens up your QuickBooks data to a whole new world of database connectivity.

Topics: Testing Driver Capabilities,How to setup

View documentation

23) QODBC Functions Reference

This is a list of all of the SQL functions supported by the QODBC Driver and their associated syntax.

Topics: This is a list of all of the SQL functions supported by the QODBC Driver and their associated syntax..

View documentation

24) Stored Procedures

This is a list of all of the SQL stored procedures supported by the QODBC Driver and their associated syntax.

Topics: This is a list of all of the SQL stored procedures supported by the QODBC Driver and their associated syntax.

View documentation

25) QODBC Version Differences

QODBC Desktop Edition comes in two flavors for Windows desktop and one for Web Server use.

Topics: QODBC Desktop Edition comes in two flavors for Windows desktop and one for Web Server use.

View documentation

26) QODBC White Paper PDF document

Import and Export QuickBooks data from any application. Using a standard ODBC driver

Topics: QODBC White Paper PDF document.

View documentation