🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.sys.next.software
Article #1778

Re: Using Sybase SQL

#1778
From: David A. Cheslow
Date: Fri, 08 Jan 1993 16:19
57 lines
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!news
References: <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