Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Issue with linked server view creating datawindow

  1. Issue
0
Votes
Undo
  1. Connie Dove
    Connie Dove
  2. PowerBuilder
  3. Wednesday, 8 February 2023 21: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

Datawindow CheckBox Control Text (Left Text = ON, ...
SQL Server Examples Database
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 February 2023 21:30 PM UTC
  2. PowerBuilder
  3. # 1

Hi Connie;

  You can set these options ON using your SS Admin tool with the Alter Database command, as follows:

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-ver16

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.