HDTenEightyP/NetNews huggingface dataset:
From: hsr4@vax.oxford.ac.uk
Newsgroups: bit.listserv.dbase-l
Subject: Re: Dbase 3 / 3+
Date: 29 Jul 92 13:31:33 GMT
Organization: Oxford University VAXcluster

In article <9207241830.A03431@ius.indiana.edu>, rboyer2@IUS.INDIANA.EDU (RBOYER2) writes:
> :Can someone tell me where I can find the file format description of a Dbase
> :          3 / 3+ database file ?
> :Thanks
> :
> :Davei (davei@lancaster.ac.uk)
> 
>           I've been meaning to look these things up for a long time
>           now and just decided I would.  They are listed in the
>           Appendix-D of my dBase III+ manual.  I'll copy them here for
>           you poor souls without the manual handy.

And they also appear in Appendix C of the Using dBASE III PLUS manual.

> 
>           Structure of a Database File Header:
> 
>           Byte
>           Offset   Contents           Meaning
>           ==========================================================
>           0        1 byte             dBase III version number
>                                         (03H without a .dbt file)
>                                         (83H with a .dbt file)
> 
>           1-3      3 bytes            date of last update
>                                         (YY MM DD)
> 
>           4-7      32 bit number      number of records in data file

[etc]

I too have been looking for details of file structures, but with much finer
detail than is given in the handbooks.  For example, exactly how to interpret
the values, and what normal ranges might be expected.

I'm slowly finding time to work things through, so I can't give fine detail yet
(but give me time...).

One thing which has become apparent is that the 32 bit number which lies in
offset bytes 4-7 doesn't translate as it stands.  For example, when I look at
one of my (problem) .dbf files, the hex values for bytes 4-7 are 3F 91 01 00.
The direct conversion of that number to decimal gives 1,066,467,584 - which
isn't the number of known records in the file!

What appears to be necessary is to reverse the sequence of the bytes - so
3F 91 01 00 becomes 00 01 91 3F, which turns out to be decimal 102,719 (and
which also happily is the number of known records in the file).

For some this might be glaringly obvious, but not for others (like me, with 
debugging experience primarily in Texas Instruments environment!).

There may be others lurking.  If I find anything really tortuous, I'll let you
know...

Peter "Hair regrowing nicely, thanks" Brooks
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.4dev PL11]
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 22 Jul 1992 17:13:06 CDT
From:         Steve Cochran <cochran@KATANA.PCPD.HOU.COMPAQ.COM>
Subject:      Re: EBANYAN ERROR MESSAGE
X-To:         BANYAN-L%VM1.CC.UAKRON.EDU@twisto.eng.hou.compaq.com
              92 12:14:22 pm

>
> EBANYAN doesn't support the Banyan NDIS drivers. It can only be used for
> cards that have 'direct' drivers like 3Com 3c503, etc.
> --
> ============================================================
> = Alan Smith, Network Manager	Internet: asmith@usace.mil =
> ============================================================

You must use ETHDRV instead of EBANYAN when you are running on an
NDIS stack for Vines.  ETHDRV uses the packet driver interface and
thus, you will need to load a converter in your config.sys (DIS_PKT.DOS).
You then need to add an entry to your protocol.ini file for the PKT/NDIS
convertor.  The entry should look something like this....


[PKTDRV]
  DRIVERNAME    = PKTDRV
  BINDINGS      = MACWD
  INTVEC        = 0x65

You would replace the MACWD parameter with the KEY name of the Card
configuration section of the protocol.ini.

--
*******************************************************************
*                            |                                    *
* Steve Cochran              |   The opinions expressed (if       *
* Systems Engineer (Networks)|   any) are my own and do not       *
* cochran@compaq.com         |   represent those of my employer.  *
* CompuServe: 76040,270      |                                    *
*                            |                                    *
*******************************************************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 29 Jul 1992 14:31:34 CDT
From:         JZeevi%users%swri03@D26VS046A.CCF.SWRI.EDU
Subject:      re: Upgrading to Vines 5.0 on a Compaq Deskpro/33
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

I had similar problems. I changed out the diskette drive and was able to
complete the install. It seemed that the track tolerance was tighter on the
new release.

