Board index » delphi » (Dis)Advantages of putting BDE on server versus clients

JohnChi

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

(Dis)Advantages of putting BDE on server versus clients

I'm exploring the idea of loading the BDE and Sql Links on the server
rather than on each client PC. Anyone try this or have any ideas?

New Year regards,
John M.

 
John Francis Lund

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


Yes I've used this approach and had no problems using delphi 1. The win.ini
file just points to the BDE on the server and it runs sweet with much less
maintenance. I suppose all you need to do is point your registry settings at
the server for 32bit apps. I'll be doing it shortly but have yet to try it
in a live situation. Best of Luck!

Patrick Benne

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


Quote
"JohnChi" <jamah...@megspo.megsinet.net> wrote:
>I'm exploring the idea of loading the BDE and Sql Links on the server
>rather than on each client PC. Anyone try this or have any ideas?

We've done it at my company since BCB 1.  I've upgraded the shared BDE several
times w/ no problems.  New registry entries that got defined for newer BDE's had
to be defined for each user, but other than that it's been extremely painless.

-------------------------------------------
Patrick Bennett
Acraline Products, Inc.
 pbenn...@acraline.com

JohnCh

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


How are you handling remote users within this Server-BDE setup?
I will have about 100 remote users.

Thanks for any of your thoughts,
John Mahady

----------------------------------------------------------------------------
------------------------------------------------
Patrick Bennett <pbenn...@acraline.com> wrote in article
<369105dc.17862...@forums.inprise.com>...

Quote
> "JohnChi" <jamah...@megspo.megsinet.net> wrote:

> >I'm exploring the idea of loading the BDE and Sql Links on the server
> >rather than on each client PC. Anyone try this or have any ideas?

> We've done it at my company since BCB 1.  I've upgraded the shared BDE
several
> times w/ no problems.  New registry entries that got defined for newer
BDE's had
> to be defined for each user, but other than that it's been extremely
painless.

> -------------------------------------------
> Patrick Bennett
> Acraline Products, Inc.
>  pbenn...@acraline.com

JohnCh

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


How are you handling remote access within this Server-BDE setup?
I will have about 100 remote users.

Thanks for any of your thoughts,
John Mahady

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

John Francis Lundy <jflu...@aol.com> wrote in article
<76qskl$8...@forums.borland.com>...

Quote

> Yes I've used this approach and had no problems using delphi 1. The
win.ini
> file just points to the BDE on the server and it runs sweet with much
less
> maintenance. I suppose all you need to do is point your registry settings
at
> the server for 32bit apps. I'll be doing it shortly but have yet to try
it
> in a live situation. Best of Luck!

Patrick Benne

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


Quote
"JohnChi" <jamah...@megspo.megsinet.net> wrote:
>How are you handling remote users within this Server-BDE setup?
>I will have about 100 remote users.

Well, if your definition of a 'remote user' is somebody who's connecting via
modem or other slow connection, then they would have the BDE installed locally.
Our company isn't quite large enough for it to be a concern, but there are quite
a few remote installation packages out there that could help with updating
remote clients if it was necessary.

-------------------------------------------
Patrick Bennett
Acraline Products, Inc.
 pbenn...@acraline.com

JohnCh

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


I appreciate you thoughts. I was hoping for any experiential advice.
Thanks, Patrick.
----------------------------------------------------------------------------
---------------------

Patrick Bennett <pbenn...@acraline.com> wrote in article
<3693568b.11211...@forums.inprise.com>...

Quote
> "JohnChi" <jamah...@megspo.megsinet.net> wrote:

> >How are you handling remote users within this Server-BDE setup?
> >I will have about 100 remote users.

> Well, if your definition of a 'remote user' is somebody who's connecting
via
> modem or other slow connection, then they would have the BDE installed
locally.
> Our company isn't quite large enough for it to be a concern, but there
are quite
> a few remote installation packages out there that could help with
updating
> remote clients if it was necessary.

> -------------------------------------------
> Patrick Bennett
> Acraline Products, Inc.
>  pbenn...@acraline.com

Steve Garlan

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:(Dis)Advantages of putting BDE on server versus clients


<<I'm exploring the idea of loading the BDE and Sql Links on the server
rather than on each client PC. Anyone try this or have any ideas?

Quote

Why not go full thin client with no setup at all on the client? If you use
tcp/ip you can use ASTA which requires an AstabDEServer or AstaODBCServer
installed on only one machine. then you can write ASTA enabled client apps
that need only be able to access the IP address of the one machine.

You want to go thin, why not go all the way<g>. You can get excellent
performance with ASTA even over slower WAN connections.

You can download an evaluation version of ASTA at www.astatech.com

--
Steve Garland sgarl...@astatech.com
ASTA: 3-Tier & Thin Client Tools for Delphi
Put your Database on the Internet. Fast and Easy!
ASTA Technology Group http://www.astatech.com

Other Threads

1. (dis)advantages of 'with'?

2. Prof. version versus client server version

3. Looking for Advantage List for Interbase versus Foxpro/Xbase tables

4. Conversion from BDE to Advantage Database Server

5. Advantage Database Server vs SQL Server

6. Distributing the BDE, BDE versus ODBC

7. Stored Procedures VERSUS Client-Side Queries

8. BDE and SQL Server(client)

9. Delphi BDE client/server installation with ORACLE driver

10. Delphi 1 clients, DB2 on Win NT Server and BDE 2.5x