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.

Sybase Web Products on TRIAL - Need Help!

9 posts in General Discussion (old) Last posting was on 2000-03-24 01:55:33.0Z
lnacpg Posted on 2000-03-22 01:46:32.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 21 Mar 2000 18:46:32 -0700
From: lnacpg <lauren.ablondi@cpginc.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 9
NNTP-Posting-Host: cpg103.cpginc.com 206.19.59.103
Message-ID: <347_38D825F8.A5F45D4B@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25962
Article PK: 155983

Trying to find a step by step doc on how to create PowerSite HTML
datawindows using existing MS SQLServer 7.0 corporate stored procs.
Extensive retrieval args with several SQL statements within the procs.
Can't quite get it to work using "Calling Jag Components Methods in
PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).

TIA,
Lauren


Larry Cermak[Team Sybase] Posted on 2000-03-22 05:21:40.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Date: Tue, 21 Mar 2000 23:21:40 -0600
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_#G1ku$7k$GA.298@forums.sybase.com>
References: <347_38D825F8.A5F45D4B@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25953
Article PK: 154364

Exactly what errors are you getting?
How many retrieval arguments are we talking about? I don't recall how many
the HTMLGenerator component supports, but it's easy enough to customize the
component to handle more.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"lnacpg" <lauren.ablondi@cpginc.com> wrote in message
news:38D825F8.A5F45D4B@cpginc.com...
> Trying to find a step by step doc on how to create PowerSite HTML
> datawindows using existing MS SQLServer 7.0 corporate stored procs.
> Extensive retrieval args with several SQL statements within the procs.
> Can't quite get it to work using "Calling Jag Components Methods in
> PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
>
> TIA,
> Lauren
>


lnacpg Posted on 2000-03-22 21:44:12.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 14:44:12 -0700
From: lnacpg <lauren.ablondi@cpginc.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: multipart/alternative; boundary="------------52F1FE800C06C8CE6D701B9B"
Lines: 188
NNTP-Posting-Host: cpg103.cpginc.com 206.19.59.103
Message-ID: <347_38D93EAC.D1587026@cpginc.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25879
Article PK: 155913

Thanks very much for responding.
1) MASP version:
Created a simple stored proc and used the AI 3.0 to create component on Jaguar.  I drag the stored procedure from PowerSite's Jaguar component section to the HTML page, where it created the Sybase Jaguar MASP object.  When run, it does nothing no error message, no HTML datawindow.  The generated code behind it is as follows:

<!--METADATA TYPE="DesignerControl" startspan
<OBJECT id=DTC1 name=DTC1 classid="CLSID:B6B6EE80-09D6-11D2-99A4-00805F8ACD28">
    <PARAM VALUE="ps_devdump_SQL" NAME=DataConnection></PARAM>
    <PARAM VALUE=DTC1 NAME=Name></PARAM>
    <PARAM VALUE="Appsdldev99_9000" NAME=ServerName></PARAM>
    <PARAM VALUE="prism_devdump_procs/SimpleInvoice/simpleDev2()" NAME=Methods></PARAM>

</OBJECT>
-->
<%
Appsdldev99_9000 = new Object();
function DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2()
{
 var sqlquery = "execute prism_devdump_procs.SimpleInvoice.simpleDev2 " + " ";
 var myconn = psServer.GetConnection('ps_devdump_SQL');
 var mycursor = null;
 if (myconn != null)
 {
  mycursor = myconn.CreateCursor(sqlquery);
 }
 return mycursor;
}
Appsdldev99_9000.prism_devdump_procs = new Object();
Appsdldev99_9000.prism_devdump_procs.SimpleInvoice = new Object();
Appsdldev99_9000.prism_devdump_procs.SimpleInvoice.simpleDev2 = DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2;
%>
<!--METADATA TYPE="DesignerControl" endspan-->

2) HTML datwindow DTC:
Error: ERROR: Retrieve Failed = -1 *****

************************
Code behind it:
<%
 jagConn = new PSJaguarConnection("Appsdldev99:9000", "jagadmin", "", "DataWindow/HTMLGenerator", false);
 dwSource = new PSDataWindowSourceClass("C:/Program Files/Sybase/Shared/PowerBuilder/online/o_acct_rpts.pbl", "d_simple");
 dbConn = new PSConnectionParmsClass("ConnectString='DSN=prism_dev_dump;Description=prism_dev_dump;SERVER=SQLDEV;APP=PowerSite Enterprise;WSID=WEBMASTR;UID=promo_op;PWD=xxx',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'");
 dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource, dbConn);
 dwMine.Generate();