josef
jzeevi@swri.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 22 Jul 1992 20:55:43 EDT
From:         "Elliott Coates" <coates@UC780.UMD.EDU>
Subject:      RE: Good Apples
X-To:         BANYAN-L%AKRONVM.BITNET@VTVM2.CC.VT.EDU

>Well, that is it for now,  all the best for all you banyanite people.

That's Banyonians or Banyanist, whatever makes you happy. :-)

 ------------------------------------------------------------------------------
 |                       Elliott Coates, washington dc                        |
 |               coates@umuc.umd.edu         coates@umuc.bitnet		      |
 ------------------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 30 Jul 1992 14:58:06 EDT
From:         R=Stoll%SysAdmin%7CG@LGGATE2.HQ.AF.MIL
Subject:      re: Simultaneous Mainframe/Network Access
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

We're using Banyan's 3270 service here at the Pentagon.  It works great.


SSgt Robert Stoll
7th Communications Group
The Pentagon

rstoll@lggate2.hq.af.mil
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Fri, 24 Jul 1992 15:02:10 EDT
From:         Bill=Hillner%STAFF%OTC@OTC.PSU.EDU
Subject: Re: KEEPING TIME.
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

Craig,

>> Is there a way to keep the network time accurate? I am getting very tired
>> of having to set the time every day. Server clocks can deviate as much as
>> several minutes every 24 hours! We do have a server that is within one
>> minute, but that's really not good enough either.

>If you have a dedicated link to the internet and a UNIX box that can run
>software that will generate NTP packets as per RFC 1305, I have a service
>that will receive the packets and set all the servers on the network to
>that time. I'm not our UNIX guy, but I beleive his box receives NTP packets
>every minute from a time server on internet. He then in turn generates an
>NTP packet on our local net.

>Seems to work pretty well.....

>****************************************************************************
>*  Craig Armstrong - VINES hack...             craiga@spock.dis.cccd.edu   *
>*  Coast Community College District            (714) 432-5066              *
>*  District Information Services               Costa Mesa,  Ca  USA  92626 *
>*                                                                          *
>*  "If it doesn't matter if you win or lose, why do they keep score?"      *
>****************************************************************************


This will be of interst to many of us.  A couple of questions:

1. What version of Vines is needed to run this?
2. Is it commercial or available as freeware?
3. If available, can it be uploaded to csus.edu?

Thanks.

/BillH
Bill Hillner
LAN Systems Analyst
Office of Telecommunications
The Pennsylvania State University
Telecommunications Building
University Park, PA  16802-5800

voice (814)865-3171
internet billh@otc.psu.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 23 Jul 1992 22:30:30 EDT
From:         "Elliott Coates" <coates@UC780.UMD.EDU>
Subject: re: BAD TAPE?
X-To:         BANYAN-L%AKRONVM.BITNET@VTVM2.CC.VT.EDU

>I wonder if this might not be an occurance of a problem that someone
>mentioned a while back?  Someone (I would give odds that it was either
>Ian Brabham or Elliot Coates, but I can't find the note right now, so I'm
>not certain) was describing the proper method of doing backups, which

T'wasn't me.

 ------------------------------------------------------------------------------
 |                       Elliott Coates, washington dc                        |
 |               coates@umuc.umd.edu         coates@umuc.bitnet		      |
 ------------------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Fri, 31 Jul 1992 09:02:11 EST
From:         Patrick=Smoker%Admin%Ag@ADMIN.AGAD.PURDUE.EDU
Subject:      re: windows/vines/tcp
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

>> Here is a question for the windows users.
>> I would like to run Powerbuilder in windows and have it access the
>> Sybase SQL server via tcp/ip.  What is the modification to the
>> system.ini file that tells windows to use the ibanyan or ebanyan
>> drivers for TCP?  Is there anything else required?

>> keith Lally
>> programmer/analyst
>> brookhaven national lab
>> Keith,

>The only modifcation that I have in my System.ini is
>device=C:\TCP205\VPCTCP.386
>under the [386Enh] section.

