Skip to content
+1-888-319-3663

COMMUNITY FORUM

Error when creating smartlist based on view with linked server

Adrian Cooke asked 5 years ago
Hi
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
Thanks
Adrian
Answers
Jared Dux Staff answered 5 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. http://www.eonesolutions.com/help-article/kba-01249-h2v0w1/

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