Troubleshooting - How to fix duplicate records in the QODBC table.

Problem Description:

I want to cancel my QODBC Driver for QuickBooks Desktop monthly subscription.

How do I cancel the subscription to QODBC Driver for QuickBooks Desktop?

Solution:

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer
or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice

Tags: QuickBooks Desktop, QBD,Desktop Subscription QODBC Desktop, Cancel subscription

Start QuickBooks and log in to the QuickBooks company file as QuickBooks user "Admin".

Connect to QuickBooks Data using the QODBC 32-bit Test Tool.

Execute the following SQL statement.

sp_optimizefullsync TableName

example

sp_optimizefullsync Customer

or

sp_optimizefullsync Vendor

or

sp_optimizefullsync Invoice