>We use Powerbuilder as our Sybase front end and I believe these are the
>only modifications required.  I've configured my PC for the Windows
>interface to PC-TCP, (EBanyan), but I don't use Powerbuilder myself and
>I'm not sure who actually supplies the driver(s).  I can find this out
>if you like.

The vpctcp.386 driver is supplied by FTP Software (version 2.05 p15).
There is also a [VPCTCP] section of your system.ini file.  If you load
the ebanyan kernel high before loading windows, make sure you include the
entry HiTSRFenceSegment=A000h entry under the [VPCTCP] section.

All the best.

*******************************************************************
* Patrick Smoker              E-Mail:   pds@admin.agad.purdue.edu *
* MIS Manager                 Phone:    (317)494-9330             *
* Ag. Administration          FAX:      (317)496-1104             *
* Purdue University                                               *
*******************************************************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Vmsmail-To: SMTP%"BANYAN-L@VM1.CC.UAKRON.EDU"
Newsgroups: bit.listserv.banyan-l
Date:         Mon, 27 Jul 1992 10:54:17 -0400
From:         NSI Security Manager +1-202-434-4541
              <TENCATI@NSSDCA.GSFC.NASA.GOV>
Subject:      (Repost): Job Opening: Site Mgr/Sr. File Svr Admin - Wash. D.C.
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

[The first posting had an error in the return e-mail address, sorry!]

Greetings,

 I recently subscribed to this list. I am submitting the following
 on behalf of my wife, who does not currently have net access. I hope
 the following is not inappropriate for this list. If so, please ignore.

 -------------------------------------------------------------------

  ICT, a local DC Metro-Area Government contractor, is looking for a
  person to serve as Site Manager/Sr. File Server Administrator at the
  Air National Guard site on Andrews Air Force Base in Maryland.  We
  need someone with either a CBS or a CBE and at least 3-5 years of
  senior Banyan administation experience.  US Citizenship is required,
  Security Clearance (Secret or above) and supervisory experience is
  preferred.

 -------------------------------------------------------------------

 If you are interested, submit your [ascii] resume to this email
 address (and I will forward it) or call (301) 981-8700 and ask for
 Terry Robinson.


 Ron Tencati
 TENCATI@NSSDCA.GSFC.NASA.GOV
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Tue, 28 Jul 1992 12:00:05 WET
From:         Boelen%FaB%WMW@CIVP.UTWENTE.NL
Subject:      fast network cards
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

Hi there, I am looking around for a fast network card for my new file server,
I am currently using 3Com II/16's. Is the 3Com 16 (the 3c507) a good choice?

If anyone has reallife experiences, I'd be very happy to hear them...

Thanks in advance

Lars Boelen
Faculty WMW
University Twente
The Netherlands
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: BANYAN-L@VM1.CC.UAKRON.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 29 Jul 1992 11:41:20 MET
From:         HoornwegB@FACB.FHK.EUR.NL
Subject:      EXCLUDE in stda doesn't work
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

Hi there,

Here's my petty little problem:

I'm running a STDA satellite service, with a number of EXCLUDE lines en an
INCLUDE file.
The INCLUDE file works perfect, the EXCLUDE lines however don't seem to have
any effect.
My satellite is running 4.11(5)
The master is currently running 4.10(0) but wil soon be migrating to 4.11

My EXCLUDE line are as follows:

EXCLUDE
Users:net*@*@*
Users:*mail*@*@*
Users:print*@*@*
Users:*test*@*@*
Users:*ursist*@*@*
Users:Sample*@*@*
Users:Servers@*@*
Users:Student@*@*
Users:HASNUMBERS
Users:*@Beheer_vs01@FHK.EUR.NL
Users:*@Beheer_FHKW@FHK.EUR.NL
Users:HoornwegB@facb@FHK.EUR.NL
Users:sna@facb@FHK.EUr.NL
Users:ZZ*@*@FEW.EUR.NL

Is it a known problem that the EXCLUDE lines don't work if the satellite uses
4.11 en the master 4.10 ? I know there have been STDA modifications, but I
 havn't read anything about my little problem.

Marcel Hoornweg
Faculty of History and Study of the Arts
Erasmus University Rotterdam
Netherlands

