HDTenEightyP/NetNews huggingface dataset:
From: clinton@acs.ucalgary.ca (Tim Clinton)
Subject: Advanced Revelation information request
Date: Sat, 12 Dec 92 15:21:28 GMT
Distribution: na
Organization: The University of Calgary, Alberta

I would appreciate any leads on sources of information about Advanced
Revelation. Mailing lists, code examples, reviews, etc. There was a
little flurry a while back about their latest upgrade, but very little
on-going discussion of the system. I'm involved with an organization
which is considering buying a membership program which uses ARev. Coding
practices of the original developers aside, we're concerned with ease of
maintenance and difficulty involved in further enhancements.

Thank you.


-- 
		  Tim Clinton, CITT Alberta CallBoard
      2500 University Drive, Calgary, AB T2N 1N4 (403) 220-4905
		       clinton@acs.ucalgary.ca
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases
Subject: Info Needed: Grant/Purchasing system for Univ.
Date: 20 Dec 92 18:41:05 GMT
Distribution: comp
Organization: Robert Wood Johnson Medical School, Piscataway NJ


I'm looking for info on grant management and purchasing systems for
a university.  Currently they are using GRANT MANANGER and PERSONNEL
MANAGER from Niles Associates in CA.  This software runs on IBM PCs
and compatibles and they have a simpler version which runs on Apple
Macintoshes (with no immediate plans to upgrade the Mac version).

What do your schools use to track the spending of grants? I'd like
to hear from people who are using packaged SW as well as custom
applications.

Thanks.


Rich Holowczak                       holowcza@andromeda.rutgers.edu
Rutgers University
+---------------------------------------------------+---------------+
|  For best results, squeeze .sig from the bottom   | Ask about the |
|           and flatten as you go up.               | car alarm FAQ |
+---------------------------------------------------+---------------+
Newsgroups: comp.databases
From: allenjm@eng.auburn.edu (John M. Allen)
Subject: Foxpro 2.0 on a network 
Organization: Auburn University Engineering
Date: Sat, 12 Dec 1992 18:16:58 GMT

I have a question regarding running FoxPro 2.0 on a Novell Network.  I was 
recently informed by a friend that FoxPro requires a dedicated DBMS server.
He said there is no way to run FoxPro off of the Novell Server but rather
FoxPro requires its own workstation which runs so slow that it almost has to
be dedicated.  I am new to networks and still learning how they work. I know
that I do not want to have to use two machines as servers if I don't have to.
I have been programming in FoxPro single user environments and I will use another DBMS if I have to.  I have heard that FoxPro 2.5 comes 'multi user' ready, 
and that a license activates those capabilities.  So, to sum up my gibberish, 
Does FoxPro 2.0 require a dedicated server and will 2.5 correct this?

				Thanks in Advance.
				   -John Allen   allenjm@eng.auburn.edu

Newsgroups: comp.databases
From: goldman@bert.eecs.uic.edu (Jonathan Goldman)
Subject: Paradox database on Unix via Internet?
Organization: University of Illinois, Chicago
Date: Mon, 14 Dec 1992 21:33:15 GMT


	I need to construct a database that is accessible via a PC. The data
can be thought of as catalogue-based, i.e. products that are available to 
consumers and that one might see in a catalogue.

	The current PC tools I have are Borland's relational database
software, Paradox, and Borland's Windows front end, Object Vision.

	I also have access to Unix machines and was considering storing the
database under Unix and making it accessible through the internet.

	The questions I have are:

	1)	Is there any public domain database software that runs under
		Unix and supports Paradox or Object Vision file formats?
		My version of Paradox supports formats such as dBASE, Pfs, Reflex,
		ASCII, Quatro Pro, 1-2-3 Symphony, Visicalc. I guess it would
		be optimal if the software supported Paradox directly, but not
		absolutely necessary. Object Vision supports Paradox, dBASE,
		Btrieve, and ASCII.

	2)	What are good/cheap/easy methods for connecting a PC to
		the internet, or to a Unix host with access to the internet,
		for the purpose of extracting information from the
		database?

	Any input on this matter would be greatly appreciated.

	Please send responses to:

	       goldman@bert.eecs.uic.edu

	Thanks.

-- 


-jon
-goldman@bert.eecs.uic.edu
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: DBASE IV CODE
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >From: cs_b150@ceres.kingston.ac.uk (    I N D Y)
 >Newsgroups: comp.databases
 >Subject: DBASE IV CODE
 >Date: 3 Dec 1992 16:44:31 -0000
 >Message-ID: <1fldhfINNs5v@ceres.kingston.ac.uk>
 >
 >URGENTLY REQUIRED !!!
 >
 >I am currently seeking ANY dBASE IV code routines, hopefully well-designed usin.
 >
 >Any help gratefully accepted, including any download sites from where I may
 >obtain such code.
 >
 >Thankyou in advance.
 >
 >Indy.
 >(Please help......)

Borland has a dBASE support forum on CompuServe which has an extensive
library of such code.  GO CIS:DBASE when you log onto the CompuServe
Information Service.  FYI.

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/
From: jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger)
Newsgroups: comp.databases
Subject: Re: Paradox SE vs Full 4.0?
Date: 15 Dec 1992 00:31:55 +0100
Organization: INSA Informatique, Lyon, France
NNTP-Posting-Host: grasp1.univ-lyon1.fr

In article <92348.135246RROXBY@MAINE.MAINE.EDU> RROXBY@MAINE.MAINE.EDU (Robert Roxby) writes:
>What does the SE version of Paradox omit?  Thank you.  Robert

Pdox SE is PDOX 3.x without LAN capabilities, the Data Entry Kit
and *without a decent documentation*.

 ----------------------------------------------------------------------------
 Jean-Claude Berger, JCBerger Developpement Formation (Free Lance Consultant)
 (+33) 78.24.75.78     E-Mail : jcberger@grasp1.univ-lyon1.fr - BIX, jcberger
Newsgroups: comp.databases,comp.os.msdos.apps
From: mjducey@rodan.acs.syr.edu (Matthew "The Daddy" Ducey)
Subject: Mail merge from dbIII Plus wordprefect 5.1 Help.
Organization: Syracuse University, Syracuse, NY
Date: Wed, 16 Dec 92 12:40:12 EST

I need help in how I query and export answers from dbaseIII Plus and merge
it into WordPerfect.

I don't know how to handle a .pfs file from dbase. Can I export it ASCII?
How do I create a secondary file in WordPerfect?

I'd perfer mail, but any help will be great!

Matthew
From: holowcza@andromeda.rutgers.edu (Richard D Holowczak)
Newsgroups: comp.databases
Subject: Re: References wanted on Distributed Databases
Date: 15 Dec 92 21:02:59 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


  I think there is a big difference between distributed partitioned data and
distributed replicated data.  I would be interested to know how Rdb (and
others) handle site failures, communication failures and recovery.
Any comments?



Rich Holowczak
Rutgers University
holowcza@andromeda.rutgers.edu
Newsgroups: comp.databases.sybase
From: MARK.FARRIS@OFFICE.WANG.COM ("Mark Farris")
Subject: BEST RDBMS
Organization: Mail to News Gateway at Wang Labs
Date: Fri, 18 Dec 1992 23:14:02 GMT


I'm not going to tell you ! I want you to tell me:

1.  Where can I find a current OBJECTIVE feature matrix for the major
    RDBMS's (Oracle,  Sysbase, Informix, Ingres, Progress)

2.  This is for people experienced with most of the major DBMS's:

    If you were going to standardize on 1 UNIX based RDBMS vendor, for
    client server computing on AIX / IBM pc's running windows, which
    one would it be ?


   Please email your information or recommendations.
   Mark.Farris@office.wang.com
Newsgroups: comp.databases.sybase
From: dshapiro@apple.com (David Shapiro)
Subject: Re: Notifying clients of table mods?
Date: Sat, 19 Dec 1992 20:55:58 GMT
Organization: Apple Computer, Inc.
Followup-To: comp.databases.sybase

In article <1992Dec17.185308.20280@shearson.com>, fgreco@shearson.com
(Frank Greco) wrote:
> 
> I'm soliciting for ideas and comments on a Unix-based notification
> system.
> 
> I have a potential appliation where I would like to notify distributed
> client processes (LAN) that a table(s) was modified in a Sybase database.
> 

If you would like to stick with db-lib, you can front end the whole thing
with Sybase's Open Server 2.0 (and db-lib 4.6 or greater). This contains a
new notification scheme called 'registered procedures', which allows
asynchronous call back to the clients. As your clients log in to the Open
Server, you subsequently log them in to the actual sql server, and then
register them as interested in a particular procedure - procedures in Open
Server (indeed all of open server) are all C and not t-sql. Now, when this
table is modified, you can call the procedure from a regular sql server
(inside a trigger or stored procedure [exec openservername..sp_name]), your
clients will be notified through db-lib with the calling information. Hope
this helps

