Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 12 total |
Where is the configuration database |
Wed, Nov 12 2014 8:49 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Wed, Nov 12 2014 10:56 AM | Permanent Link |
Barry | 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 |
Wed, Nov 12 2014 11:34 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Wed, Nov 12 2014 2:24 PM | Permanent Link |
Barry | 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 |
Thu, Nov 13 2014 1:32 AM | Permanent Link |
Ralf Bieber EDV Dienstleistungen Ralf Bieber | 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 |
Thu, Nov 13 2014 3:41 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Nov 13 2014 5:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Nov 13 2014 8:23 AM | Permanent Link |
Raul Team Elevate | 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 |
Thu, Nov 13 2014 10:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Thu, Nov 13 2014 11:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |