Thread View: comp.sys.next.software
2 messages
2 total messages
Started by Robert Howerton Gravatt
Thu, 07 Jan 1993 21:30
Using Sybase SQL
Author: Robert Howerton Gravatt
Date: Thu, 07 Jan 1993 21:30
Date: Thu, 07 Jan 1993 21:30
50 lines
2496 bytes
2496 bytes
Hi:
I recently posted a request for help on Sybase and have gotten a litte
further, but I am still in trouble.
1) The Sybase that I am using is version 4.0.2 shipped with NeXTStep 2.x
as /NextLibrary/Packages/ThirdParty.orig/Sybase_DB-Library.pkg, not with
1.0 as I earlier reported.
2) Upon my efforts and upon review of Doug Clapp's "The NeXT Bible", I
have noticed that the "Sybase" which was shipped with NeXTStep v 1.0 was
Sybase v. 4.0. However, version 4.0 of "Sybase" has files that version
4.0.2 does not. Version 4.0.2 looks like:
next12csc> pwd
/afs/.Automount/nd.edu/next_mach30/usr/sybase
next12csc> ls -l
total 23
drwxr-xr-x 2 sybase 2048 Oct 12 1990 bin/
drwxrwxrwx 2 sybase 2048 Oct 10 1990 database/
drwxr-xr-x 3 sybase 6144 Oct 12 1990 doc/
drwxr-xr-x 2 sybase 2048 Oct 12 1990 include/
drwxr-xr-x 3 sybase 2048 Oct 12 1990 install/
-rw-rw-rw- 1 sybase 545 Jan 3 1990 interfaces
drwxr-xr-x 2 sybase 2048 Nov 13 14:46 lib/
drwxr-xr-x 2 sybase 2048 Oct 12 1990 msgs/
drwxr-xr-x 3 sybase 2048 Oct 12 1990 sample/
drwxr-xr-x 2 sybase 2048 Oct 12 1990 scripts/
It does not however have any of the executatbles in /usr/sybase/intall
that v. 4.0 does such as intallserver and startserver. Moreover the
"samples" in .../sample which rely upon things in .../install that aren't
there.
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 ?
B) What is an SQL "server" anyway ?
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.
Re: Using Sybase SQL
Author: 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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads