Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Heterogeneous SQL Error

2 posts in DataWindow .NET Last posting was on 2004-08-17 17:18:20.0Z
Sharon Matyskiela Posted on 2004-08-17 15:20:33.0Z
Sender: 6786.41222118.1804289383@sybase.com
From: Sharon Matyskiela
Newsgroups: sybase.public.datawindow.net
Subject: Heterogeneous SQL Error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41222392.67d1.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-2-dub41222392"
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 17 Aug 2004 08:26:10 -0700, 10.22.241.42
Lines: 1489
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 08:11:14 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 08:20:33 -0700
X-Trace: forums-1-dub 1092756033 10.22.108.75 (17 Aug 2004 08:20:33 -0700)
X-Original-Trace: 17 Aug 2004 08:20:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:148
Article PK: 124583

I am attempting to add a SQL query to a datawindow that
joins my database with another SQL Server (distributed
query). Both servers are SQL 2000 and are linked using the
SQL Server Linked Server functionality. Where would I set
the options (ANSI Nulls, etc.) that are mentioned in the
attached error message? Does PB 8.0 allow these distributed
queries? Can you help?


Bruce Armstrong [TeamSybase] Posted on 2004-08-17 17:18:20.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.datawindow.net
Subject: Re: Heterogeneous SQL Error
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <rre4i09h7v8a2qoqbkuct7plcckojvsr93@4ax.com>
References: <41222392.67d1.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.646
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 65.82.134.145
X-Original-Trace: 17 Aug 2004 10:24:00 -0700, 65.82.134.145
Lines: 50
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Aug 2004 10:09:03 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Aug 2004 10:18:20 -0700
X-Trace: forums-1-dub 1092763100 10.22.108.75 (17 Aug 2004 10:18:20 -0700)
X-Original-Trace: 17 Aug 2004 10:18:20 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:154
Article PK: 124586

This doesn't appear to be a DataWindow.Net question. You might want
to post your question in one of the sybase.public.powerbuilder.*
newsgroups. You also might get better results if you (a) don't post
in HTML and (b) don't include attachments, just post the text of the
error message.

On 17 Aug 2004 08:20:33 -0700, Sharon Matyskiela wrote:

>I am attempting to add a SQL query to a datawindow that
>joins my database with another SQL Server (distributed
>query). Both servers are SQL 2000 and are linked using the
>SQL Server Linked Server functionality. Where would I set
>the options (ANSI Nulls, etc.) that are mentioned in the
>attached error message? Does PB 8.0 allow these distributed
>queries? Can you help?

Bruce Armstrong [TeamSybase]
http://www.teamsybase.com

TeamSybase blogs:
http://www.teamsybase.net/blogs

Vote for PocketBuilder in the Mobile Village awards
http://www.mobilevillage.com/awards.htm

Two 3rd party books on developing with PowerBuilder
http://www.pb9books.com?source=newsgroups

Need code sample? Check out CodeXchange:
http://www.codexchange.sybase.com

Preach the gospel at all times. If necessary, use words. - Francis of Assisi
http://www.needhim.org

---------------------------------------------------------------------
DISCLAIMER:

This newsgroup message is only intended for the recipient. Given that it
is a posting to a public newsgroup, that means if you can read this
message then you are the recipient. This message may contain information
that is confidential and protected from disclosure. And then again,
it may not.

Given that TeamSybase members are not employees of Sybase, the contents
of this message do not necessarily represent the views or policies of
Sybase. Given that TeamSybase is a diverse group of users of Sybase
products, the contents of this message do not necessarily represent the
views of a significant number of the members of TeamSybase. Given that the
author has multiple personalities and hears voices in his head, the contents
of this message do not necessarily represent his own views.