Dave Shapiro

Apple Computer, Inc.

[The usual disclaimers]
From: spencer@med.umich.edu (Spencer W. Thomas)
Subject: Re: QUESTION: Sybase interfaces file
Date: Mon, 14 Dec 92 10:47:07 EST
Organization: University of Michigan

We run with exactly the same (mounted over NFS) interfaces file on all
machines.  It looks like this (details changed):

#
MYSERVER
	query tcp sun-ether foo.bar.baz 1717
	master tcp sun-ether foo.bar.baz 1717
	console tcp sun-ether foo.bar.baz 1718
--
=Spencer W. Thomas 		|  Info Tech and Networking, B1911 CFOB, 0704
   "Genome Informatician"	|  Univ of Michigan, Ann Arbor, MI 48109
Spencer.W.Thomas@med.umich.edu	|  313-747-2778, FAX 313-764-4133
Newsgroups: comp.databases.sybase
From: gjm@dasc.nl (Gijs J. Mos)
Subject: Re: Sybase - Dumping to raw unix disk partition
Organization: Data Sciences B.V.
Date: Mon, 14 Dec 1992 20:47:19 GMT

End of file is not defined on a raw partition. This means that you must
dump the whole partition to tape.

Gijs
#include <stddisclaimer.h>       This might not be the view of my employer.
From: mgk@sql.sybase.com (Michael Keirnan aka Joe Cool)
Newsgroups: comp.databases.sybase
Subject: Re: Exact form of data flow to Sybase engine
Date: 15 Dec 92 17:30:33 GMT
	<WFINNERT.92Dec7183609@larry.shearson.com>
Organization: Sybase
In-reply-to: wfinnert@larry.shearson.com's message of 7 Dec 92 23:36:09 GMT

wfinnert@shearson.com:
>TDS ( Tabular Data Stream ) is not used for either the BCP interface or the RCP 
>interface ( more important ). In a normal network environ SYBASE *cannot* put a

Sorry for what might sound like a nit here Warren, but Tabular Data
Stream (TDS) is in fact used for both Bulk Copy (BCP) and Remote
Procedure Calls (RPCs). TDS is the protocol that Clients and Servers
speak. It supports binary data. TDS is not somehow tied to dbcmd() and
ASCII language batches in particular, although I understand now how
that perception could arise.

--
===========================================================================
Michael Keirnan			| Internet: mgk@sql.sybase.com
Sr. Software Engineer		| Voice: 617-270-9234 x202
SQL Solutions, Inc.		| #include <legal/disclaimer.h>
---------------------------------------------------------------------------
Anatidaephobia: The fear that somewhere, somehow, a duck is watching you.
                                     - Gary Larson
===========================================================================
Newsgroups: comp.databases.sybase
From: dbenua@panix.com (David Benua)
Subject: Netlib versions available for PC platform ?
Date: Wed, 16 Dec 1992 14:04:17 GMT
Organization: PANIX Public Access Unix, NYC
Keywords: NETLIB Version PCDOS WINDOWS

Can anyone tell me what the latest version of the Sybase NETLIB
for MSDOS/Windows and FTP Software's PC/TCP.  The version we have
is call WDBFTPTC.DLL and has a date of 10-1-91.  Is there are later 
one out there?

While I'm at it, I wonder if anybody has an official definitive list 
of TCP/IP packages for the PC (e.g. FTP Software, Novell LAN Workplace, etc)
that Sybase actively supports. Some other people around here are studying
a migration to a different TCP/IP package for the PC, and I want to 
make sure that whatever package they pick with be compatible with 
Sybase. 

Please respond by EMail. 

Thanks
Dave


-- 
--------------------------------------------------------------------------------
David Benua                  Internet: dbenua@panix.com 
	                   Compu$erve: 72630,1416
 		
Newsgroups: comp.databases.sybase
From: c2p@ORNL.GOV (PERKINS C C)
Subject: Re: Could the SYBASE training center publish the schedules?
Organization: Oak Ridge National Laboratory
Date: Fri, 11 Dec 1992 17:55:05 GMT


In a message about Sybase training schedules, BEVERLY SEAVEY writes:


