FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.26k stars 217 forks source link

aliases.conf # reading error [CORE4028] #4358

Open firebird-automations opened 11 years ago

firebird-automations commented 11 years ago

Submitted by: PizzaProgram Ltd. (szakilaci)

Votes: 1

Firebird can not connect to any database defined in "aliases.conf" if file or folder name contains #⁠ char. Example : myalias = C:\#⁠MyFirstFolder\MyDatabase.FDB

- There is no mention in the aliases.conf file's comment section about that (should be like at firebird.conf) - It is a common practice to change folder or filenames beginning with #⁠ or _ signs to place them to first in the list

The Solution would be, if there would be a "#⁠ disabling sign" like: @ and the engine or any other utilities (like gbak, gfix) would recognize this and ignore any #⁠ signs in that line beginning with that Example: @myAlias = C:\#⁠MyFirstFolder\MyDatabase.FDB

Thanks !

firebird-automations commented 11 years ago

Commented by: @mkubecek

You can use double quotes to avoid interpreting the hash sign, e.g.

myalias = "C:\#⁠MyFirstFolder\MyDatabase.FDB"

This works for aliases.conf in 2.5 and for all config files in 3.0.

On the other hand, documenting this feature on top of firebird.conf (in 3.0) would be a good idea. I'll prepare a commit.

firebird-automations commented 11 years ago

Commented by: PizzaProgram Ltd. (szakilaci)

I would recommend documenting directly in [aliases.conf] file (not in [firebird.conf] only). And please include same [comment] section about " #⁠ " in [aliases.conf] at older installers too ! <OFF> took me 4 hours to figure out, why engine is showing "I/O error" message only because I'm starting to use alias instead of direct path on some mashines. More confusing was that same program with same database with same engine worked fine on other mashines... </OFF>

Thanks for the "Double quotes" tip! But sadly I'm still using the 2.1.5 engine, and did not help there. (I've tried before posted this issue) :(

<OFF> I guess I won't be able to delay any longer to rewrite my program to work with 2.5 but it's difficult </OFF>