I can't get qodbc to work with my company file. How can I get a refund? I just purchased yesterday.

Thanks

qodbc having issue with character encoding after export to access. is there any faq for that?

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.

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?

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

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?

Hi Jason,

You can find paycheck related details in QODBC Transaction table.

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

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

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.

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

Is there any way to create a new customer in Quickbooks from Access using this driver?

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

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

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