Subject Re: A Request to Ken Mayer From Ken Mayer <dbase@nospam.goldenstag.net> 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 -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm