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



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 ( 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


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


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.

Sign in to reply to this post.