>  Getting through to the training office to ask for a schedule is
> usually a giant pain. How about SYBASE posting the schedule every
> three months when it comes out? Is that ok with internet rules?
> Think of all the postage and phone-answering time that could be
> saved! 

If posting the schedule isn't ok with Internet rules (and it should
be, I think)... could the schedule just be kept in an anonymous-ftp
site?

Another entry for the FAQ-in-progress?

Neil.
Newsgroups: comp.databases.sybase
From: dave@ema.rockwell.com (Dave Emde)
Subject: Re: Recovering from a log segment full condition
Organization: Rockwell International
Date: Fri, 18 Dec 1992 18:33:24 GMT

In <1992Dec16.205611.19776@spectrum.xerox.com> sauvain@fandango.wrc.xerox.com (Richard Sauvain) writes:

>I have run into the following catch-22:

>My transaction log fills up (even though I allowed more than 2X data size for
>the transaction log), and when I try to dump the transaction log, I get an
>error message saying that the log segment is full and I should dump the
>transaction log.  Using ALTER DATABASE to increase the size of the segment
>allows the dump to proceed for a while, but we eventually get to the same
>state.

>Does anyone understand what is going on here?  Could it be that deleting the
>transaction log is itself a logged operation?

[stuff deleted]

Richard,

I've had the same problem myself.  Using dump tran database with no_log
works will but there have been several instances where I dumped my transaction
log only to find that I still received the "out of space in syslogs" message.

In this case you need to shutdown and restart the server and then issue
another dump with no_log.  This fixed my problem. If you have the Sybase
Troubleshooting Guide they have a good writeup about this type of problem. 

It recommends breaking up large deletes into smaller parts by adding a where 
clause.

For example, if:

	delete y
	where  y.date = '10/1/92'

results in a full transaction log then use:

	delete y
	where  y.date = '10/1/92' and
		   y.col1 < x

    delete y
	where  y.date = '10/1/92' and
		   y.col1 >= x

Either that or allocate more space to the transaction log.

Hope this helps,
Dave Emde
-- 
-------------------------------------------------------------------------
Dave Emde
Rockwell Intl. (Space Systems Div.)
Downey, Ca.
dave.emde@rockwell.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bush, Clinton, Perot .... I'll just vote for my Sun.
-------------------------------------------------------------------------
Newsgroups: comp.databases.sybase
From: neil@ms.uky.edu (Neil Greene)
Subject: QUESTION: Sybase interfaces file
Date: Mon, 14 Dec 1992 15:01:17 GMT
Organization: Association of Racing Commissioners International, Inc.

Being that I am somewhat unfamiliar with Sybase (converting Oracle dba), I am
not sure exactly how to set up my interfaces file.

I have installed sybase on both machines and have set the first machine up as
the server.  Each machine has its own interfaces file.  Machine 1 is called
"justin" and the sybase server is called "SYBASE".  The second machine is
called "miracle" and I would like to modify the interfaces file to all Sybase
to run in client/server mode.  Miracle should be requesting data from justin.


What changes should I make to each machines interfaces files for this to work.
Date: Tuesday, 15 December 1992 19:11:06 PDT
X-Mailer: TMail version 1.13
From: "Steven K. Wilder" <swilder@infoserv.com>
Organization: Private
Subject: Re: Unix Sybase Access to OS/2 SQLServer?
Newsgroups: comp.databases.sybase
Distribution: world

In <allenm.724399867@wizard.ucs.sfu.ca>, allenm@sfu.ca (Allen Mar)  wrote:
> 
> Can anyone tell me how to access Microsoft SQLServer on an OS/2 server
> from a Unix client?  [etc.- removed]  I've been told the SQLServer
> won't talk to TCP/IP though.  Is that right?  What is the explanation for
> this I wonder?
> 
> Must I get Microsoft SQL Bridge to accomplish this task?
             ^^^^^^^^^^^^^^^^^^^^
                  Probably.

The situation is this; Sybase typically uses sockets to 
communicate between server and client; OS/2 provides an alternative
called "named pipes." Although named pipes are protocol-independent,
they are typically only implemented as an abstraction layer for 
NetBIOS on PC networks, especially MS LAN Manager and IBM LAN Server
(OS/2 based servers).

If I remember correctly, SQL Bridge gives Microsoft SQL Server a 
sockets interface to let it communicate with non named pipes servers
and clients.

The problem isn't that the MS SQL Server won't talk TCP/IP (it is
in fact protocol-independent), it's just that it requires a named
pipes interface to clients, rather than the standard sockets Unix
clients are equipped to handle.

