BorlandTalk.com

Ian Robinson · Guest

Hi,

Paradox tables, Win98SE peer to peer 6 station network, Delphi 5,

I have several network situations around the country and understand well
how to set up the BDE to run against Paradox tables. I've had very few
problems until now and have 60 + locations.

At one location...

The BDE is configured correctly on each machine. I have had each machine
use the same BDE file on the server. I have Netbuie set as the default
protocol on every machine.

The 6th computer to load my program fails to open the tables when
creating forms giving the message "cannot access \masterdata[various
random tables].db" yet at other locations I have 8 users and the program
loads consistently. The 6th computer to load the program can be any of
the workstations (each with a different amount of memory up to 380mb) so
it does not seem to be computer specific.

It does not seem to be network specific since each program is run from
the same batch file on the server which sets the time on each machine
and then checks for an updated version before copying it to the local
machine and then running it locally. Therefore each workstation
including the current one which ultimately fails has already accessed
the network, it has run the batch file that is located on the server in
the shared folder \masterstock, it has already loaded the main
datamodule and opened it's tables located in the shared folder -
\masterdata but then fails with the above message.

What could make it suddenly not access tables in a shared folder across
the network when it has already accessed some of those tables.

--
Best regards
Ian Robinson FOREST SOFTWARE
+44(0)1594 564457 (Office)
+44(0)7718 806 006 (UK Mobile)
+34 653 209 592 (Overseas Mobile)
+44(0)1594 564038 (Out of hours support)

Bill Todd (TeamB) · Guest

This sounds like your problem site is using a Win2k Pro machine as the
file server. Win2k pro has a limit of five connections (MS wants your
to by Win xx Server) and the limit is enforced for NetBEUI. I believe
that the limit is not enforced for TCP/IP.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Ian Robinson · Guest

Bill,

Thanks for the reply.

No, the server and 5 workstations are all Win98SE. I had an identical
setup elsewhere a couple of years ago which had the same problem on the
8th occurrence of loading my program, unfortunately we replaced about
half the network with virgin machines (same BDE, shares, protocol
configurations) and the problem went away so I never learnt it's cause
and now it's popped it's ugly head up again.

It's a tad embarrassing aswell since I operate a system of concurrent
licenses and this particular site has 6 licences therefore expect to be
able to open the program 6 times on the network and the error is
different to the licence ceiling error I have devised. The fault still
occurs on the 5th instance when I have 6 licenses available, 4 "in use",
therefore 2 still available, and this form of licensing ceiling has
worked faultlessly at all other locations with even improper closures
cancelling the take up of an available licence, and...it's not the
licence ceiling we're hitting.

To reiterate the 5th workstation to try and run my program accesses the
network to run a batch file which intern runs the program off the local
HDD. The program start ups and loads the first data module, opening it's
tables, then on the third data module it errors with "cannot access
\masterdata[random table name].db" yet it has already accessed the
first and second datamodules and opened their tables all of which reside
in "\masterdata"

It doesn't seem to be memory since whether the 5th workstation has 64mb
or 380mb the problem still occurs.

Odd eh !

On the Win2k part of your reply I have one site that *is* using Win2k as
the server, Win98SE on all workstations and am happily running 8
licences with Netbuie as the default protocol. I have heard of the WinXP
home limitation though.

Rgds
Ian

In message <E31b10l4j42gbc7uoh43cjmo85r3fbce82 (AT) 4ax (DOT) com>, "Bill Todd
(TeamB)" <no (AT) no (DOT) com> said

Igor Zakhrebetkov · Guest

Ian Robinson wrote:

Ian Robinson · Guest