Having trouble logging in or locating tickets ?


 

RSS Feed
News
Aug
23
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 10:14 AM

 

Installation Issues
First Time / Demonstration
Activation / Deactivation
QODBC Server Edition
MS Access/Excel
Misc. Technical
SQL Language Support (Syntax)
Troubleshooting

 

Installation 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

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 when 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

 

 

First Time / Demonstration

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)

How to setup QODBC to run without QuickBooks

Accessing QuickBooks Data Remotely using QODBC & QRemote. (Video)

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

 

Activation / Deactivation

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

How to deactivate QODBC and How to transfer the license to a new computer

This function requires activation of QODBC ReadWrite or Server Edition

Authorized Quantity for CDKey: has been exhausted

More FAQ - Activation / DeActivation

 

 

QODBC Server Edition

How to create a Link Server with MS SQL 2005/2008/2012 64-Bit Using QODBC/QRemote

How to create a Link Server with MS SQL 2005/2008/2012 32-Bit Using QODBC/QRemote

How to create a Link Server with MS SQL 2005/2008/2012 32-Bit Using QODBC using DCom

Using QuickBooks data with MS SQL Server using QODBC Driver and QRemote (Video)

How to do INSERTs, UPDATEs, and DELETEs using OPENQUERY with Linked MS SQL Servers

 

 

MS Access/Excel - 64-Bit - For QuickBooks 2022 or above

