"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

However, on a serious note, it is much easier to deal with when the
configuration files (config file, lock file, log file) are separate from the
database catalog and table files.

Tim,

I am a bit lost here

I have the table files on a folder on the server (not CS)
Where should the configuration file be ?
On each PC that accesses the data a different one ?
Or one file also on a shared folder ?

If a have two different applications which use different data tables do I need one configuration file, or more

I don't get it.

Wim

Wim

>I have the table files on a folder on the server (not CS)
>Where should the configuration file be ?
>On each PC that accesses the data a different one ?
>Or one file also on a shared folder ?

One file in a shared folder. The idea is the configuration file is shared across the databases.

>If a have two different applications which use different data tables do I need one configuration file, or more

Its (sort of) up to you. You can share a configuration file across all applications/databases or you can have individual ones

The "advantage" (if I've got it right) to having a shared configuration file is that also shares the users and roles across all the apps.

Roy Lambert

Roy,

<< Errrrr isn't the lock file EDBDatabase.EDBLck? If so it lives in the same
dir as the catalog...... >>

Yes, but there's two lock files, one for the configuration file and one for
each database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wim,

<< I am a bit lost here

I have the table files on a folder on the server (not CS)
Where should the configuration file be ? >>

We recommend the following setup for a normal application with one or more
databases:

Application Directory = ConfigPath = c:\myapp
Database Directory = c:\myapp\data (or whatever)

For configurations and databases that must be shared across multiple
applications, just pick a directory for the configuration that is separate
from the application directories and set up the database directories as
sub-directories to the configuration directory.

<< Or one file also on a shared folder ? >>

This is correct.

<< If a have two different applications which use different data tables do I
need one configuration file, or more >>

As long as the applications are not accessing the same database(s), then
each can have its own configuration file with its own users, etc.


--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I am still a bit puzzled. Can you look at the following setup and give your comments please.
In file sharing mode (no CS)

I have three tables that are on the server drive in the folder

//myserver\tables\

agents.EDBTbl
wheels.EDBTbl
interventions.EDBTbl

I have two applications that are used on 5 computers.

c:\apps\wheels\wheelscan.exe   (uses tables agents and wheels)
c:\apps\prod\production.exe    (uses the three tables)

Where do I put the configuration file(s) ?

As I understand it, there are three options: I can have two configuration files on each computer
one in c:\apps\wheels\
one in c:\apps\prod\

but I can also put one configuration file on each computer
in  c:\apps\configfile\

or I can also put one configuration file on the server
in \\myserver\configfile\

Is this correct ? What are the (dis)advantages of these three setups ?


Thanks
Wim



"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

<<We recommend the following setup for a normal application with one or more
databases:

Application Directory = ConfigPath = c:\myapp
Database Directory = c:\myapp\data (or whatever)

For configurations and databases that must be shared across multiple
applications, just pick a directory for the configuration that is separate
from the application directories and set up the database directories as
sub-directories to the configuration directory. >>

Wim


What's the usage of the two app on the 5 PCs?

Roy Lambert

Roy,

wheelscan.exe is a semi-automated measuring system generating about 500 entrys a day in the database (x3 pc's)
production.exe is used by 5 users, modifying the data and adding entrys in production table.
Then the database is sporadically used to make reports.

My first question is however, can I choose between the three options that I mentioned or is there an option that causes troubles later ?
The second question is of course what is "the best" option and why?

thanks
Wim

Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Wim


What's the usage of the two app on the 5 PCs?

Roy Lambert

Wim

I'm still baffled about which pc's access which tables.


>My first question is however, can I choose between the three options that I mentioned or is there an option that causes troubles later ?
>The second question is of course what is "the best" option and why?

How its set up depends on the data and how the pc's access it. If there is a common set of data then you MUST have a common configuration file. If each pc has its own data then each pc may have its own configuration file or they can share one.

If I understand correctly only one configuration:database pair can be open at a time.

Roy Lambert

Wim,

<< I have three tables that are on the server drive in the folder

//myserver\tables\

agents.EDBTbl
wheels.EDBTbl
interventions.EDBTbl

I have two applications that are used on 5 computers.

c:\apps\wheels\wheelscan.exe   (uses tables agents and wheels)
c:\apps\prod\production.exe    (uses the three tables)

Where do I put the configuration file(s) ? >>

On the server drive, preferrably in a shared folder that *isn't* the
database folder.

<<As I understand it, there are three options: I can have two configuration
files on each computer >>

No, not if you're sharing the database.  Remember, the configuration file
stores all of this information:

http://www.elevatesoft.com/edb1sql_configuration_database.htm

which includes the database definitions.  In addition, the configuration
file determines information regarding how each database catalog is accessed
by each session, therefore all applications accessing the same database(s)
*must* use the same configuration file.

<< or I can also put one configuration file on the server
in \\myserver\configfile\ >>

That's the correct one.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

> Where do I put the configuration file(s) ? >>
>
>On the server drive, preferrably in a shared folder that *isn't* the
>database folder.

Good job I warned Harry isn't it

Roy Lambert