I'm receiving the following error when attempting a Lookup in Quick Fields (18.104.22.1683) 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.