I'm sure this question has been asked and answered before but I can't come up with the right search term. How can I query the server to find out where the configuration file is?

I need to know because there are a number of text files I use for configuring the application. In F/S its easy because I just use the LocalConfigPath but in C/S I have no idea how to do it.

Roy Lambert

Roy,

Why not just read the EDBSrvr.ini file. It has the Configuration Folder, and Configuration Name and Configuration File Extension values?

You can also have a peek at:

select * from configuration.information.tables

or

select * from configuration.information.tablenames

to see if it has anything useful.

Barry

Barry

>Why not just read the EDBSrvr.ini file. It has the Configuration Folder, and Configuration Name and Configuration File Extension values?

To do that you have to know the path to it.......

Roy

It would be nice if there was a Configuration.ConfigFileName and Configuration.ServerName, but that would be too easy.

>To do that you have to know the path to it.......<

Correct. I think the easiest way would be to modify the EDBSrvr.exe to write the config location to the registry (or .ini file). You have the source code to the EDBSrvr.prj file and it can be added there.

By default it looks for the EDBSrvr.ini in the current directory of EDBSrvr.exe and if not found it looks for it in the common applications data directory for Windows, like:
C:\ProgramData\Elevate Software\ElevateDB Server (Unicode)

Barry

He Roy

Roy Lambert wrote:

I'm sure this question has been asked and answered before but I can't come up with the right search term. How can I query the server to find out where the configuration file is?


I do not know if this helps, but since version 2.03 you can use relative paths for databases, stores, .. . This path is relative to the configuration file path. That is, if you create a store like
CREATE STORE "Konfiguration" AS LOCAL PATH '' , you have access to the configurations path. You must this SQL statement about new SQL activate. The Create/Alter store don't accept clear path names.

Ralf

Barry


>Correct. I think the easiest way would be to modify the EDBSrvr.exe to write the config location to the registry (or .ini file). You have the source code to the EDBSrvr.prj file and it can be added there.

I've never looked to see if Delphi supports remote registry access so I can't say if that's feasible or not.

I could modify the server to write out an ini file to a specific destination (say C:\)  each time its started, and I can get the host PC from CURRENT_COMPUTER so I could go that way but I seem to remember a better solution being posted.

Roy Lambert

Ralf


>I do not know if this helps, but since version 2.03 you can use relative paths for databases, stores, .. . This path is relative to the configuration file path. That is, if you create a store like
>CREATE STORE "Konfiguration" AS LOCAL PATH '' , you have access to the configurations path. You must this SQL statement about new SQL activate. The Create/Alter store don't accept clear path names.

Not sure about this I think the relative path is the one stored so it wouldn't help much, but it may have given me another idea.

Roy Lambert

On 11/12/2014 8:49 AM, Roy Lambert wrote:
> I'm sure this question has been asked and answered before but I can't come up with the right search term. How can I query the server to find out where the configuration file is?
> I need to know because there are a number of text files I use for configuring the application. In F/S its easy because I just use the LocalConfigPath but in C/S I have no idea how to do it.

i don't think you can today (unless it's in a "known" location relative
to databases or maybe create a module that you can ask for this info
(have not checked if module has access to engine info but it would have
access to local files/registry)).

The other question is I'm still not sure how you would use this info?
How would you access those text files anyways ?

I think getting those files into an edb store might be way to go since
now you simply need to query the stores and files which is easier. And
store is a folder really anyways so you're almost there (or were you
planning to use the remote path to actually remotely create a store
hence the need for it ?).

Raul

Raul


>> I'm sure this question has been asked and answered before but I can't come up with the right search term. How can I query the server to find out where the configuration file is?
>> I need to know because there are a number of text files I use for configuring the application. In F/S its easy because I just use the LocalConfigPath but in C/S I have no idea how to do it.
>
>i don't think you can today (unless it's in a "known" location relative
>to databases or maybe create a module that you can ask for this info
>(have not checked if module has access to engine info but it would have
>access to local files/registry)).
>
>The other question is I'm still not sure how you would use this info?
>How would you access those text files anyways ?
>
>I think getting those files into an edb store might be way to go since
>now you simply need to query the stores and files which is easier. And
>store is a folder really anyways so you're almost there (or were you
>planning to use the remote path to actually remotely create a store
>hence the need for it ?).

The initial idea was an easy transition from f/s to c/s operation over a LAN. I went for simple text files with an "ultra optimistic"  locking protocol because that was easy to implement, didn't need EDB built into the editing or operation for it so could be used anywhere and the files could be hacked easily as well. There's nothing in them I'm particularly bothered about since its just for the appearance engine.

I think I'll alter the code so I can either have a text file or read from a table.

Roy Lambert

Raul


>> I'm sure this question has been asked and answered before but I can't come up with the right search term. How can I query the server to find out where the configuration file is?
>> I need to know because there are a number of text files I use for configuring the application. In F/S its easy because I just use the LocalConfigPath but in C/S I have no idea how to do it.
>
>i don't think you can today (unless it's in a "known" location relative
>to databases or maybe create a module that you can ask for this info
>(have not checked if module has access to engine info but it would have
>access to local files/registry)).
>
>The other question is I'm still not sure how you would use this info?
>How would you access those text files anyways ?
>
>I think getting those files into an edb store might be way to go since
>now you simply need to query the stores and files which is easier. And
>store is a folder really anyways so you're almost there (or were you
>planning to use the remote path to actually remotely create a store
>hence the need for it ?).

The initial idea was an easy transition from f/s to c/s operation over a LAN. I went for simple text files with an "ultra optimistic"  locking protocol because that was easy to implement, didn't need EDB built into the editing or operation for it so could be used anywhere and the files could be hacked easily as well. There's nothing in them I'm particularly bothered about since its just for the appearance engine.

I think I'll alter the code so I can either have a text file or read from a table.

Roy Lambert