Subject | Can't connect to Firebird 2.1 as Local |
---|---|
Author | |
Post date | 2013-10-09T16:23:51Z |
Hi,
I have Firebird 2.1 server on Windows XP sp3 machine. Server is not 'installed', I use the zip distribution and start it with
fbserver.exe -a (as application)
This way, I can't connect to a local database specifying only a path like C:\test.FDB in the connection string - I get 'Unavailable database' error.
If I use localhost:C:\test.FDB - no problems at all.
On the same machine I also have Firebird 1.5. If I shutdown 2.1 and start 1.5 (again as application) - no problem. I can connect both as Local and via TCP.
What might be the reason for this - the same database, same connection string, but it works for 1.5 and not for 2.1 ?
I tried to put IpcName = FIREBIRD or IpcName = Global\FIREBIRD in firebird.conf file for 2.1, but it makes no difference.
With isql tool however, I can connect to 2.1 as local. But with any other app I can't - tried IBExpert, my own app, and one more tool.
Please advise what to do to connect as Local.
BTW is there any reason to prefer a Local connection instead of TCP ?
Thanks.
I have Firebird 2.1 server on Windows XP sp3 machine. Server is not 'installed', I use the zip distribution and start it with
fbserver.exe -a (as application)
This way, I can't connect to a local database specifying only a path like C:\test.FDB in the connection string - I get 'Unavailable database' error.
If I use localhost:C:\test.FDB - no problems at all.
On the same machine I also have Firebird 1.5. If I shutdown 2.1 and start 1.5 (again as application) - no problem. I can connect both as Local and via TCP.
What might be the reason for this - the same database, same connection string, but it works for 1.5 and not for 2.1 ?
I tried to put IpcName = FIREBIRD or IpcName = Global\FIREBIRD in firebird.conf file for 2.1, but it makes no difference.
With isql tool however, I can connect to 2.1 as local. But with any other app I can't - tried IBExpert, my own app, and one more tool.
Please advise what to do to connect as Local.
BTW is there any reason to prefer a Local connection instead of TCP ?
Thanks.