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.

Datawindow Error

2 posts in Appeon (partner product) Last posting was on 2011-03-29 02:14:38.0Z
Robert Posted on 2011-03-28 18:07:21.0Z
Sender: 7ad1.4d90c62a.1804289383@sybase.com
From: Robert
Newsgroups: sybase.public.appeon
Subject: Datawindow Error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d90ce59.7cd0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Mar 2011 10:07:21 -0800
X-Trace: forums-1-dub 1301335641 10.22.241.41 (28 Mar 2011 10:07:21 -0800)
X-Original-Trace: 28 Mar 2011 10:07:21 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2658
Article PK: 21807

Heterogeneous queries require the ANSI_NULLS and
ANSI_WARNINGS options to be set for the connection.

I get this when trying to retrieve the contents of a dw from
an SP.

Even if I do this at the top of the SP:
set ANSI_NULLS ON
SET ANSI_WARNINGS ON

I still get the error. Note sure where to fix this from
Appeon.


Steven Posted on 2011-03-29 02:14:38.0Z
Sender: 1053.4d9137d6.1804289383@sybase.com
From: steven
Newsgroups: sybase.public.appeon
Subject: Re: Datawindow Error
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4d91408e.1173.1681692777@sybase.com>
References: <4d90ce59.7cd0.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Mar 2011 18:14:38 -0800
X-Trace: forums-1-dub 1301364878 10.22.241.41 (28 Mar 2011 18:14:38 -0800)
X-Original-Trace: 28 Mar 2011 18:14:38 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2659
Article PK: 13540

Hi Robert,

Please try to use the solution below to solve your issue.
http://support.microsoft.com/kb/296769

If this solution can’t solve your issue, please provide
the store procedure syntax and datawindow syntax to us.

Regards,
Steven