How to Use QODBC with MS Excel 2016 / 365 / 2013 / 2019 64-Bit (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 64-bit (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 64-bit (Import Tables) (Minimum requirement: QuickBooks 2022 64-Bit and QODBC 2023)

 

MS Access/Excel - 32-Bit

How to Use QODBC with MS Excel 2016 / 365 / 2013 / 2019 32-Bit

How to Use QODBC with MS Access 2016 / 365 / 2013 / 2019 32-bit

How to Use QODBC with MS Access 2016 / 365 / 2013 32-bit (Import Tables)

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

Accessing QuickBooks data with QODBC Driver using MS Excel 2010 & MS Access 2010 (Video)

How to Use QODBC with MS Access

 

MS Access/Excel - 64-Bit - For QuickBooks 2021 and older 

How to Configure QODBC to Work with Excel 2016 64-bit

How to Configure QODBC to Work with Access 2016 64-bit

How to Configure QODBC to Work With 64-bit MS Excel

How to Configure QODBC to Work With 64-bit MS Access

 

MS Access/Excel - Troubleshooting 

MS Excel 2013 or Access 2013 (Office 365) crashes when trying to connect to QuickBooks Data.

QODBC shows a RegFile1 License error when using MS Excel 2013 or Access 2013

QODBC shows a RegFile1 License error when using MS Excel 2013 or Access 2013, Excel Crash, Access Crash (Video)

MS Excel 2013 or Access 2013 shows This function requires activation of QODBC Read-Write or Server Edition.

 

 

QODBC / QRemote license

QODBC Licensing Information

QODBC with QRemote Licensing Information

 

Misc. Technical

How to get information on QODBC Tables and Columns

SQL ODBC Syntax Details

QODBC Setup Options - QODBC For QuickBooks Enterprise Users

How to use the QuickBooks Reporting Engine with QODBC

How to execute SP_OPTIMIZEUPDATESYNC or SP_OPTIMIZEFULLSYNC for Selected Tables

Getting a limited number of records or Few of the records is Missing in QODBC Table result

How to use QODBC and does not have a QuickBooks program on the machine

How to configure QODBC to work with 64-bit applications

How to build a QuickBooks IIS Web application using QODBC Driver and Microsoft ASP.NET (Video)

Unrecoverable error when opening QuickBooks after updating to 2012 R14

QBXML components have not been installed. / Error Getting Version /QODBC Requires API version 1.1 or 2.0 to communicate with QuickBooks

Error after QuickBooks 2014 R6 Update, The procedure entry point EnumProcessModuleEx could not be located in the dynamic link library PSAPI.DLL

QODBC Evaluation Period Expired after upgrade to Intuit Enterprise 2014 (QBES 14.0)

Known issues with QuickBooks 2014 SDK

QODBC Online version 14 is Discontinued

QODBC is missing tables and fields after upgrading to QuickBooks 2014 R6

QRemote Error "Could not connect to server/QRemoteServer"

How to remove QODBC Related Certificates from Integrated Applications under QuickBooks

How to cancel the subscription of QODBC Driver for QuickBooks Online

How to cancel the subscription of QXL Online for QuickBooks Online

 

 

SQL Language Support (Syntax)

SQL Language Support (Syntax) [QODBC-ALL] & [QXL-ALL]

[QODBC-ALL] Stored Procedures Command List

[QQODC- ALL] Function List

[QXL-ALL] Stored Procedures Command List

[QXL- ALL] Function List

SQL ODBC Syntax Details

 

 

Troubleshooting

Troubleshooting - [Fixed] QODBC Extremely Slow After Latest QuickBooks 2017 R5 Update

Troubleshooting - [Fixed] Microsoft Excel/Access 365/2016 - Invalid Certificate error/Digital Signature error/Certificate Error

Troubleshooting - QODBC licensing issues with Windows 10 upgrades


Comments (15)
Stan Smith
01 November 2012 03:10 PM
I can't get qodbc to work with my company file. How can I get a refund? I just purchased yesterday.

Thanks
leo
18 December 2012 05:15 PM
qodbc having issue with character encoding after export to access. is there any faq for that?
Mike Merwin
14 January 2013 04:25 PM
When trying to update a record through MS Access, I get the following error. "ODBC - update on a linked table 'Item' failed. [QODBC] Not supported (#10003)". I am using the trial version to test it out before purchasing and have the use DCOM Servers box setting checked and am able to get into the tables to view fine, just can't update anything.
ben cohen
25 January 2013 06:28 PM
I've purchased 2013 readonly USA version. Will it allow me to connect to QBW company data file on server over LAN without any instance of QB running or must it be like the VB example: on same machine with QB running? If later can I return for refund?
Ankky Wang
22 May 2013 08:25 PM
QODBC problem (the time it takes too long)

Hi

My name is Ankky, My boss Kaylon has been in contact with you. We would like buy your QODBC product, and you gave us 30 day evaluation CDkey.

I am writing the details about what the problem is with the QODBC and using a SQL Server “Linked Server” setup to connect with QuickBooks.

for example, I insert 1 row data from SQL Server into QuickBooks, it takes just 1 second if the company file of QuickBooks is empty. But it takes over 1 hour if the table of QuickBooks has been exist 10,000 rows.

for example, I select all data from the table ReceivePaymentLine of QuickBooks with QODBC, it takes just 2 minutes if the table ReceivePaymentLine only has 1000 rows data . But it takes over 1 hour if the table ReceivePaymentLine has over 20,000 rows data.

Usually, it has over 100,000 rows each table we used in QuickBooks, So the time it takes too long.
Could you please help us fix the problem or tell me how to set up QODBC?

Here is your 30 day evaluation CDkey:
Registration Name: Test User-Kaylon Brown
Product Ordered: QODBC Extended Evaluation Driver for QuickBooks USA 2013 Read Write
Product Code: 4452-Q3ABX
User Count: 1
CDKey Code: 6583-6387-3539-8038

This CDKey code will register the number of machines shown in the User Count field.

Best Regards,
Ankky Wang
Jason Pistorius
19 February 2014 02:35 PM
I am trying to find the paycheck detail through access. I went through each table and still cannot find ANYTHING regarding payroll. Am I missing a setting?
Jack
08 July 2014 10:47 AM
Hi Jason,

You can find paycheck related details in QODBC Transaction table.
Garnet Pettway
22 December 2014 06:18 PM
I submitted for a rebate on driver Qodbc for 2015 QuickBooks but I have not received anything. It has been three weeks since I mail the forms. Is this normal and how will I get the rebate by mail or email?
Thanks
Garnet
Jack
23 December 2014 07:59 AM
Hi Garnet,

We didn't receive any request for a rebate from your end. I kindly request you to raise a support ticket with "Sales - Registration - Activation Department":

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit
Kenny Liew
28 February 2015 03:46 PM
I just brought the QOBDC POS server edition. I created a FTP program in foxpro to upload the sales data to HQ daily. The program work if I manuallty run it. (Once a while it ask me to Click "Allow access" for the Flexquarters Certificate). Somewhile the same program cannot run when I put it in the Schedule Task on Windows Server 2008 r2. Please help.
Jack
02 March 2015 11:24 AM
Hi Kenny,
I would like to inform you that as QuickBooks/QuickBooks POS and QODBC are desktop base application/driver.
I would suggest you to create a desktop base application instead of Windows Service.

When an Application is Windows Service/IIS/Webserver/SQL Server ( any service based application) and is using QODBC you will needs a QODBC Server License.
I would like to inform you that QuickBooks required Active Desktop Session for running. You need to log in to server & run QuickBooks for work with QODBC. If no one logged on server you will get error "Could not start QuickBooks", So I would like to suggest you to that server need Active Desktop Session & QuickBooks in running mode for proper functionality.
I would like to suggest you to Keep QuickBooks running (No need to login to company file, just keep QuickBooks window open) and try to connecting using QRemote.

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC POS Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC POS Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC POS Setup Screen -- > Messages -- > Review SDK Messages
Maggie Dawson
30 March 2015 05:42 PM
Is there any way to create a new customer in Quickbooks from Access using this driver?
Jack
31 March 2015 11:11 AM
Hi Maggie,

Yes, you can create a new customer in Quickbooks from Access using QODBC.
First of all please create new MS Access database & link Customer table.

Please refer below mentioned article for How to Use QODBC with Microsoft Access:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2448/0/how-to-use-qodbc-with-microsoft-access-2007

After linking table, we need to execute query in MS Access query editor:
MS Access>> create tab >> Query Design >> It should popup for choosing table, please click "close" button & click on "SQL" from left top corner below File menu & execute below sample query:

Insert into Customer (Name) values ('ABC')
Note: You can include other insertable fields as per your requirement.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2582/44/how-to-create-invoices-through-ms-access-using-qodbc

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
christian raynor
01 December 2015 06:00 PM
Hello - what method should be used if we are trying to import data from Access 2010 into Quickbooks 2013? Is there a tutorial for this? I found one for linked tables and it seems that it will update changes you make in Access in QB
Jack
03 December 2015 08:38 AM
Hi Christian,

You can write data into QuickBooks from MS Access using VBA scripts. Please refer below mentioned article for sample VBA code:

http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2571/0/using-quickbooks-data-with-vba
Above article shows 32-Bit MS Office & used "QuickBooks Data" DSN. For 64 Bit MS Office you need to use QRemote 64 bit DSN "QuickBooks Data 64-Bit QRemote".

Also, you can write data in Quickbooks from Access using QODBC.

Please refer below mentioned article for How to Use QODBC with Microsoft Access:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2448/0/how-to-use-qodbc-with-microsoft-access-2007

After linking table, you need to execute query in MS Access query editor:
MS Access>> create tab >> Query Design >> It should popup for choosing table, please click "close" button & click on "SQL" from left top corner below File menu & execute below sample query:

For Example:
Insert into Customer (Name) values ('ABC')
Note: You can include other insertable fields as per your requirement.

Please refer:
http://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2582/44/how-to-create-invoices-through-ms-access-using-qodbc

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).