Subject Re: A Request to Ken Mayer
From Ken Mayer <>
Date Sat, 13 Jan 2018 07:09:29 -0800
Newsgroups dbase.getting-started

On 1/13/2018 6:48 AM, Akshat Kapoor wrote:
> On 12/01/2018 23:30, Ken Mayer wrote:
>> On 1/12/2018 9:50 AM, Akshat Kapoor wrote:
>>> Dear Sir,
>>> I went through all your books (Volume 1 /volume 2 /the dbase book
>>> plus ) but could not find even a single reference of how to connect
>>> to a database on a server from a remote computer over LAN.
>> Using database aliases, there shouldn't *be* anything else that needs
>> to be done. The alias needs to be set up on each computer. That's it.
>> If you refuse to use database aliases, I cannot do much for you on this.
> I am using BDE aliases and database objects but they are not hard coded.
> They are added using the addalias() method of sessions object and
> discarded when session is closed.
> I have learn't many tricks from your books and use a some duflp code but
> at times it is difficult to know where to search.
> BDE Alias is covered in one chapter / Working in shared environment is
> another chapter.
> Under your guidance I was able to setup a firebird database but failed
> to locate any reference of how to use it over network.
> "The main reason for installing the Firebird Server is if you need to be
> able to create your own database from scratch, and/or are not connecting
> to a different Firebird server. If, for example, the database server is
> installed on your company’s network servers, you should not need to
> install the Firebird Server on your own computer to manipulate it. You
> would need a username (which would be provided to you by your company’s
> database administrator), information about the database itself (name,
> where it is at, etc.)."
> This is the only para that has reference to servers. I do not have any
> answers to
> 1.Where should the app be located server / client or both.

The app should be on client machines, the data should be on the server.

> 2.Is ODBC driver and connection required on client computers. If yes
> then how to configure it.

Yes. The only difference would be pointing to the server, rather than a
local computer.


*Ken Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial: