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.

What database would you recommend using?

7 posts in General Discussion Last posting was on 2004-02-20 02:14:46.0Z
Wala Posted on 2004-02-19 16:20:58.0Z
Sender: 57ce.4034e1d9.1804289383@sybase.com
From: Wala
Newsgroups: ianywhere.public.general
Subject: What database would you recommend using?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4034e26a.57de.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Feb 2004 08:20:58 -0800
X-Trace: forums-1-dub 1077207658 10.22.241.41 (19 Feb 2004 08:20:58 -0800)
X-Original-Trace: 19 Feb 2004 08:20:58 -0800, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2550
Article PK: 5694

Fellow Sybase DB users

We are thinking of using a Sybase Adaptive Server Database
8.0 for a Visual/web Application. I have a few questions
regarding the database:

1. Can a runtime only database be used to create or modify
Database tables using SQL script? If not, how are tables
created/modified in a runtime only database?

2. I know that the Runtime only database version only
accepts a maximum of 10 concurrent connections. We are
looking for around 50 connections as a maximum. What would
be the most cost effective database to use in this case?
Essentially we want a max of around 50 connections with the
ability to create and change database table definitions
using SQL script.

We are looking at Sybase, MS SQL Server, ORACLE to find a
cost effective solution. Your opinions, experiences are
requested.
Regards
Wala


Jim Rand Posted on 2004-02-19 17:25:53.0Z
Reply-To: "Jim Rand" <jimrand@ix.netcom.com>
From: "Jim Rand" <jimrand@ix.netcom.com>
Newsgroups: ianywhere.public.general
References: <4034e26a.57de.846930886@sybase.com>
Subject: Re: What database would you recommend using?
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: user-uinj2ph.dialup.mindspring.com
X-Original-NNTP-Posting-Host: user-uinj2ph.dialup.mindspring.com
Message-ID: <4034f1a1@forums-1-dub>
Date: 19 Feb 2004 09:25:53 -0800
X-Trace: forums-1-dub 1077211553 165.121.139.49 (19 Feb 2004 09:25:53 -0800)
X-Original-Trace: 19 Feb 2004 09:25:53 -0800, user-uinj2ph.dialup.mindspring.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2553
Article PK: 5690

Hi Wala,

I've been using Sybase Adaptive Server since it was Watcom version 3.

Here are my thoughts:

1) You can't kill it though I've had some network administrators try really
hard.
2) It is very very fast.
3) It is very affordable

Jim


"Michael Gould" <mgould Posted on 2004-02-19 19:07:43.0Z
From: "Michael Gould" <mgould@*I*h*a*t*e*s**p$a*m*omnicc.com>
Newsgroups: ianywhere.public.general
References: <4034e26a.57de.846930886@sybase.com>
Subject: Re: What database would you recommend using?
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: www.freight-aid.com
X-Original-NNTP-Posting-Host: www.freight-aid.com
Message-ID: <4035097f@forums-1-dub>
Date: 19 Feb 2004 11:07:43 -0800
X-Trace: forums-1-dub 1077217663 68.213.66.210 (19 Feb 2004 11:07:43 -0800)
X-Original-Trace: 19 Feb 2004 11:07:43 -0800, www.freight-aid.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2554
Article PK: 5691

If your looking for a web solution included, look at ASA 9 which now can be
used as a web server.

Regards,

Michael Gould

<Wala> wrote in message news:4034e26a.57de.846930886@sybase.com...
> Fellow Sybase DB users
>
> We are thinking of using a Sybase Adaptive Server Database
> 8.0 for a Visual/web Application. I have a few questions
> regarding the database:
>
> 1. Can a runtime only database be used to create or modify
> Database tables using SQL script? If not, how are tables
> created/modified in a runtime only database?
>
> 2. I know that the Runtime only database version only
> accepts a maximum of 10 concurrent connections. We are
> looking for around 50 connections as a maximum. What would
> be the most cost effective database to use in this case?
> Essentially we want a max of around 50 connections with the
> ability to create and change database table definitions
> using SQL script.
>
> We are looking at Sybase, MS SQL Server, ORACLE to find a
> cost effective solution. Your opinions, experiences are
> requested.
> Regards
> Wala