%>

If in SQL Server Query Analyzer execution of stored proc works fine. ?

The corporate stored procs that I really need to use all have 4 or more retrieval args.

Thanks for help,
Lauren Ablondi
 
 

"Larry Cermak[Team Sybase]" wrote:

Exactly what errors are you getting?
How many retrieval arguments are we talking about?  I don't recall how many
the HTMLGenerator component supports, but it's easy enough to customize the
component to handle more.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"lnacpg" <lauren.ablondi@cpginc.com> wrote in message
news:38D825F8.A5F45D4B@cpginc.com...
> Trying to find a step by step doc on how to create PowerSite HTML
> datawindows using existing MS SQLServer 7.0 corporate stored procs.
> Extensive retrieval args with several SQL statements within the procs.
> Can't quite get it to work using "Calling Jag Components Methods in
> PS7.0".  Tried all 3 ActiveX DTC components (MASP etc.).
>
> TIA,
> Lauren
>


Jim O'Neil [Sybase] Posted on 2000-03-22 22:12:08.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 17:12:08 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 107
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D94538.E0449FC1@sybase.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com> <347_38D93EAC.D1587026@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25874
Article PK: 155908


lnacpg wrote:

> Thanks very much for responding.
> 1) MASP version:
> Created a simple stored proc and used the AI 3.0 to create component
> on Jaguar. I drag the stored procedure from PowerSite's Jaguar
> component section to the HTML page, where it created the Sybase Jaguar
> MASP object. When run, it does nothing no error message, no HTML
> datawindow. The generated code behind it is as follows:
>
> <!--METADATA TYPE="DesignerControl" startspan
> <OBJECT id=DTC1 name=DTC1
> classid="CLSID:B6B6EE80-09D6-11D2-99A4-00805F8ACD28">
> <PARAM VALUE="ps_devdump_SQL" NAME=DataConnection></PARAM>
> <PARAM VALUE=DTC1 NAME=Name></PARAM>
> <PARAM VALUE="Appsdldev99_9000" NAME=ServerName></PARAM>
> <PARAM VALUE="prism_devdump_procs/SimpleInvoice/simpleDev2()"
> NAME=Methods></PARAM>
>
> </OBJECT>
> -->
> <%
> Appsdldev99_9000 = new Object();
> function DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2()
> {
> var sqlquery = "execute prism_devdump_procs.SimpleInvoice.simpleDev2
> " + " ";
> var myconn = psServer.GetConnection('ps_devdump_SQL');
> var mycursor = null;
> if (myconn != null)
> {
> mycursor = myconn.CreateCursor(sqlquery);
> }
> return mycursor;
> }
> Appsdldev99_9000.prism_devdump_procs = new Object();
> Appsdldev99_9000.prism_devdump_procs.SimpleInvoice = new Object();
> Appsdldev99_9000.prism_devdump_procs.SimpleInvoice.simpleDev2 =
> DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2;
> %>
> <!--METADATA TYPE="DesignerControl" endspan-->
>
> 2) HTML datwindow DTC:
> Error: ERROR: Retrieve Failed = -1 *****
>
> ************************
> Code behind it:
> <%
> jagConn = new PSJaguarConnection("Appsdldev99:9000", "jagadmin", "",
> "DataWindow/HTMLGenerator", false);
> dwSource = new PSDataWindowSourceClass("C:/Program
> Files/Sybase/Shared/PowerBuilder/online/o_acct_rpts.pbl", "d_simple");
>
> dbConn = new
> PSConnectionParmsClass("ConnectString='DSN=prism_dev_dump;Description=prism_dev_dump;SERVER=SQLDEV;APP=PowerSite
> Enterprise;WSID=WEBMASTR;UID=promo_op;PWD=xxx',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'");
>
> dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource,
> dbConn);
> dwMine.Generate();
> %>
>
> If in SQL Server Query Analyzer execution of stored proc works fine. ?
>
> The corporate stored procs that I really need to use all have 4 or
> more retrieval args.
>
> Thanks for help,
> Lauren Ablondi
>
>
>
> "Larry Cermak[Team Sybase]" wrote:
>
>> Exactly what errors are you getting?
>> How many retrieval arguments are we talking about? I don't recall
>> how many
>> the HTMLGenerator component supports, but it's easy enough to
>> customize the
>> component to handle more.
>>
>> --
>>
>> Larry Cermak [Team Sybase]
>> Corporate Technology Partners, Inc.
>> www.ctpartners.com
>> Web DataWindow Articles
>> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>>
>> "lnacpg" <lauren.ablondi@cpginc.com> wrote in message
>> news:38D825F8.A5F45D4B@cpginc.com...
>> > Trying to find a step by step doc on how to create PowerSite HTML
>> > datawindows using existing MS SQLServer 7.0 corporate stored
>> procs.
>> > Extensive retrieval args with several SQL statements within the
>> procs.
>> > Can't quite get it to work using "Calling Jag Components Methods
>> in
>> > PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
>> >
>> > TIA,
>> > Lauren
>> >
>

MASP and the Web DW are completely different things. With the MASP
approach, you don't get a datawindow displayed, you merely get a cursor
that you can then loop through in DynaScript - so you have to do the
work, it just executes the method for you. Note in the generated code
for example 1, the only thing that really happens is you get a cursor
returned to you, it's up to you to cycle through the cursor to process
the data.

I'm pretty sure you'll not want to do all that, so stick with the WebDW
DTC for now. Now on that particular issue, it just looks like the
retrieve is failing. From the generated code, it doesn't look like
you've specified the retrieval arguments at all from the DTC.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


lnacpg Posted on 2000-03-22 22:54:50.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 15:54:50 -0700
From: lnacpg <lauren.ablondi@cpginc.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 142
NNTP-Posting-Host: cpg103.cpginc.com 206.19.59.103
Message-ID: <347_38D94F3A.45F87C74@cpginc.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com> <347_38D93EAC.D1587026@cpginc.com> <347_38D94538.E0449FC1@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25870
Article PK: 155905

Thanks,
When I used the WebDW DTC initially with the stored proc with 4 retrieval args, I got this message:
Warning: undefined variable dw_dtc.cursor.EOF[EOF] near line 121 in "/prism_devdump_object.htm" Warning: undefined
variable dw_dtc.cursor.GetValue[GetValue] near line 123 in "/prism_devdump_object.htm" Warning: undefined variable
dw_dtc.cursor.MoveNext[MoveNext] near line 138 in "/prism_devdump_object.htm" Warning: undefined variable
dw_dtc.cursor.GetRowCount[GetRowCount] near line 153 in "/prism_devdump_object.htm"
Error(-1):[Microsoft][ODBC SQL Server Driver][SQL Server]A server cursor is not allowed on a stored procedure with
more than one SELECT statement. Use a default result set or client cursor.

For this reason I thought that I needed to go with MASP.

Because I was not able to find anything on the syntax and placement for the stored proc retrieval args with a DTC, I
changed the stored proc to a simple select. It works successfully to retrieve 191 rows executed in SQL Server Query
Analyzer. However, thus far no luck in DTC retrieval either way (MASP or HTML DTC).

"Jim O'Neil [Sybase]" wrote:

> lnacpg wrote:
>
> > Thanks very much for responding.
> > 1) MASP version:
> > Created a simple stored proc and used the AI 3.0 to create component
> > on Jaguar. I drag the stored procedure from PowerSite's Jaguar
> > component section to the HTML page, where it created the Sybase Jaguar
> > MASP object. When run, it does nothing no error message, no HTML
> > datawindow. The generated code behind it is as follows:
> >
> > <!--METADATA TYPE="DesignerControl" startspan
> > <OBJECT id=DTC1 name=DTC1
> > classid="CLSID:B6B6EE80-09D6-11D2-99A4-00805F8ACD28">
> > <PARAM VALUE="ps_devdump_SQL" NAME=DataConnection></PARAM>
> > <PARAM VALUE=DTC1 NAME=Name></PARAM>
> > <PARAM VALUE="Appsdldev99_9000" NAME=ServerName></PARAM>
> > <PARAM VALUE="prism_devdump_procs/SimpleInvoice/simpleDev2()"
> > NAME=Methods></PARAM>
> >
> > </OBJECT>
> > -->
> > <%
> > Appsdldev99_9000 = new Object();
> > function DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2()
> > {
> > var sqlquery = "execute prism_devdump_procs.SimpleInvoice.simpleDev2
> > " + " ";
> > var myconn = psServer.GetConnection('ps_devdump_SQL');
> > var mycursor = null;
> > if (myconn != null)
> > {
> > mycursor = myconn.CreateCursor(sqlquery);
> > }
> > return mycursor;
> > }
> > Appsdldev99_9000.prism_devdump_procs = new Object();
> > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice = new Object();
> > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice.simpleDev2 =
> > DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2;
> > %>
> > <!--METADATA TYPE="DesignerControl" endspan-->
> >
> > 2) HTML datwindow DTC:
> > Error: ERROR: Retrieve Failed = -1 *****
> >
> > ************************
> > Code behind it:
> > <%
> > jagConn = new PSJaguarConnection("Appsdldev99:9000", "jagadmin", "",
> > "DataWindow/HTMLGenerator", false);
> > dwSource = new PSDataWindowSourceClass("C:/Program
> > Files/Sybase/Shared/PowerBuilder/online/o_acct_rpts.pbl", "d_simple");
> >
> > dbConn = new
> > PSConnectionParmsClass("ConnectString='DSN=prism_dev_dump;Description=prism_dev_dump;SERVER=SQLDEV;APP=PowerSite
> > Enterprise;WSID=WEBMASTR;UID=promo_op;PWD=xxx',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'");
> >
> > dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource,
> > dbConn);
> > dwMine.Generate();
> > %>
> >
> > If in SQL Server Query Analyzer execution of stored proc works fine. ?
> >
> > The corporate stored procs that I really need to use all have 4 or
> > more retrieval args.
> >
> > Thanks for help,
> > Lauren Ablondi
> >
> >
> >
> > "Larry Cermak[Team Sybase]" wrote:
> >
> >> Exactly what errors are you getting?
> >> How many retrieval arguments are we talking about? I don't recall
> >> how many
> >> the HTMLGenerator component supports, but it's easy enough to
> >> customize the
> >> component to handle more.
> >>
> >> --
> >>
> >> Larry Cermak [Team Sybase]
> >> Corporate Technology Partners, Inc.
> >> www.ctpartners.com
> >> Web DataWindow Articles
> >> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> >>
> >> "lnacpg" <lauren.ablondi@cpginc.com> wrote in message
> >> news:38D825F8.A5F45D4B@cpginc.com...
> >> > Trying to find a step by step doc on how to create PowerSite HTML
> >> > datawindows using existing MS SQLServer 7.0 corporate stored
> >> procs.
> >> > Extensive retrieval args with several SQL statements within the
> >> procs.
> >> > Can't quite get it to work using "Calling Jag Components Methods
> >> in
> >> > PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
> >> >
> >> > TIA,
> >> > Lauren
> >> >
> >
>
> MASP and the Web DW are completely different things. With the MASP
> approach, you don't get a datawindow displayed, you merely get a cursor
> that you can then loop through in DynaScript - so you have to do the
> work, it just executes the method for you. Note in the generated code
> for example 1, the only thing that really happens is you get a cursor
> returned to you, it's up to you to cycle through the cursor to process
> the data.
>
> I'm pretty sure you'll not want to do all that, so stick with the WebDW
> DTC for now. Now on that particular issue, it just looks like the
> retrieve is failing. From the generated code, it doesn't look like
> you've specified the retrieval arguments at all from the DTC.
>
> --
> Jim O'Neil
> Senior Technical Support Engineer
> Sybase, Inc


Larry Cermak[Team Sybase] Posted on 2000-03-23 04:30:03.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Date: Wed, 22 Mar 2000 22:30:03 -0600
Lines: 169
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_x$7SlHIl$GA.201@forums.sybase.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com> <347_38D93EAC.D1587026@cpginc.com> <347_38D94538.E0449FC1@sybase.com> <347_38D94F3A.45F87C74@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25854
Article PK: 155889

Is the PBL somewhere in the path or did you do absolute pathing?

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"lnacpg" <lauren.ablondi@cpginc.com> wrote in message
news:38D94F3A.45F87C74@cpginc.com...
> Thanks,
> When I used the WebDW DTC initially with the stored proc with 4 retrieval
args, I got this message:
> Warning: undefined variable dw_dtc.cursor.EOF[EOF] near line 121 in
"/prism_devdump_object.htm" Warning: undefined
> variable dw_dtc.cursor.GetValue[GetValue] near line 123 in
"/prism_devdump_object.htm" Warning: undefined variable
> dw_dtc.cursor.MoveNext[MoveNext] near line 138 in
"/prism_devdump_object.htm" Warning: undefined variable
> dw_dtc.cursor.GetRowCount[GetRowCount] near line 153 in
"/prism_devdump_object.htm"
> Error(-1):[Microsoft][ODBC SQL Server Driver][SQL Server]A server cursor
is not allowed on a stored procedure with
> more than one SELECT statement. Use a default result set or client cursor.
>
> For this reason I thought that I needed to go with MASP.
>
> Because I was not able to find anything on the syntax and placement for
the stored proc retrieval args with a DTC, I
> changed the stored proc to a simple select. It works successfully to
retrieve 191 rows executed in SQL Server Query
> Analyzer. However, thus far no luck in DTC retrieval either way (MASP or
HTML DTC).
>
>
> "Jim O'Neil [Sybase]" wrote:
>
> > lnacpg wrote:
> >
> > > Thanks very much for responding.
> > > 1) MASP version:
> > > Created a simple stored proc and used the AI 3.0 to create component
> > > on Jaguar. I drag the stored procedure from PowerSite's Jaguar
> > > component section to the HTML page, where it created the Sybase Jaguar
> > > MASP object. When run, it does nothing no error message, no HTML
> > > datawindow. The generated code behind it is as follows:
> > >
> > > <!--METADATA TYPE="DesignerControl" startspan
> > > <OBJECT id=DTC1 name=DTC1
> > > classid="CLSID:B6B6EE80-09D6-11D2-99A4-00805F8ACD28">
> > > <PARAM VALUE="ps_devdump_SQL" NAME=DataConnection></PARAM>
> > > <PARAM VALUE=DTC1 NAME=Name></PARAM>
> > > <PARAM VALUE="Appsdldev99_9000" NAME=ServerName></PARAM>
> > > <PARAM VALUE="prism_devdump_procs/SimpleInvoice/simpleDev2()"
> > > NAME=Methods></PARAM>
> > >
> > > </OBJECT>
> > > -->
> > > <%
> > > Appsdldev99_9000 = new Object();
> > > function DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2()
> > > {
> > > var sqlquery = "execute prism_devdump_procs.SimpleInvoice.simpleDev2
> > > " + " ";
> > > var myconn = psServer.GetConnection('ps_devdump_SQL');
> > > var mycursor = null;
> > > if (myconn != null)
> > > {
> > > mycursor = myconn.CreateCursor(sqlquery);
> > > }
> > > return mycursor;
> > > }
> > > Appsdldev99_9000.prism_devdump_procs = new Object();
> > > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice = new Object();
> > > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice.simpleDev2 =
> > > DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2;
> > > %>
> > > <!--METADATA TYPE="DesignerControl" endspan-->
> > >
> > > 2) HTML datwindow DTC:
> > > Error: ERROR: Retrieve Failed = -1 *****
> > >
> > > ************************
> > > Code behind it:
> > > <%
> > > jagConn = new PSJaguarConnection("Appsdldev99:9000", "jagadmin", "",
> > > "DataWindow/HTMLGenerator", false);
> > > dwSource = new PSDataWindowSourceClass("C:/Program
> > > Files/Sybase/Shared/PowerBuilder/online/o_acct_rpts.pbl", "d_simple");
> > >
> > > dbConn = new
> > >

PSConnectionParmsClass("ConnectString='DSN=prism_dev_dump;Description=prism_
dev_dump;SERVER=SQLDEV;APP=PowerSite
> > >
Enterprise;WSID=WEBMASTR;UID=promo_op;PWD=xxx',ConnectOption='SQL_DRIVER_CON
NECT,SQL_DRIVER_NOPROMPT'");
> > >
> > > dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource,
> > > dbConn);
> > > dwMine.Generate();
> > > %>
> > >
> > > If in SQL Server Query Analyzer execution of stored proc works fine. ?
> > >
> > > The corporate stored procs that I really need to use all have 4 or
> > > more retrieval args.
> > >
> > > Thanks for help,
> > > Lauren Ablondi
> > >
> > >
> > >
> > > "Larry Cermak[Team Sybase]" wrote:
> > >
> > >> Exactly what errors are you getting?
> > >> How many retrieval arguments are we talking about? I don't recall
> > >> how many
> > >> the HTMLGenerator component supports, but it's easy enough to
> > >> customize the
> > >> component to handle more.
> > >>
> > >> --
> > >>
> > >> Larry Cermak [Team Sybase]
> > >> Corporate Technology Partners, Inc.
> > >> www.ctpartners.com
> > >> Web DataWindow Articles
> > >> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> > >>
> > >> "lnacpg" <lauren.ablondi@cpginc.com> wrote in message
> > >> news:38D825F8.A5F45D4B@cpginc.com...
> > >> > Trying to find a step by step doc on how to create PowerSite HTML
> > >> > datawindows using existing MS SQLServer 7.0 corporate stored
> > >> procs.
> > >> > Extensive retrieval args with several SQL statements within the
> > >> procs.
> > >> > Can't quite get it to work using "Calling Jag Components Methods
> > >> in
> > >> > PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
> > >> >
> > >> > TIA,
> > >> > Lauren
> > >> >
> > >
> >
> > MASP and the Web DW are completely different things. With the MASP
> > approach, you don't get a datawindow displayed, you merely get a cursor
> > that you can then loop through in DynaScript - so you have to do the
> > work, it just executes the method for you. Note in the generated code
> > for example 1, the only thing that really happens is you get a cursor
> > returned to you, it's up to you to cycle through the cursor to process
> > the data.
> >
> > I'm pretty sure you'll not want to do all that, so stick with the WebDW
> > DTC for now. Now on that particular issue, it just looks like the
> > retrieve is failing. From the generated code, it doesn't look like
> > you've specified the retrieval arguments at all from the DTC.
> >
> > --
> > Jim O'Neil
> > Senior Technical Support Engineer
> > Sybase, Inc
>


lnacpg Posted on 2000-03-24 01:55:33.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 23 Mar 2000 18:55:33 -0700
From: lnacpg <lauren.ablondi@cpginc.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 174
NNTP-Posting-Host: cpg103.cpginc.com 206.19.59.103
Message-ID: <347_38DACB15.EE5AB5C5@cpginc.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com> <347_38D93EAC.D1587026@cpginc.com> <347_38D94538.E0449FC1@sybase.com> <347_38D94F3A.45F87C74@cpginc.com> <347_x$7SlHIl$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25776
Article PK: 154341

Sorry for the delay in responding. I took Greg Clausen's suggestion to check
out the eMusic sample to see if there is anything general I am missing.

The .pbl is in the path on application server (separate machine) in path
C:\Program Files\Sybase\Shared\PowerBuilder\online.

"Larry Cermak[Team Sybase]" wrote:

> Is the PBL somewhere in the path or did you do absolute pathing?
>
> --
>
> Larry Cermak [Team Sybase]
> Corporate Technology Partners, Inc.
> www.ctpartners.com
> Web DataWindow Articles
> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>
> "lnacpg" <lauren.ablondi@cpginc.com> wrote in message
> news:38D94F3A.45F87C74@cpginc.com...
> > Thanks,
> > When I used the WebDW DTC initially with the stored proc with 4 retrieval
> args, I got this message:
> > Warning: undefined variable dw_dtc.cursor.EOF[EOF] near line 121 in
> "/prism_devdump_object.htm" Warning: undefined
> > variable dw_dtc.cursor.GetValue[GetValue] near line 123 in
> "/prism_devdump_object.htm" Warning: undefined variable
> > dw_dtc.cursor.MoveNext[MoveNext] near line 138 in
> "/prism_devdump_object.htm" Warning: undefined variable
> > dw_dtc.cursor.GetRowCount[GetRowCount] near line 153 in
> "/prism_devdump_object.htm"
> > Error(-1):[Microsoft][ODBC SQL Server Driver][SQL Server]A server cursor
> is not allowed on a stored procedure with
> > more than one SELECT statement. Use a default result set or client cursor.
> >
> > For this reason I thought that I needed to go with MASP.
> >
> > Because I was not able to find anything on the syntax and placement for
> the stored proc retrieval args with a DTC, I
> > changed the stored proc to a simple select. It works successfully to
> retrieve 191 rows executed in SQL Server Query
> > Analyzer. However, thus far no luck in DTC retrieval either way (MASP or
> HTML DTC).
> >
> >
> > "Jim O'Neil [Sybase]" wrote:
> >
> > > lnacpg wrote:
> > >
> > > > Thanks very much for responding.
> > > > 1) MASP version:
> > > > Created a simple stored proc and used the AI 3.0 to create component
> > > > on Jaguar. I drag the stored procedure from PowerSite's Jaguar
> > > > component section to the HTML page, where it created the Sybase Jaguar
> > > > MASP object. When run, it does nothing no error message, no HTML
> > > > datawindow. The generated code behind it is as follows:
> > > >
> > > > <!--METADATA TYPE="DesignerControl" startspan
> > > > <OBJECT id=DTC1 name=DTC1
> > > > classid="CLSID:B6B6EE80-09D6-11D2-99A4-00805F8ACD28">
> > > > <PARAM VALUE="ps_devdump_SQL" NAME=DataConnection></PARAM>
> > > > <PARAM VALUE=DTC1 NAME=Name></PARAM>
> > > > <PARAM VALUE="Appsdldev99_9000" NAME=ServerName></PARAM>
> > > > <PARAM VALUE="prism_devdump_procs/SimpleInvoice/simpleDev2()"
> > > > NAME=Methods></PARAM>
> > > >
> > > > </OBJECT>
> > > > -->
> > > > <%
> > > > Appsdldev99_9000 = new Object();
> > > > function DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2()
> > > > {
> > > > var sqlquery = "execute prism_devdump_procs.SimpleInvoice.simpleDev2
> > > > " + " ";
> > > > var myconn = psServer.GetConnection('ps_devdump_SQL');
> > > > var mycursor = null;
> > > > if (myconn != null)
> > > > {
> > > > mycursor = myconn.CreateCursor(sqlquery);
> > > > }
> > > > return mycursor;
> > > > }
> > > > Appsdldev99_9000.prism_devdump_procs = new Object();
> > > > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice = new Object();
> > > > Appsdldev99_9000.prism_devdump_procs.SimpleInvoice.simpleDev2 =
> > > > DTC1_prism_devdump_procs_SimpleInvoice_simpleDev2;
> > > > %>
> > > > <!--METADATA TYPE="DesignerControl" endspan-->
> > > >
> > > > 2) HTML datwindow DTC:
> > > > Error: ERROR: Retrieve Failed = -1 *****
> > > >
> > > > ************************
> > > > Code behind it:
> > > > <%
> > > > jagConn = new PSJaguarConnection("Appsdldev99:9000", "jagadmin", "",
> > > > "DataWindow/HTMLGenerator", false);
> > > > dwSource = new PSDataWindowSourceClass("C:/Program
> > > > Files/Sybase/Shared/PowerBuilder/online/o_acct_rpts.pbl", "d_simple");
> > > >
> > > > dbConn = new
> > > >
> PSConnectionParmsClass("ConnectString='DSN=prism_dev_dump;Description=prism_
> dev_dump;SERVER=SQLDEV;APP=PowerSite
> > > >
> Enterprise;WSID=WEBMASTR;UID=promo_op;PWD=xxx',ConnectOption='SQL_DRIVER_CON
> NECT,SQL_DRIVER_NOPROMPT'");
> > > >
> > > > dwMine = new PSDataWindowClass("htmlDW", false, jagConn, dwSource,
> > > > dbConn);
> > > > dwMine.Generate();
> > > > %>
> > > >
> > > > If in SQL Server Query Analyzer execution of stored proc works fine. ?
> > > >
> > > > The corporate stored procs that I really need to use all have 4 or
> > > > more retrieval args.
> > > >
> > > > Thanks for help,
> > > > Lauren Ablondi
> > > >
> > > >
> > > >
> > > > "Larry Cermak[Team Sybase]" wrote:
> > > >
> > > >> Exactly what errors are you getting?
> > > >> How many retrieval arguments are we talking about? I don't recall
> > > >> how many
> > > >> the HTMLGenerator component supports, but it's easy enough to
> > > >> customize the
> > > >> component to handle more.
> > > >>
> > > >> --
> > > >>
> > > >> Larry Cermak [Team Sybase]
> > > >> Corporate Technology Partners, Inc.
> > > >> www.ctpartners.com
> > > >> Web DataWindow Articles
> > > >> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> > > >>
> > > >> "lnacpg" <lauren.ablondi@cpginc.com> wrote in message
> > > >> news:38D825F8.A5F45D4B@cpginc.com...
> > > >> > Trying to find a step by step doc on how to create PowerSite HTML
> > > >> > datawindows using existing MS SQLServer 7.0 corporate stored
> > > >> procs.
> > > >> > Extensive retrieval args with several SQL statements within the
> > > >> procs.
> > > >> > Can't quite get it to work using "Calling Jag Components Methods
> > > >> in
> > > >> > PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
> > > >> >
> > > >> > TIA,
> > > >> > Lauren
> > > >> >
> > > >
> > >
> > > MASP and the Web DW are completely different things. With the MASP
> > > approach, you don't get a datawindow displayed, you merely get a cursor
> > > that you can then loop through in DynaScript - so you have to do the
> > > work, it just executes the method for you. Note in the generated code
> > > for example 1, the only thing that really happens is you get a cursor
> > > returned to you, it's up to you to cycle through the cursor to process
> > > the data.
> > >
> > > I'm pretty sure you'll not want to do all that, so stick with the WebDW
> > > DTC for now. Now on that particular issue, it just looks like the
> > > retrieve is failing. From the generated code, it doesn't look like
> > > you've specified the retrieval arguments at all from the DTC.
> > >
> > > --
> > > Jim O'Neil
> > > Senior Technical Support Engineer
> > > Sybase, Inc
> >


Jim O'Neil [Sybase] Posted on 2000-03-22 23:59:39.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 18:59:39 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 60
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D95E6A.C03E810@sybase.com>
References: <347_38D825F8.A5F45D4B@cpginc.com> <347_#G1ku$7k$GA.298@forums.sybase.com> <347_38D93EAC.D1587026@cpginc.com> <347_38D94538.E0449FC1@sybase.com> <347_38D94F3A.45F87C74@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25858
Article PK: 155893


lnacpg wrote:

> Thanks,
> When I used the WebDW DTC initially with the stored proc with 4 retrieval args, I got this message:
> Warning: undefined variable dw_dtc.cursor.EOF[EOF] near line 121 in "/prism_devdump_object.htm" Warning: undefined
> variable dw_dtc.cursor.GetValue[GetValue] near line 123 in "/prism_devdump_object.htm" Warning: undefined variable
> dw_dtc.cursor.MoveNext[MoveNext] near line 138 in "/prism_devdump_object.htm" Warning: undefined variable
> dw_dtc.cursor.GetRowCount[GetRowCount] near line 153 in "/prism_devdump_object.htm"
> Error(-1):[Microsoft][ODBC SQL Server Driver][SQL Server]A server cursor is not allowed on a stored procedure with
> more than one SELECT statement. Use a default result set or client cursor.
>
> For this reason I thought that I needed to go with MASP.
>
> Because I was not able to find anything on the syntax and placement for the stored proc retrieval args with a DTC, I
> changed the stored proc to a simple select. It works successfully to retrieve 191 rows executed in SQL Server Query
> Analyzer. However, thus far no luck in DTC retrieval either way (MASP or HTML DTC).
>

Does the datawindow retrieve in the DataWindow Builder/PowerBuilder? I suspect you'll end up with the same error
message there too. The error you are getting looks to be outside the scope of the Sybase products and *could* be a
limitation of what you can do with the SQL Server ODBC driver. I did a quick check on the Microsoft site and couldn't
find that specific error mentioned in their knowledgebase, nor could I find in my SQLServer ODBC set up a way to change
the cursor from being a server cursor to a client cursor - if that can even be done. I suspect this also may have
something to do with the specific signature of your stored procedure (i.e., what result set(s) it returns).

Can I suggest that you do two things 1) try previewing the datawindow you've built in just the DataWindow builder or
PowerBuilder and see what happens and 2) create a rinky dink stored procedure that does a select * from customer, for
example, and get the Web DW up and running with that. If one or both fail they we'll have an avenue to pursue and if 2)
works you'll at least have worked through the process of building the WebDW successfully.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Greg Clausen Posted on 2000-03-22 15:33:54.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 22 Mar 2000 10:33:54 -0500
From: Greg Clausen <clausen@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Sybase Web Products on TRIAL - Need Help!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
NNTP-Posting-Host: 158.159.8.47
Message-ID: <347_38D8E7E1.3C01ECA8@sybase.com>
References: <347_38D825F8.A5F45D4B@cpginc.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25931
Article PK: 155959

Try downloading the eMusic "Build the Future" Seminar series zip file. It
contains lots of Web DW stuff as well as step-by-step instructions.
http://www.sybase.com/products/eastudio/emusic.zip

lnacpg wrote:

> Trying to find a step by step doc on how to create PowerSite HTML
> datawindows using existing MS SQLServer 7.0 corporate stored procs.
> Extensive retrieval args with several SQL statements within the procs.
> Can't quite get it to work using "Calling Jag Components Methods in
> PS7.0". Tried all 3 ActiveX DTC components (MASP etc.).
>
> TIA,
> Lauren