Skip to content


Error when creating smartlist based on view with linked server

Adrian Cooke asked 6 years ago
I get the error below when trying to create a smartlist based on a SQL view that selects from tables on a linked server. I can use this view in SSRS and in SQL Server fine. I’ve tried updating the ODBC without success Is there a work around ?
GPS Error: 58
SQL Error: 7405 [Microsoft][SQL Server Native Client 11.0][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
ODBC Error: 37000
Jared Dux Staff answered 6 years ago
Hi Adrian,
Linked servers are not supported in SmartList Builder.  We do have a help article online that explains what you can do to use your linked server.

If you would like to submit an answer or comment, please sign in to the eOne portal.