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.

Tutorial bugs in Getting Startup w/ Sybase Ad. Svr. Ent. for NT

2 posts in Windows NT Last posting was on 1998-01-07 17:37:36.0Z
Ross Smith Posted on 1997-12-11 01:35:31.0Z
Message-ID: <348F4362.63482E7C@earthlink.net>
Date: Wed, 10 Dec 1997 17:35:31 -0800
From: Ross Smith <ross777@earthlink.net>
Reply-To: ross.smith@pobox.com
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Tutorial bugs in Getting Startup w/ Sybase Ad. Svr. Ent. for NT
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 60
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5355
Article PK: 1081434

Here's is my experience in following the tutorial found in the manual
Getting Started with Sybase Adaptive Server Enterprise for Windows NT
(Document ID# 36097-01-1150)

pg. 3-20: Task 3: Generate the Database

The generated script CREBAS.SQL contained:

create view artist_club_date as
select EVENT.ARTIST, EVENT.CLUBID, club.NAME, EVENT.THE_DATE,
EVENT.TYPE,
CATEGORY.DESCRIP
from club, CATEGORY, EVENT
where club.CLUBID = EVENT.CLUBID
and CATEGORY.TYPE = EVENT.TYPE

which failed with the error:

Server Message: Number 208, Severity 16
CATEGORY not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).
Server Message: Number 208, Severity 16
EVENT not found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of output).

Selecting Database/Generation Options and selecting Lowercase fixed this
problem by generating the following query which executed successfully:

create view artist_club_date as
select event.artist, event.clubid, club.name, event.the_date,
event.type,
category.descrip
from club, category, event
where club.clubid = event.clubid
and category.type = event.type

which worked fine.


pg. 4-9: Task 3: Open the Data Munipulation Painter for the Category
Table

The manual states:

1. Click the Database button in the PowerBar.

This button does not exist. The tutorial could not be continued.


pg. 5-2: Project One: Developing the Event Listing Report.

The manual states:

Remember that you need to run the script data.sql before doing this
lesson.

The data.sql file on the Sybase Adapter Server Enterprise 11.5 for
Windows NT CD (#T10350) in the d:\tutorial directory ends with the
following:

insert into club
(clubid, name, address, city, phone, capacity)
values
(55, "James Moore Theater", "Oakland Museum, 100 Oak St.", "Oaklan

Obviously, the file was truncated accidentally.

This caused the script to fail when it reached this command. The event
table never gets populated with data.


pg. 6-12 and 6-13: Task 3: Start the Personal Web Server and a Web
Browser

The URL:

http://localhost:90/MusicSit/Calendar.stm

should read:

http://localhost:90/MusicSite/Calendar.stm

I stopped the tutorial at this point.

Feedback Sybase?


Craig Spanburg Posted on 1998-01-07 17:37:36.0Z
Message-ID: <34B3BD60.B23B1D2E@indiana.edu>
Date: Wed, 07 Jan 1998 12:37:36 -0500
From: Craig Spanburg <csspanbu@indiana.edu>
Organization: Indiana University
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: ross.smith@pobox.com
Subject: Re: Tutorial bugs in Getting Startup w/ Sybase Ad. Svr. Ent. for NT
X-Priority: 3 (Normal)
References: <348F4362.63482E7C@earthlink.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 76
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5309
Article PK: 1081386

Ross

I am frustrated by the missing Database button also. Have you found
it? Technical note 44339 says to just customize the PowerBar because it
isn't always put there during installation -- but I haven't found it (or
the other missing buttons) in the list of available buttons in the
Customize window.

I was told by Technical Support and a Marketing Rep that that
feature (along with other features) was left out of the version of
InfoMaker shipped with 11.5.

Craig

Ross Smith wrote:

> Here's is my experience in following the tutorial found in the manual
> Getting Started with Sybase Adaptive Server Enterprise for Windows NT
> (Document ID# 36097-01-1150)
>
> pg. 3-20: Task 3: Generate the Database
>
> The generated script CREBAS.SQL contained:
>
> create view artist_club_date as
> select EVENT.ARTIST, EVENT.CLUBID, club.NAME, EVENT.THE_DATE,
> EVENT.TYPE,
> CATEGORY.DESCRIP
> from club, CATEGORY, EVENT
> where club.CLUBID = EVENT.CLUBID
> and CATEGORY.TYPE = EVENT.TYPE
>
> which failed with the error:
>
> Server Message: Number 208, Severity 16
> CATEGORY not found. Specify owner.objectname or use sp_help to check
> whether the object exists (sp_help may produce lots of output).
> Server Message: Number 208, Severity 16
> EVENT not found. Specify owner.objectname or use sp_help to check
> whether the object exists (sp_help may produce lots of output).
>
> Selecting Database/Generation Options and selecting Lowercase fixed
> this
> problem by generating the following query which executed successfully:
>
> create view artist_club_date as
> select event.artist, event.clubid, club.name, event.the_date,
> event.type,
> category.descrip
> from club, category, event
> where club.clubid = event.clubid
> and category.type = event.type
>
> which worked fine.
>
> pg. 4-9: Task 3: Open the Data Munipulation Painter for the Category
> Table
>
> The manual states:
>
> 1. Click the Database button in the PowerBar.
>
> This button does not exist. The tutorial could not be continued.
>
> pg. 5-2: Project One: Developing the Event Listing Report.
>
> The manual states:
>
> Remember that you need to run the script data.sql before doing this
> lesson.
>
> The data.sql file on the Sybase Adapter Server Enterprise 11.5 for
> Windows NT CD (#T10350) in the d:\tutorial directory ends with the
> following:
>
> insert into club
> (clubid, name, address, city, phone, capacity)
> values
> (55, "James Moore Theater", "Oakland Museum, 100 Oak St.", "Oaklan
>
> Obviously, the file was truncated accidentally.
>
> This caused the script to fail when it reached this command. The
> event
> table never gets populated with data.
>
> pg. 6-12 and 6-13: Task 3: Start the Personal Web Server and a Web
> Browser
>
> The URL:
>
> http://localhost:90/MusicSit/Calendar.stm
>
> should read:
>
> http://localhost:90/MusicSite/Calendar.stm
>
> I stopped the tutorial at this point.
>
> Feedback Sybase?