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.

Server side cursors vs client side.

3 posts in Appeon (partner product) Last posting was on 2006-03-14 10:43:51.0Z
Mark S Posted on 2006-03-13 11:41:39.0Z
From: "Mark S" <ssd@xoxo.com>
Newsgroups: sybase.public.appeon
Subject: Server side cursors vs client side.
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: dynamic-acs-24-154-231-223.zoominternet.net
X-Original-NNTP-Posting-Host: dynamic-acs-24-154-231-223.zoominternet.net
Message-ID: <44155a73$1@forums-1-dub>
Date: 13 Mar 2006 03:41:39 -0800
X-Trace: forums-1-dub 1142250099 24.154.231.223 (13 Mar 2006 03:41:39 -0800)
X-Original-Trace: 13 Mar 2006 03:41:39 -0800, dynamic-acs-24-154-231-223.zoominternet.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1368
Article PK: 12963

I'm having a problem with running data window sourced by stored procedures.
The error says that I need to enable server side cursors or clients side
cursors, or something like that. I wish I could say more because this
morning I'm getting empty error messageboxes from the datawindow instead of
the fll error message.

How do I successfully deal with store procedures?

Newbie to EAServer 5.2, Appeon 3.1, SQL Server 5000, PB 10.2.1

--
Mark Schupay
KSI Solutions, LLC
724-316-6782


Mark S Posted on 2006-03-13 20:17:16.0Z
From: "Mark S" <ssd@xoxo.com>
Newsgroups: sybase.public.appeon
References: <44155a73$1@forums-1-dub>
Subject: Re: Server side cursors vs client side.
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: dynamic-acs-24-154-231-223.zoominternet.net
Message-ID: <4415c384$1@forums-2-dub>
X-Original-Trace: 13 Mar 2006 11:09:56 -0800, dynamic-acs-24-154-231-223.zoominternet.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 13 Mar 2006 11:09:59 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 13 Mar 2006 12:17:16 -0800
X-Trace: forums-1-dub 1142281036 10.22.108.75 (13 Mar 2006 12:17:16 -0800)
X-Original-Trace: 13 Mar 2006 12:17:16 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1369
Article PK: 21163

Here is the error message...

[com.appeon.server.services.dataservice.JDataServerRetrieve (executeSql)]
Failed to execute SQL statement
com.microsoft.sqlserver.jdbc.SQLServerException: A server cursor cannot be
opened on the given statement or statements. Use a default result set or
client cursor. due to {1}.


Mark

"Mark S" <ssd@xoxo.com> wrote in message news:44155a73$1@forums-1-dub...
> I'm having a problem with running data window sourced by stored
> procedures. The error says that I need to enable server side cursors or
> clients side cursors, or something like that. I wish I could say more
> because this morning I'm getting empty error messageboxes from the
> datawindow instead of the fll error message.
>
> How do I successfully deal with store procedures?
>
> Newbie to EAServer 5.2, Appeon 3.1, SQL Server 5000, PB 10.2.1
>
> --
> Mark Schupay
> KSI Solutions, LLC
> 724-316-6782
>


Sally Li Posted on 2006-03-14 10:43:51.0Z
From: "Sally Li" <sally.li@appeon.net>
Newsgroups: sybase.public.appeon
References: <44155a73$1@forums-1-dub> <4415c384$1@forums-2-dub>
Subject: Re: Server side cursors vs client side.
Lines: 135
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_00BA_01C6478D.FA5A2390"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
NNTP-Posting-Host: 59.37.60.2
X-Original-NNTP-Posting-Host: 59.37.60.2
Message-ID: <44169e67$1@forums-1-dub>
Date: 14 Mar 2006 02:43:51 -0800
X-Trace: forums-1-dub 1142333031 59.37.60.2 (14 Mar 2006 02:43:51 -0800)
X-Original-Trace: 14 Mar 2006 02:43:51 -0800, 59.37.60.2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1370
Article PK: 12964

Hi Mark,
 
You may not configure the SelectMethod in the Server Name of the connection cache. 
 
Please take the following example as reference to configure the Server Name on your side and note that the bold part is required:
 
jdbc:microsoft:sqlserver://192.0.0.77:1433;DatabaseName=appeontestcase;SelectMethod=cursor
 
 
Regard
Sally Li
 
"Mark S" <ssd@xoxo.com> wrote in message news:4415c384$1@forums-2-dub...
> Here is the error message...
>
> [com.appeon.server.services.dataservice.JDataServerRetrieve (executeSql)]
> Failed to execute SQL statement
> com.microsoft.sqlserver.jdbc.SQLServerException: A server cursor cannot be
> opened on the given statement or statements. Use a default result set or
> client cursor. due to {1}.
>
>
> Mark
>
>
>
> "Mark S" <ssd@xoxo.com> wrote in message news:44155a73$1@forums-1-dub...
> > I'm having a problem with running data window sourced by stored
> > procedures. The error says that I need to enable server side cursors or
> > clients side cursors, or something like that.    I wish I could say more
> > because this morning I'm getting empty error messageboxes from the
> > datawindow instead of the fll error message.
> >
> > How do I successfully deal with store procedures?
> >
> > Newbie to EAServer 5.2, Appeon 3.1, SQL Server 5000, PB 10.2.1
> >
> > --
> > Mark Schupay
> > KSI Solutions, LLC
> > 724-316-6782
> >
>
>