Knowledgebase: QODBC
[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 try to open 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.

When you execute query directly without specifying ItemInventoryAssemblyRef(ListID or FullName) and TxnDate, then you will get this error.

So you need to execute the query with ItemInventoryAssemblyRef(ListID or FullName) and TxnDate through custom query.

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

You need to write the query in MS Access from: MS Access >> create tab >> Query Design

Select Pass-Through >> Write query >> Execute the query using 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).