Question

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

Quick Fields Version 8

Updated August 9, 2022

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

replied on August 8, 2022

Is this still an issue with Quick Fields? Appears to be for me. I'm using version QF 11.

0 0

replied on August 9, 2022

Yes this is still an issue. I believe it to be an ODBC driver issue instead of a Laserfiche issue. We just recently had a customer that had to either use a Stored Procedure or change the table schema to dbo.

1 0

You are not allowed to follow up in this post.

Question

Question

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

Answer

Replies

Sign in to reply to this post.