Jason Hinsperger Posted on 2004-02-19 21:15:16.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <4034e26a.57de.846930886@sybase.com> <4035097f@forums-1-dub>
Subject: Re: What database would you recommend using?
Lines: 64
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: hinsperg-pc1.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-pc1.sybase.com
Message-ID: <40352764$1@forums-1-dub>
Date: 19 Feb 2004 13:15:16 -0800
X-Trace: forums-1-dub 1077225316 172.31.143.226 (19 Feb 2004 13:15:16 -0800)
X-Original-Trace: 19 Feb 2004 13:15:16 -0800, hinsperg-pc1.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2558
Article PK: 5695

Just to clarify your comment from the documentation:
The Adaptive Server Anywhere HTTP server is not meant to replace a corporate
web server. This architecture is still appropriate in situations in which
there will be at least a moderately large volume of requests; however, web
sites that will receive fewer requests can be run directly from Adaptive
Server Anywhere.
Many types of small in-house sights are suited to this configuration. These
include not only small web sites that provide information of interest to a
small audience, but also web interfaces to deployed applications. Rather
than write a traditional GUI interface for a mobile application, a web-based
interface can be provided. This arrangement can significantly reduce the
complexity of deploying such applications, an only the database and database
server must be deployed. Although a web browser is required, one is almost
always already present.


--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions


Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

"Michael Gould" <mgould@*I*h*a*t*e*s**p$a*m*omnicc.com> wrote in message
news:4035097f@forums-1-dub...
> If your looking for a web solution included, look at ASA 9 which now can
be
> used as a web server.
>
> Regards,
>
> Michael Gould
>
> <Wala> wrote in message news:4034e26a.57de.846930886@sybase.com...
> > Fellow Sybase DB users
> >
> > We are thinking of using a Sybase Adaptive Server Database
> > 8.0 for a Visual/web Application. I have a few questions
> > regarding the database:
> >
> > 1. Can a runtime only database be used to create or modify
> > Database tables using SQL script? If not, how are tables
> > created/modified in a runtime only database?
> >
> > 2. I know that the Runtime only database version only
> > accepts a maximum of 10 concurrent connections. We are
> > looking for around 50 connections as a maximum. What would
> > be the most cost effective database to use in this case?
> > Essentially we want a max of around 50 connections with the
> > ability to create and change database table definitions
> > using SQL script.
> >
> > We are looking at Sybase, MS SQL Server, ORACLE to find a
> > cost effective solution. Your opinions, experiences are
> > requested.
> > Regards
> > Wala
>
>


Wala Posted on 2004-02-19 20:03:04.0Z
Sender: 5b28.403515ed.1804289383@sybase.com
From: Wala
Newsgroups: ianywhere.public.general
Subject: Re: What database would you recommend using?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40351673.5b41.846930886@sybase.com>
References: <4034e26a.57de.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 19 Feb 2004 12:02:59 -0800, 10.22.241.42
Lines: 26
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Feb 2004 12:03:00 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Feb 2004 12:03:04 -0800
X-Trace: forums-1-dub 1077220984 10.22.108.75 (19 Feb 2004 12:03:04 -0800)
X-Original-Trace: 19 Feb 2004 12:03:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2555
Article PK: 5693

Anyone care to reply to points 1 and 2?

> Fellow Sybase DB users
>
> We are thinking of using a Sybase Adaptive Server Database
> 8.0 for a Visual/web Application. I have a few questions
> regarding the database:
>
> 1. Can a runtime only database be used to create or modify
> Database tables using SQL script? If not, how are tables
> created/modified in a runtime only database?
>
> 2. I know that the Runtime only database version only
> accepts a maximum of 10 concurrent connections. We are
> looking for around 50 connections as a maximum. What would
> be the most cost effective database to use in this case?
> Essentially we want a max of around 50 connections with
> the ability to create and change database table
> definitions using SQL script.
>
> We are looking at Sybase, MS SQL Server, ORACLE to find a
> cost effective solution. Your opinions, experiences are
> requested.
> Regards
> Wala