P.S., This will probably change as Microsoft has broadly demonstrated
their intent to support sockets in future versions, esp SQL Server for
Windows NT.

> 
> Allen Mar
> allenm@wizard.ucs.sfu.ca

---------------------------------------------------------------------------
Steven Wilder  | swilder@infoserv.com        | "Pure drivel tends to drive
               | swilder@msmail.arc.nasa.gov |  away ordinary drivel."
---------------------------------------------------------------------------
Opinions above not necessarily shared by any groups with which I associate.
Newsgroups: comp.databases.sybase
From: bhc@dirac.i-kinetics.com (Bruce Cottman)
Subject: Re: ODBC to Sybase
Organization: I-Kinetics, Inc., Cambridge, MA USA
Date: Sun, 13 Dec 1992 23:46:34 GMT

OpenClient (DBLIB) anywhere, anyplace, anytime, anyversion.
Newsgroups: comp.databases.sybase
From: barryl@mongoose.tansu.com.au (Barry Lightbody)
Subject: Sybase - Dumping to raw unix disk partition
Reply-To: barryl@mongoose.tansu.com.au
Organization: Sun Microsystems
Date: Sun, 13 Dec 1992 22:22:10 GMT

Has anyone had any experience with dumping a Sybase database to a raw unix disk 
partition.

This facility is not documented and apparently not supported by Sybase.

However it does seem to be possible. Under 4.8 we have been able to add a raw partition
as a dump device through sp_addumpdevice. Along with this we have been able to dump and
load backups to and from this raw device with no problems at all.

The main purpose for using a raw unix disk partition is that we avoid the substantial overhead required in space when creating a file system. So that we get more of a 1.3GB
disk for dumping as a raw partition then we would as a unix file system. 

Your thoughts and experiences would be appreciated.

With thanks
barryl



---
Barry Lightbody    				Phone: +612-395 321
barryl@mongoose.tansu.com.au		        Fax  : +612- 395 3474

Newsgroups: comp.databases.sybase,comp.sys.hp,comp.sys.ibm,comp.sys.novell
From: paul@hp4at.eunet.co.at (Paul Gillingwater)
Subject: Integrating Novell on Token Ring with Sybase UNIX on TCP/IP 802.3
Summary: Any experiences of doing this successfully?
Organization: Home Office in Vienna (Waffle site)
Date: Wed, 16 Dec 1992 22:57:49 GMT

Hi people,
I'm working with a team that is planning to integrate a UNIX box (this
will either be an RS6000 or HP9000 I think) running Sybase with a Token
Ring LAN of PCs running Novell Netware 3.x on IPX with Source Routing.

We're looking at various options for developing client/server
applications under MS Windows -- plus we want them to be portable to the
Mac environment we have as well (which uses a gateway to a LocalTalk
LAN).  Our main network is a mix of 4 and 16 Mb Token Rings with IBM
adaptor cards and the usual cabling.  

I'm interested in soliciting experiences from anyone who has ideas on
the following:

1.  Which client/server development toolkits and 4GLs have you found
that would work in this environment, with Sybase as the back end?

2.  How do you interface the Novell PCs to the UNIX box?

3.  We've considered using a dual protocol stack in the PC, but we don't
know which front end tools will work with such a stack.  We suspect that
Sybase's own client/server toolset might have to fit in here somewhere.
Most PC TCP stacks aren't very open.

4.  Has anyone used TCP/IP Workplace for DOS from Novell?  What exactly
does this do?  Does it use a gateway PC that takes a simulated Telnet
session from a client and then turns it into a real Telnet session?  And
is it possible that this approach might work with a client/server API?
(Not likely, I guess.)

5.  I've heard of Portable Netware for UNIX, but suspect this will only
run on an Ethernet card (with IPX and IP being shared.)  Could we then
use a router to get from the Ethernet segment to the Token Ring?

6.  I've heard a rumour that Novell are coming out with a version of
Netware based on an IP stack -- or is it just encapsulated?  Any ideas
or confirmation?

7.  Are there Token Ring adaptors available for the HP or IBM UNIX
systems which will support IPX stacks?  And will any of these work with
Sybase as the back end?

I guess it's all a little complex, but I'd really appreciate any help
you could give.  Thanks in advance,

Paul Gillingwater

-- 
Paul Gillingwater
Home system: paul@actrix.co.at (Waffle)