Article View: comp.sys.next.software
Article #1778Re: Using Sybase SQL
From: David A. Cheslow
Date: Fri, 08 Jan 1993 16:19
Date: Fri, 08 Jan 1993 16:19
57 lines
2741 bytes
2741 bytes
In article <1993Jan7.213021.18871@wam.umd.edu>
gravatt@next02wor.wam.umd.edu (Robert Howerton Gravatt) writes:
*Stuff deleted here*
>
> My questions are:
>
> A) Is the "Sybase" 4.0.2 the whole enchilata or some subpart that does
> not include SQL Server but only DB-Library ?
>
As I understand it, the sybase server stopped being bundled with version
2.0. There was a little card in the upgrade package from 1.x to 2.x that
would allow academics to obtain the limited server at no charge (I am sure
that the deadline is long past). The Sybase server in now a commercial
item (and it ain't cheap). If you want to create a small, single user
database, I recommend the IndexingKit classes. They are VERY buggy and
usually don't work as advertised, but you can create useful applications
with them.... fast, efficient, etc.
> B) What is an SQL "server" anyway ?
>
SQL is implimented using a client-server arrangement. A client (your
application) makes transaction requests to the server (which runs in the
background on some networked computer). The same server is used by a
number clients simultaniously. It is the servers responsibility to manage
situations like "the deadly embrace" where two or more clients are each
waiting for each other client to complete a transaction before proceding
(an infinite loop) and to improve the performance of transactions on the
database. In other words - the server does all the work.
> C) Assuming that you do not have write permission to /usr/sybase and
wish
> to keep your own personal interfaces file in your home directory, what
do
> you need to have in this file and how do you set the enviroment
variables
> etc. so you don't get:
>
> Operating-system error:
> Connection refused
> DB-Library: Unable to connect: SQL Server is unavailable or does not
> exist.
>
You have to have the server and it must be running in order for any client
application to perform an operation on the database
--
=================================================================
*NOT* an official document of the University of Michigan - Flint
=================================================================
David A. Cheslow
E-Mail : dcheslow@impact.flint.umich.edu
Technical Details
Message-ID:
<29d=Cl+@engin.umich.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!caen!newsReferences:
<1993Jan7.213021.18871@wam.umd.edu>Show Full Headers
Complete Article Headers
Newsgroups: comp.sys.next.software Path: arc1-ca.pugleaf.net!sparky!uunet!caen!news From: dcheslow@impact.flint.umich.edu (David A. Cheslow) Subject: Re: Using Sybase SQL Message-ID: <29d=Cl+@engin.umich.edu> Date: Fri, 08 Jan 93 11:19:24 EST Organization: The University of Michigan, Ann Arbor References: <1993Jan7.213021.18871@wam.umd.edu> Nntp-Posting-Host: impact.flint.umich.edu Lines: 57