Chris Keating (iAnywhere Solutions) Posted on 2004-02-19 20:31:04.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <4034e26a.57de.846930886@sybase.com> <40351673.5b41.846930886@sybase.com>
Subject: Re: What database would you recommend using?
Lines: 82
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <40351d08@forums-1-dub>
Date: 19 Feb 2004 12:31:04 -0800
X-Trace: forums-1-dub 1077222664 172.31.141.1 (19 Feb 2004 12:31:04 -0800)
X-Original-Trace: 19 Feb 2004 12:31:04 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2556
Article PK: 5692


>>1. Can a runtime only database be used to create or modify
>>Database tables using SQL script? If not, how are tables
>>created/modified in a runtime only database?

The runtime engine cannot handle DDL. You can also opt for the personal
server which does not have the limitations of the runtime edition

>>2. I know that the Runtime only database version only
>>accepts a maximum of 10 concurrent connections. We are
>>looking for around 50 connections as a maximum. What
>>would be the most cost effective database to use in this
>> case? Essentially we want a max of around 50
>> connections with the ability to create and change
>> database table definitions using SQL script.

Those connections BTW are limited to the same machine. If you need to
connect in a client/server manner, you will need to look at the network
server.

Your question would be best answered by a member of the iAnywhere Solutions
sales force For product or sales inquiries you can contact iAnywhere
Solutions by calling 1-800-801-2069 within North America. Alternatively, you
can contact us by email at contact.us@ianywhere.com



--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

<Wala> wrote in message news:40351673.5b41.846930886@sybase.com...
> Anyone care to reply to points 1 and 2?
>
>
> > Fellow Sybase DB users
> >
> > We are thinking of using a Sybase Adaptive Server Database
> > 8.0 for a Visual/web Application. I have a few questions
> > regarding the database:
> >
> > 1. Can a runtime only database be used to create or modify
> > Database tables using SQL script? If not, how are tables
> > created/modified in a runtime only database?
> >
> > 2. I know that the Runtime only database version only
> > accepts a maximum of 10 concurrent connections. We are
> > looking for around 50 connections as a maximum. What would
> > be the most cost effective database to use in this case?
> > Essentially we want a max of around 50 connections with
> > the ability to create and change database table
> > definitions using SQL script.
> >
> > We are looking at Sybase, MS SQL Server, ORACLE to find a
> > cost effective solution. Your opinions, experiences are
> > requested.
> > Regards
> > Wala


Raymond Kwong Posted on 2004-02-20 02:14:46.0Z
From: "Raymond Kwong" <raymond.kwong@sybase.com>
Newsgroups: ianywhere.public.general
References: <4034e26a.57de.846930886@sybase.com>
Subject: Re: What database would you recommend using?
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 172.31.141.232
X-Original-NNTP-Posting-Host: 172.31.141.232
Message-ID: <40356d96$1@forums-1-dub>
Date: 19 Feb 2004 18:14:46 -0800
X-Trace: forums-1-dub 1077243286 172.31.141.232 (19 Feb 2004 18:14:46 -0800)
X-Original-Trace: 19 Feb 2004 18:14:46 -0800, 172.31.141.232
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2560
Article PK: 5698

Here are the runtime engine restrictions

1) No transaction log
2) No data definition (so, no CREATE, ALTER...)
3) No stored procedures or triggers
4) No java
5) No remote data access
6) No jConnect access

Usually your application developer would license a copy of non-runtime
engine in which all schema definition changes are made. The databases
created out of the schema then are deployed at the clients using runtime
engines

<Wala> wrote in message news:4034e26a.57de.846930886@sybase.com...
> Fellow Sybase DB users
>
> We are thinking of using a Sybase Adaptive Server Database
> 8.0 for a Visual/web Application. I have a few questions
> regarding the database:
>
> 1. Can a runtime only database be used to create or modify
> Database tables using SQL script? If not, how are tables
> created/modified in a runtime only database?
>
> 2. I know that the Runtime only database version only
> accepts a maximum of 10 concurrent connections. We are
> looking for around 50 connections as a maximum. What would
> be the most cost effective database to use in this case?
> Essentially we want a max of around 50 connections with the
> ability to create and change database table definitions
> using SQL script.
>
> We are looking at Sybase, MS SQL Server, ORACLE to find a
> cost effective solution. Your opinions, experiences are
> requested.
> Regards
> Wala