- Connie Dove
- PowerBuilder
- Wednesday, 8 February 2023 09:20 PM UTC
I have 2 microsoft sql 2017 servers that I have set up a linked server connection to. I have created a view on server 1 to pull data from a table on server 2. I have a PB2019R3 application that I want to create a report using this view. However when I try to create a datawindow I get the below error. I am using ODBC for the connection to the database.
"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."
Has anyone ran into this and how did you resolve? Thanks
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.