Repository navigation
Firebird database alias connection string not working #8813
Description
On a Windows 10 pro 64 -bit PC I am trying to connect to a Firebird 2.1.3 database from foxpro.
I am able to connect it using the next code:
lcsql = "DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME= d:\#acces\newsal.fdb;Port=3050"
ln = Sqlstringconnect(lcsql,.T.)
However, when I am trying to use an alias defined in aliases.conf (newsal = d:#acces\newsal.fdb) I am getting "File database is not found":
lcsql = "DRIVER=Firebird/InterBase(r) driver;UID=SYSDBA;PWD=masterkey;DBNAME=newsal;Port=3050"
ln = Sqlstringconnect(lcsql,.T.)
Can you please tell me what I am doing wrong?
Activity
mrotteveel commentedon Nov 28, 2025
In the first place,
newsal = d:#acces\newsal.fdbis wrong, it should benewsal = d:\#acces\newsal.fdbHowever, the
#is used as a comment symbol in the file, so the alias you defined is actually justd:. If you had quoted the full error, you had probably seen "I/O error for file "D:"". As far as I'm aware, it is not possible to escape it.mrotteveel commentedon Nov 28, 2025
In short, if you want to define an alias, the path should not contain a
#.mrotteveel commentedon Nov 28, 2025
For the future, issues are for reporting bugs. For questions, please use firebird-support or GitHub Discussions.
I'll move this to the Q&A section of Discussions.