Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting - Error 3120 - Object X specified in the request cannot be found.
Posted by Jack - QODBC Support on 12 April 2017 12:53 PM

Troubleshooting - Error 3120 - Object X specified in the request cannot be found.

Problem Description:

I could link all tables to an MS Access DB from QuickBooks Database.

But I got the following error when I tried to open the ItemAssembliesCanBuild table.

ERROR [00000] [QODBC] Error: 3120 - Object "X" specified in the request cannot be found.

Solution:

ItemAssembliesCanBuild Query does require ItemInventoryAssemblyRef(ListID or FullName) and TxnDate in the WHERE Clause to perform the query in QuickBooks SDK.

You will get this error when you execute a query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate.

So it would be best to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through a custom query.

For Example:
SELECT * FROM ItemAssembliesCanBuild where ItemInventoryAssemblyRefFullName='Inventory Door Kit' and TxnDate={d'2017-12-15'}

It would be best if you wrote the query in MS Access from MS Access >> create tab >> Query Design.

Select Pass-Through >> Write query >> Execute the query using the Run button.

Select DSN & execute the query.

Query executed successfully & result available.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).