Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLServer link_server with PowerBuilder 6.5

Status
Not open for further replies.
MiriamH

MiriamH

Programmer
Mar 13, 2003
8
IL
I'm working with PB connected to SQL Server native.
When tring to execute a select statment with link_server I get the error "
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
" I'd like to set the appropriate values (ansi_nulls, ansi_warning) on the connection but I don't know where and how.
Any Ideas?
 
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
Copy file from Sybase db to a network share that powerbuilder user does not have access to
Replies
0
Views
237
CharlesSwaim
C
RubensLott
  • Locked
  • Question
HOW TO SET A PRINTER ON POWERBUILDER 5
Replies
0
Views
167
RubensLott
RubensLott
Eaka
  • Locked
  • Question
How to get date and time from files with Power Builder?
Replies
0
Views
181
Eaka
Eaka
zulmach
  • Locked
  • Question
Fingerprint Reader with PowerBuilder
Replies
1
Views
175
mbalent
mbalent
Eaka
  • Locked
  • Question
appeon powerbuilder 2019
Replies
0
Views
133
Eaka
Eaka

Part and Inventory Search

Sponsor

Back
Top