Internet: Hoornweg@facb.fhk.eur.nl
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 30 Jul 1992 19:19:05 EDT
From:         Lou=Janelle%Faculty%WAYNE@AUBURN.UAKRON.EDU
Subject:      TAPE DRIVE CONFIGURATION

We're installing a server with the following configuration:
	Dell 433SE Tower with 33MZ 80486 microprocessor
	1 3.5" HD diskette drive
	1 650 MB Micropolis SCSI Hard Drive
	1 Wangtek 350/525 MB SCSI External Tape Drive
	1 AHA-1740/42A SCSI HOST ADAPTER
	VINES 4.11(5) operating system

Everything works fine except the tape drive.  The request to backup the system
results in the system asking one to insert a diskette in drive "A".  The tape
drive and the hard disk are both connected to the SCSI host adapter.  Our
server configuration reads as follows:

Card			Slot	DMA	INT	I/O	RAM
WD Ethercard Plus	4		3	280	d0000
Serial Port		0		4	3f8

NOTE:  no settings for the tape drive or SCSI host adapter ... didn't find a
       choice in the Banyan list.

Thank you in advance for your assistance.
-----------------------------------------------------------------------
Lou Janelle                              216/683-2010
The University of Akron-Wayne College    FAX:  216/683-1517
10470 Smucker Rd
Orrville OH 44667
LOUJ%FACULTY%WAYNE@BANYAN.UAKRON.EDU
-----------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 29 Jul 1992 08:47:46 PDT
From:         Kelly=Yock%Systems%PCBs@BANYAN50.BV.TEK.COM
Subject:      re: NIC'S
X-To:         BANYAN-L@vm1.cc.uakron.edu

We get all ours from ComputerLand and/or JWP Information Services.  We're
paying about $550....Kelly
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 29 Jul 1992 07:28:59 CDT
From:         FFore%CTC%SwRI26@D15VS178A.SPACE.SWRI.EDU
Subject:      ES3210 woes
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

   FYI - there is a serious bug in the Interlan ES3210 32-bit board driver in
the latest revision of VINES 5.00(5).  The symptoms are severe performance
problems, especially in server-to-server operations.  There is a patch from
Banyan called 5005AX2 that is supposed to fix this problem, but BEWARE!  On
one of our servers it caused an immediate PANIC halt that forced us to
completely reload the 5.00 release tapes and repatch the server back to
5.00(5).  On two other servers the patch applied successfully.

  Differences in the server that crashed and the ones that didn't are that the
server that crashed is running the TCP/IP routing option and also has a token
ring board installed.  Banyan has not gotten back to us yet on what caused the
crash - whether it's the TCP/IP option or the token ring board.  We replaced
the ES3210's (one for the local segment and one for a Ethernet backbone) with
a 3Comm 3c503-16 and a Micom NI5210 and performance increased by 5X.  We are
anxiously awaiting a resolution to this problem!

-Frank Fore, Southwest Research Institute, S.A., TX.
 Internet: fpf@swri.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 30 Jul 1992 08:06:47 EST
From:         Patrick=Smoker%Admin%Ag@ADMIN.AGAD.PURDUE.EDU
Subject:      re: Simultaneous Mainframe/Network Access
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

>We have a mixture of PC's on campus which will be requiring access to
>both our mainframe computer and a network operating system. Many of the
>PC's are old IBM 5150 and PS/2 models with two floppy drives. They have
>insufficient RAM to run other applications when both programs are loaded
>in memory.

>Has any other site come up with a way to enable access to two different
>routes (in our case, the mainframe using Y-Term and our Banyan network)
>without re-booting?

This may be obvious, but I'll share with you the means we use to access
mainframe/unix hosts on our campus.

If your net and the mainframe will talk TCP/IP, you can do a simple
tn3270 session to access your mainframe.  We have Bayan's TCP/IP routing,
and FTP Software's Ebanyan version of PC/TCP.  We load the TCP/IP kernel
(Ebanyan), execute the session (tn [host ip]), then unload the kernel
when the session is terminated (inet unload).

