I did what (I think is what) you need many years ago. I don´t remember
exactly the details, but this is still working. What I did was the
following:
When my application initiates, it checks if there exists a database
named MYAPPLICATIONCONFIGURACION.FDB. If it doesn't exist, it creates
it. When the application creates the database, it creates 3 UDFs
executing SQLs begining with "DECLARE EXTERNAL FUNCTION ..."
The UDFs are the following (the names are in spanish):
MMudfUbicacionDelAlias
It is called with a parameter "Alias". It opens the file aliases.conf,
look for the alias and returns a string with the path of the database.
MMudfPudeEstablecerAlias
It is called with a parameter "Alias" and a parameter "Path". It opens
the file aliases.conf, and adds a new line with Alias=Path.
MMudfPudeCrearDirectorio
It is called with a parameter "Directory". It creates a folder in the
hard disk with the name indicated.
In the file aliases.conf, there is a line MYAPPLICATIONCONFIGURACION =
C:\...\MYAPPLICATIONCONFIGURACION.FDB.
When a user wants to create a new database, the application opens the
database MYAPPLICATIONCONFIGURACION and executes the following SQL:
SELECT MMudfPudeEstablecerAlias('Alias','Path') FROM RDB$DATABASE
This can be done using the application in the server or in any client PC
of the newtork.
Regards
Eduardo
-------- Mensaje original --------
*Asunto: *Re: [firebird-support] Writing to Aliases.conf in non-admin mode
*De: *Stefan Heymann [email protected] [firebird-support]
<[email protected]>
*Para: *[email protected]
*Fecha: *23/10/2015 12:28
Bhavbhuti,
> My application allows users to create a database and it's entry in
> aliases.conf is created by the application. This essentially is
> fine and works well in Admin mode, as soon as the same is tried to
> be done using the normal non-admin mode I am not able to update
aliases.conf
> Question is, in normal user mode, is there a way to update
> aliases.conf using some FireBird API? or any other way?
I don't know of any method that allows this. The aliases.conf file
belongs to the administration/configuration of Firebird and that's why
it can only be modified by an administrator.
It should be possible to change to access rights (once, by an
administrator) so "everybody" can have write access to the
aliases.conf file.
Regards
Stefan
---
El software de antivirus Avast ha analizado este correo electrónico en busca de
virus.
https://www.avast.com/antivirus
