You are viewing limited content. For full access, please sign in.

Question

Question

ERROR [42S02] Invalid Object Name Error for non-dbo schema Table Lookup

asked on July 15, 2014

I'm receiving the following error when attempting a Lookup in Quick Fields (8.3.0.413) against a SQL Server table that is not part of the "dbo" schema.  I'm using a System DSN to manage the connection to the SQL Server.

 

ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'ServiceRequest'.[Database=] [Method=ExecuteFirstResult] 

 

 

I'm able to configure the Lookup Criteria as I normally would, however the error occurs when the session attempts to perform each lookup during processing.  I can also get the error to occur with the 'Test' link in the Lookup Criteria configuration.

 

I'm able to work around the issue by defining a view in the "dbo" schema and executing the Lookup that way, however this seems like it shouldn't be necessary.

1 0

Answer

APPROVED ANSWER
replied on July 15, 2014

Thanks for reporting the issue. As a workaround, you can write a custom query to perform the lookup and just specify the schema name as part of the table, i.e. [schema].[table_name]

1 0

Replies

replied on August 17, 2017 Show version history

how would this work for Token verification where you can't specify the schema? This is still an issue in Ver 10.0.0

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.