We've written batch files to automate this procedure and use this same
configuration to commnunicate with all foreign hosts on campus.  While we
are really a Windows shop and have few XT's around anymore, we still use
this procedure for those who do not need to have multiple TCP/IP sessions
running at the same time.  We do this simply to provide users the
greatests amount of base RAM possible for DOS sessions in Windows.

All the best.

*******************************************************************
* Patrick Smoker              E-Mail:   pds@admin.agad.purdue.edu *
* MIS Manager                 Phone:    (317)494-9330             *
* Ag. Administration          FAX:      (317)496-1104             *
* Purdue University                                               *
*******************************************************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 30 Jul 1992 12:10:07 CDT
From:         FFore%CTC%SwRI26@D15VS178A.SPACE.SWRI.EDU
Subject:      re: Users
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

  Works fine for me.  Tried:  USERS *@*@swri26  &  USERS FFORE@*@*

-Frank Fore, SwRI
 Internet: fpf@swri.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 30 Jul 1992 08:52:03 EST
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         "Mike Christiansen - Network Coordinator" <MCHRIST@FCCJ.BITNET>
Subject:      IBM Token-Ring Busmaster Support

*** Resending note of 07/30/92 08:48
To: BNANYAN---AKRONVM

From:  Mike Christiansen - Network Coordinator
       MCCS 270

I have a number of IBM PS/2 Model 80 servers running Banyan VINES 4.11 (1)
servicing several hundred IBM workstations (PC's XT's & most model PS/2's). We
are currently in the process of upgrading most of our labs and during this
time I have the opertunity to upgrade the servers as well. I know what options
I have as far as hard drive and RAM goes. But have a question about the
Token-Ring cards. Currently most of the systems are using 1 or 2 IBM
Token-Ring 4/16 NIC's (a couple are using ARCNet, this is being converted to
Token-Ring).

My question is if the version of VINES that we are using, Ver. 4.11 (1), will
support the IBM Token-Ring Busmaster cards? If this release dosn't is there a
version that does? We are in the process of getting Vines 5.0 (if
Telex/Memorex ever gets around to sending it out). Will this version support
this card?

Another question is if VINES will support this card are there any wierd
problems that I might run accross. One of the things that we do a lot of is
use 3270/SNA services. I had a hell of a time getting it up and working
properly and now it is working very well on a server with 2 Token-Ring NIC's (1
for VINES and 1 for SNA). After all of the problems that I had last time my
head will be on the chopping block if I recommend that we convert to the new
cards and we have problems.

Any help will be GREATLY appreciated.  Thanks in advance for any help !

pk temp mike a

If you have any questions please call 632-3192
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Tue, 21 Jul 1992 09:03:52 EDT
From:         Tom=Greenaway%Toronto%banyan@MAGNOLIA.BANYAN.COM
Subject:      re: Help with Vines 5.0 ARL's?
X-To:         BANYAN-L@VM1.CC.UAKRON.EDU

	Hi all!!!   Your problem with the arls is this:

		    In the "Extended List"  you can enter a full Streettalk
		    Name or a StreetTalk List.  You CANNOT use a WildCard
		    in the Extended list as the *@*@* world will always over
		    ride it.  Not only will it override the Extended list
		    wildcard, but if you try to test a user while you have
		    a wildcard in the extended list you will HANG your
		    PC!  This is because of the *@whatever in the Extended
		    list.  We like to call it a KNOWN ANOMALY!
		    (bug is such a dirty word!)

		WORK AROUND!     RTFM

		    Ouch Doctor Doctor! It hurts when I do this!
		    So dont do it!!!!!!

		    What you need to do is creat a streettalk list
			for Example  List@group@Organization

				The only entry on this list is
				*@*@crs
				Yes 5.00 allows you to put a wildcard on
				a list!!!!

			Now on the Extended list give the Rights to
			List@Group@Organization.

		   This will fix your problems!!!!

		  As far as the comment regarding Beta Test Sites:
				I think they did a BANG UP JOB!!!!

		 You know what?!   The Beta Tester MUST HAVE READ THE
				   DOCUMENTATION!!!
				   Because the above explanation is
				   EXACTLY as it is written in the
			  "Managing VINES Security"!!
				see page 6-2  Last paragraph.

					Tom Greenaway@toronto@banyan
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU