Thanks for your help, everyone.

Basically, this is his first IB project, and, although I have done a few,
I'm no IB expert.

Anyway, it seems that he HAS mapped the server's drive, and that he is
accessing the IB database file through this map. I'm going in on Monday to
check the setup, as I suspect (as someone suggested) that he has the server
running on all machines. If this is the case, it's a little odd that it
seems to work (probably only a matter of time...).

When he switched the clients to access via the IP address (eg.
xxx.xxx.xxx.xxx:e:\thepath\theDBfile.gdb), the system crashed several times.
Someone told me that if you access IB using two different protocols, it can
lock out the clients, which I think is what's happening here, due to the
fact that he was also accessing IB via a small app on the server, just using
the path.

Now, the comment has been made through this group that using an app on the
server to make backups of the database at specific intervals is a bad way to
do it. Can someone please explain what is wrong with this approach? ie. the
app uses the Backup component from Interbase Express to perform the backup,
rather than copying the file etc. What is gbak.exe, and why would it be
better to use it?

Thanks heaps for your help on this, and I appreciate your responses.

Regards,

Paul Matthews
ProSouth Technology Solutions
P.O. Box 5191, Dunedin, NEW ZEALAND
FreePhone: 0800 IT SOLUTIONS (0800 487 658)
(International Callers: +64 3 453 4976)
Visit us at: www.prosouth.co.nz


-----Original Message-----
From: Scott Taylor [mailto:scott@...]
Sent: Thursday, 11 July 2002 4:06 p.m.
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Interbase disconnecting all clients


At 09:02 PM 10/07/2002, you wrote:

>At 08:30 PM 10/07/2002, you wrote:
> >I don't think in IB/FB the gdb can reside on a mapped drive
>
>Not from my tests. I can not run it from a mapped drive with or with out
>ibserver running locally.
>
>I think he may be having a similar a similar problem like I had a few
>months ago when there were multiple servers running that should have only
>been clients. Which we fixed by un-installing IB/FB and just dropping the
>right (latest) gds32.dll into system32.

uninstalled from the client machines that is.

> >==========================================================
> >
> >Paul M. wrote:
> > >
> > > Hi, Scott.
> > >
> > > He was mapping the server's drive, then setting
> z:\thepath\theDBfile.gdb as
> > > the database to connect to, assuming that z: is the mapped drive. The

DB

> > > Server is running on the NTServer whose drive is being mapped.
> > >
> > > I recommended that he switched to TCP/IP to access the DB, which he

did.

> > > However, after a period of time, this caused the server to lock out
> all the
> > > clients.
> > >
> > > I think I've sorted out the problem now, though. He had a small app
> running
> > > on the server that backed up the database at half hour intervals,
> which was
> > > still accessing it via the path, rather than TCP/IP. Someone else has
> > > informed me that if you use two different protocols to access the DB,
> > > Interbase can crash. Therefore I'm pretty sure that this is the
> > problem, and
> > > that the disconnected machine was a red herring.
> > >
> > > Does this sound right to the interbase gurus here?
> > >
> > > Regards,
> > >
> > > Paul Matthews
> > > ProSouth Technology Solutions
> > > P.O. Box 5191, Dunedin, NEW ZEALAND
> > > FreePhone: 0800 IT SOLUTIONS (0800 487 658)
> > > (International Callers: +64 3 453 4976)
> > > Visit us at: www.prosouth.co.nz
> > >
> > > -----Original Message-----
> > > From: Scott Taylor [mailto:scott@...]
> > > Sent: Thursday, 11 July 2002 5:04 a.m.
> > > To: ib-support@yahoogroups.com
> > > Subject: Re: [ib-support] Interbase disconnecting all clients
> > >
> > > At 05:13 PM 09/07/2002, you wrote:
> > >
> > > >He recently switched to TCP/IP to connect clients to the IB6 server.
> > > >(Previously he was mapping the server's drive on each client, and
> > accessing
> > > >the DB through the mapped drive). Everything
> > > >works fine until he disconnects the network cable on his laptop (also
> > > >running the client). At this stage ALL clients on the network lose

their

> > > >connection to the IB server, which the application doesn't

particularly

> > > like
> > > >:)
> > >
> > > What is the connection string on the clients?
> > >
> > > >This doesn't happen if he maps the server's drive, and accesses the
> IB DB
> > > in
> > > >this way.
> > >
> > > How do you access the database over a mapped drive? Which machine is
> > > serving (running) ibserver?
> > >
> > > >Theoretically, disconnecting one machine shouldn't cause the IB
> server to
> > > >drop all connections, but it does.
> > >
> > > Not theoretically, verily. Something else is wrong here.
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/