Search Support Database
Paid Phone Support
Contact Us

Loading…
  

Frequently asked questions (FAQ)

Connection

a

Can QODBC read my QuickBooks data if my application is not running?

QODBC cannot push or pull data from QuickBooks if your application is not running. A connection has to be initiated from your application.

a

How do you connect to MS Access, MS Excel, or Crystal Report QODBC?

Please refer to the QODBC Tutorials for Popular Software Titles.

a

How to configure QODBC to work with 64-bit applications

Please refer to the article – How to configure QODBC to work with 64-bit applications

a

My application will prompt me to provide credentials to connect to QuickBooks Data. What should I enter?

QODBC (or any Intuit QuickBooks SDK-based application) does not require credentials to connect to the QuickBooks company file. Connection authentication is performed by QuickBooks based on the Integrated application certificate stored in the QuickBooks company file.

If you must provide credentials in your application to connect to the ODBC driver, you can provide any username and password.

Example

username: admin

password: anything

 

username: administrator

password: somerandomtext

First Time / Demonstration

a

How to connect QODBC Online to QuickBooks Online for the First Time?

How to install QODBC Online & Using Microsoft Excel/Access with QODBC (Video)

a

How to connect QODBC to QuickBooks for the First Time?

Please refer to the following article – How to connect QODBC to QuickBooks the first time

Connecting QODBC Driver to QuickBooks for the First Time using QODBC Support Wizard

Connecting QODBC Driver to QuickBooks for the First Time (Video)

How to set up QODBC Driver to auto-connect to QuickBooks. (Video)

a

My application will prompt me to provide credentials to connect to QuickBooks Data. What should I enter?

QODBC (or any Intuit QuickBooks SDK-based application) does not require credentials to connect to the QuickBooks company file. Connection authentication is performed by QuickBooks based on the Integrated application certificate stored in the QuickBooks company file.

If you must provide credentials in your application to connect to the ODBC driver, you can provide any username and password.

Example

username: admin

password: anything

 

username: administrator

password: somerandomtext

a

QODBC Tutorials for Popular Software Titles

Please refer to QODBC Tutorials for Popular Software Titles

a

QODBC Users Manual – first time setup issues

Please refer to QODBC Users Manual – first time setup issues

a

Quick Start Guide

QODBC Desktop Quick Start Guide PDF document

QODBC Online Quick Start Guide PDF document

QODBC POS Quick Start Guide PDF document

a

Troubleshooting installation / first time issues

Test Connection Button On QODBC Setup Is Greyed/Disabled

QODBC hung up, or everything looks locked up, or the Application is Not Responding when fetching QuickBooks Data

why is the QODBC driver so slow

QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator

VB Demo is missing

I cannot find QODBC Driver/QuickBooks Data under system DSN with any application other than the VB Demo

Connecting to QuickBooks failed because of a Windows security issue

Unable to Activate/Deactivate QODBC even though running as Administrator/You do not have Sufficient Permissions

QODBC Shows the login page & login window when connecting with QuickBooks Online Edition

DCom Option / Server Edition Tab missing in QODBC Setup Tab

Licensing

a

How do I cancel my monthly subscription?

How to cancel the subscription of QODBC Driver for QuickBooks Desktop

How to cancel the subscription of QODBC Driver for QuickBooks Online

How to cancel the subscription of QXL Online for QuickBooks Online

a

How do I cancel my monthly subscription?

For QuickBooks Desktop (country edition does not matter) and POS editions there are 3 types of licenses: Read Only Desktop – For extracting data OUT of QuickBooks into applications like Crystal Reports, Power BI, MS Excel etc. for reporting purposes. Read/Write Desktop – For extracting data OUT of QuickBooks and pushing data INTO QuickBooks with database management applications like MS Access, Visual Basic, etc. and 3rd party desktop applications that need to write data INTO QuickBooks. Server Edition – For extracting data OUT of QuickBooks and pushing data INTO QuickBooks with database management applications like SQL Server, Web Server etc. and 3rd party service-based applications that need to read/write data INTO QuickBooks. For the QuickBooks Online editions (country edition does not matter) there is only 1 type of license subscription that can be ordered: QODBC for QuickBooks Online serves as all editions of the driver, Read Only Desktop, Read/Write Desktop and Server editions. (Subject to offering a server edition of QODBC for Online)
a

My QuickBooks is on a 10-user network, and I have 2 users who need to access the QuickBooks data with QODBC. How many licenses do I need?

QODBC is licensed on a per machine basis and not on a concurrent user basis. You would need 2 QODBC licenses for 2 machines.
a

QODBC Version Differences

Please refer to QODBC Version Differences

a

Which QODBC license do I need?

QODBC Licensing Information

QODBC without QuickBooks on the same machine using QRemote Licensing Information

a

Which versions of QuickBooks are supported?

Please refer to the link Which versions of QuickBooks are supported

Purchase

a

Is my Credit Card/Payment Information Secure? What encryption standard do you use?

For online purchases:

FastSpring handles all the payment and payment processing.

FLEXquarters.com Limited or any websites owned by FLEXquarters.com Limited do not collect any payment-related information.

 

https://fastspring.com/blog/secure-payment-forms/

 

For online purchases:

We use Square Virtual Terminal for phone sales.

QODBC Support

a

Details on what QuickBooks data is available via QODBC

Please refer to the link Details on what QuickBooks data is available via QODBC

a

Do you have a discussion list?

Join our open email discussion group, hosted by Google Groups, where you can share tips for using QODBC and learn how others are using the product. When you join, the messages you and the other members post will be emailed to you and to the rest of the group. Sometimes message volume can be a problem, so the signup process includes the ability to “digest” the messages into one email per day. You can also read them from the web page link below. There is advertising included in messages for this list.

Join the discussion list here: https://groups.google.com/g/qodbc

a

How to upload files requested by the Support Department?

Click here to upload files requested by the Support Department.
a

I need phone or remote support help; how can I request for phone support?

Those purchasing the product will receive Free Installation Support for 30 days from the date of purchase. Program anomalies will be addressed at no charge, and updaters posted on our website. Other support requests for configuration, connection, or troubleshooting issues specific to your application or requirements may be subject to a $75 per incident consulting fee.  Program anomalies will be addressed at no charge, and updaters posted on our website. Click here for further details.

a

I need support. How do I contact you?

For our first level free support option, you can create a ticket at http://support.qodbc.com/

For our second level (Remote/Phone/Email) Paid support option, you can create a ticket at https://www.qodbc.com/phsupport.htm

a

Where can I find the Announcement List and stay updated regarding the QODBC release?

To be alerted to news about QODBC, product releases, beta test cycles, new features, and promotions, click here.

a

Where can I find the Service Level Agreement?

See the document here: FLEXquarters.comServiceLevelAgreement.pdf

a

Which versions of QuickBooks are supported?

Please refer to the link Which versions of QuickBooks are supported

References

a

Can QODBC push updated data from QuickBooks to my application?

QODBC cannot push or pull data to your application automatically. It is always on demand and has to be initiated by your application.

a

Can QODBC read my QuickBooks data if my application is not running?

QODBC cannot push or pull data from QuickBooks if your application is not running. A connection has to be initiated from your application.

a

Can QODBC show or provide notification to my application when any data is changed in QuickBooks?

QODBC is able to access data from QuickBooks using the QuickBooks SDK, which is an embedded feature of the QuickBooks Desktop Application. 

The QuickBooks SDK does not provide us with notification of data change.

The QuickBooks SDK does not support webhooks or triggers.

a

Data Layouts

Please refer to the Data Layouts  article. 

a

Details on what QuickBooks data is available via QODBC

Please refer to the link Details on what QuickBooks data is available via QODBC

a

Do you have a user manual for QODBC?

Yes, please download the QODBC User’s Manual – first time setup issues

a

Function Reference supported by QODBC

Please refer to the article Function Reference

a

How does data communication between applications such as Power BI, Crystal Report, and QuickBooks? Is it a persistent connection, or will it be on demand?

The application will connect to the QODBC 32-Bit or 64-Bit Driver.

If you use QRemote, your application will connect to QRemote 32-Bit or 64-Bit Driver.

In the case of QRemote DSN, QRemote Client will connect to QRemote Server, and QRemote Server will connect to QODBC 32-Bit DSN.

All the data exchange between QODBC and QuickBooks uses Intuit’s QuickBooks SDK.

QODBC or QRemote cannot connect directly to the QuickBooks company file.

A few applications example, MS Access, will keep the connection open once a data exchange is demanded. Connection is persistent until your application is running or closes the connection.

All applications must connect, perform data exchange(s) and close the connection. It is always in demand.

a

How to get information on Tables, Columns, and Reports?

How to get information on Tables and Columns

How to use the QuickBooks Reporting Engine with QODBC

a

QODBC Version Differences

Please refer to QODBC Version Differences

a

QODBC White Paper PDF document

Download the QODBC White Paper PDF document

a

Quick Start Guide

QODBC Desktop Quick Start Guide PDF document

QODBC Online Quick Start Guide PDF document

QODBC POS Quick Start Guide PDF document

a

SQL Language Support (Syntax)

Please refer to the link SQL Language Support (Syntax)
a

Stored Procedures supported by QODBC

Please refer to Stored Procedures

a

Where can I find documentation regarding installing and using QODBC?

Please refer to the QODBC Quick Start Guide PDF document for information about ODBC, and how to install and use QODBC for the first time.

a

Where can I find information about tables, fields, and reports available in QODBC?

Please refer to the page Details on what QuickBooks data is available via QODBC for details regarding tables, fields, and reports available in QODBC.

a

Where can I find support websites and support articles?

Please refer to support.QODBC.com

a

Where can I find the Announcement List and stay updated regarding the QODBC release?

To be alerted to news about QODBC, product releases, beta test cycles, new features, and promotions, click here.

a

Where can I find the PDF document for the QODBC Quick Start Guide?

Download the Quick Start Guide using the following link. QODBC Quick Start Guide PDF document

a

Where will the credentials be stored/configured to connect to QuickBooks?

QODBC / QRemote or your application will not require QuickBooks credentials to connect to your QuickBooks company file.

When connecting using QODBC, QuickBooks will ask for “Application Integration Certificate / Permission. Only QuickBooks company file “Admin” can approve the connection. After approval, QuickBooks will save the approval information in the “Integrated Application” section.

Next time when the same application (for example, MS Access, MS Excel, Power BI) tries to connect using QODBC, QuickBooks will check the application that is trying to connect. QuickBooks will then validate the application based on the previous permission and will either allow or deny the connection.

a

Which QuickBooks versions and editions are supported by QODBC?

Please refer to versions of QuickBooks supported.

a

Which system will initiate QuickBooks or the Application connection (Power BI, MS Access, MS Excel, etc.)?

Your Power BI, MS Access, MS Excel, etc. will initiate QuickBooks or the application connection.

Security

a

Can I read data from the Optimizer file without QODBC?

No

The optimizer file/database is encrypted and can only be used when using with QODBC.
a

Does QODBC store my QuickBooks data anywhere on disk?

If you are using optimizer (default is enabled), QODBC will store QuickBooks data on your local disk in an encrypted format.

Optimizer file is generated for each company file, different for each Windows user.

a

How are tables stored in the Optimizer File?

We are sorry, but we cannot disclose the information.

a

How do I verify that executables and binaries are safe and have not been tampered with?

All the executables, installer, and binaries developed by FLEXquarters.com Limited are secured by Digicert Microsoft Authenticode.

You can verify the Digital signature by viewing properties on any of our application/binary files.

 

If the file has been tampered with, FLEXquarters.com Limited digital signature will be automatically removed from that file.

a

How to secure QRemote Data exchange?

Please refer to https://qodbc.com/links/3015

a

Is QRemote Data exchange encrypted by default?

By default, it is not encrypted, assuming you exchange data locally or within the local area network.

 

For WAN/Internet – We highly recommend you turn on encryption before opening the QRemote port to an external network.

a

My QuickBooks and QuickBooks company file is hosted with a hosting company file. Is my QuickBooks company file safe?

Please get in touch with the support or security team of your QuickBooks hosting company. Data security, backup, and other security depend on the hosting company.

a

What encryption does the Optimizer User have?

QODBC uses 256-Bit AEC encryption.

a

What is the password of the Optimizer file?

We are sorry, but we cannot disclose the information.

a

Where will the credentials be stored/configured to connect to QuickBooks?

QODBC / QRemote or your application will not require QuickBooks credentials to connect to your QuickBooks company file.

When connecting using QODBC, QuickBooks will ask for “Application Integration Certificate / Permission. Only QuickBooks company file “Admin” can approve the connection. After approval, QuickBooks will save the approval information in the “Integrated Application” section.

Next time when the same application (for example, MS Access, MS Excel, Power BI) tries to connect using QODBC, QuickBooks will check the application that is trying to connect. QuickBooks will then validate the application based on the previous permission and will either allow or deny the connection.

a

Will applications such as Power BI, Crystal Report, MS Access, and Excel or my custom application connected to QODBC store my QuickBooks Data? Can anyone read that data?

QODBC will provide the requested data to the calling application.

It then depends on the application and you to protect your data.

 

After providing the data to the calling application, QODBC has no control over the calling application and cannot enforce encryption.

Example. You have extracted Invoice data from QuickBooks using QODBC in an Excel file. Now, it is your responsibility to protect the Excel file.

Support Options

Our QODBC Support Wizard (included with QODBC) is a useful tool that can help you with verifying installation and configuration, testing connection to QuickBooks, executing SQL statements, and raising support tickets. Those purchasing the product will receive Free Support via our Technical Support forum. Program anomalies will be addressed at no charge, and updates will be posted on our website. Other support requests for configuration, connection, or troubleshooting issues specific to your application or requirements may be subject to a $75 per incident consulting fee Click here for further details.

Subscribe to QODBC Hot Support News Feed:   RSS   ATOM   follow us in feedly   Add to My Yahoo! What is RSS?