Activation / Deactivation
Connection
QODBC cannot push or pull data from QuickBooks if your application is not running. A connection has to be initiated from your application.
Please refer to the QODBC Tutorials for Popular Software Titles.
Please refer to the article – How to configure QODBC to work with 64-bit applications
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
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)
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
Please refer to QODBC Tutorials for Popular Software Titles
Please refer to QODBC Users Manual – first time setup issues
QODBC Desktop Quick Start Guide PDF document
QODBC Online Quick Start Guide PDF document
QODBC POS Quick Start Guide PDF document
Test Connection Button On QODBC Setup Is Greyed/Disabled
why is the QODBC driver so slow
QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator
Connecting to QuickBooks failed because of a Windows security issue
QODBC Shows the login page & login window when connecting with QuickBooks Online Edition
Installation
Please refer to the link How do I download and install QODBC
Please refer to the following page for How to download and install QODBC?
Please refer to the following page forHow to download and install QODBC Online?
Test Connection Button On QODBC Setup Is Greyed/Disabled
why is the QODBC driver so slow
QuickBooks Data DSN Not Showing Up In ODBCAD32.exe ODBC Data Source Administrator
Connecting to QuickBooks failed because of a Windows security issue
QODBC Shows the login page & login window when connecting with QuickBooks Online Edition
DCom Option / Server Edition Tab missing in QODBC Setup Tab
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.
Licensing
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)
QODBC is licensed on a per machine basis and not on a concurrent user basis. You would need 2 QODBC licenses for 2 machines.
Please refer to QODBC Version Differences
Please refer to the link Which versions of QuickBooks are supported
Microsoft Office
How to Use QODBC with MS Excel 2016 / 365 / 2013 32-Bit
How to Use QODBC with MS Access 2016 / 365 / 2013 32-bit
How to Use QODBC with MS Access 2016 / 365 / 2013 32-bit (Import Tables)
How to Configure QODBC to Work With Excel 2016 64-bit
How to Configure QODBC to Work With Access 2016 64-bit
How to Use QODBC with MS Excel 2010
How to Use QODBC with Microsoft Access 2010
How to Use QODBC with MS Excel 2007
How to Use QODBC with Microsoft Access 2007
How to Configure QODBC to Work With 64-bit MS Excel
How to Configure QODBC to Work With 64-bit MS Access
Accessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)
Please refer to QODBC Tutorials for Popular Software Titles
Your Power BI, MS Access, MS Excel, etc. will initiate QuickBooks or the application connection.
Purchase
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
Please refer to the link Details on what QuickBooks data is available via QODBC
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
Click here to upload files requested by the Support Department.
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 herefor further details.
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
To be alerted to news about QODBC, product releases, beta test cycles, new features, and promotions, click here.
See the document here:FLEXquarters.comServiceLevelAgreement.pdf
Please refer to the link Which versions of QuickBooks are supported
References
QODBC cannot push or pull data to your application automatically. It is always on demand and has to be initiated by your application.
QODBC cannot push or pull data from QuickBooks if your application is not running. A connection has to be initiated from your application.
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.
Please refer to theData Layouts article.
Please refer to the link Details on what QuickBooks data is available via QODBC
Yes, please download the QODBC User’s Manual – first time setup issues
Please refer to the article Function Reference
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.
Please refer to QODBC Version Differences
Download the QODBC White Paper PDF document
QODBC Desktop Quick Start Guide PDF document
QODBC Online Quick Start Guide PDF document
QODBC POS Quick Start Guide PDF document
Please refer to the link SQL Language Support (Syntax)
Please refer to Stored Procedures
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.
Please refer to the page Details on what QuickBooks data is available via QODBC for details regarding tables, fields, and reports available in QODBC.
Please refer to support.QODBC.com
To be alerted to news about QODBC, product releases, beta test cycles, new features, and promotions, click here.
Download the Quick Start Guide using the following link. QODBC Quick Start Guide PDF document
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.
Please refer to versions of QuickBooks supported.
Your Power BI, MS Access, MS Excel, etc. will initiate QuickBooks or the application connection.
Remote Connection
Please refer to the article – How to configure QODBC to work with 64-bit applications
How to configure QODBC to work with 64-bit applications
Also, refer to
How to remove QRemote from Startup
How to create or configure a QRemote DSN
How to turn On/Off Encryption on QRemote
How to run QRemote Server as a Service
How to add QRemote to Startup
Troubleshooting – Listening failed. QRemote Server is shutting down in 15 Sec
Troubleshooting – QRemote Initialization Error, Error: Listening failed. Please restart application
Troubleshooting – QRemote Error “Could not connect to server/QRemoteServer”
Troubleshooting – “Wrong Client EncyptKey Setting” error
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.
Security
No
The optimizer file/database is encrypted and can only be used when using with QODBC.
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.
We are sorry, but we cannot disclose the information.
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.
Please refer to https://qodbc.com/links/3015
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.
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.
QODBC uses 256-Bit AEC encryption.
We are sorry, but we cannot disclose the information.
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.
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.
