Firebird 5 - Connection String and Aliases

[Hugo Eyng | Datamais]

Hello, Friends.

I am facing some difficulty to setup an FB 5

In databases.conf :

DBALIAS = C:\DIR1\DIR2\MYDB.FDB
{
DefaultDBCachePages = 131072
LockMemSize = 30M
TempCacheLimit  =1024M
}

In an ".INI" file containing connection parameters

When I use it like this, it works.

HostName=localhost
Database=localhost/3050:DBALIAS
User_Name=sysdba
Password=masterkey

But it does not work if I change RemoteServicePort to 3051 and change the ".INI" file like that:
(Yes, I restart DB)

HostName=localhost
Database=localhost/3051:DBALIAS
User_Name=sysdba
Password=masterkey

Some hint or some suggestion of where I can find some little bit more advanced instructions about aliases?

Thanks in advance.

Atenciosamente,

[Dimitry Sibiryakov]

Hugo Eyng | Datamais wrote 15.05.2024 21:16:
> But it does not work

For my eyes it should not work in first variant as well because existence of
parameter "HostName" contradict with usage of host name in "Database" parameter.
What is the actual error you got?

--
WBR, SD.

[Hugo Eyng | Datamais]

Thank you, Dimitry.

Currently:

In firebird.conf:

RemoteServicePort = 3051

 In databases.conf:

DBALIAS = C:\DIR1\DIR2\MYDB.FDB

In ".INI" file:

HostName=localhost
Database=localhost/3051:DBALIAS
User_Name=sysdba
Password=masterkey

The error is

unknown ISC error 335545106

If I use DbEaver, it works fine.

Atenciosamente,

Hugo

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/84a6f7bb-b25a-47a1-9549-1d6977c3157f%40ibphoenix.com.

[Tomasz Tyrakowski]

On 15.05.2024 at 21:39, Hugo Eyng | Datamais wrote:
> [...]

>
> In ".INI" file:
>
> HostName=localhost
> Database=localhost/3051:DBALIAS
> User_Name=sysdba
> Password=masterkey
>
> The error is
>
> unknown ISC error 335545106
>
>
> If I use DbEaver, it works fine.

What's the client application that uses your .ini file? It looks like
the problem is in the code of this application if DBeaver works without
problems. Try (but it's just a wild guess) to leave HostName empty in
the .ini if it's already included in the Database.
BTW, what happens if you switch Firebird back to the port 3050 and set
Database=localhost/3050:DBALIAS in the .ini?

regards
Tomasz

[Elmar Haneke]

In an ".INI" file containing connection parameters

When I use it like this, it works.

HostName=localhost
Database=localhost/3050:DBALIAS
User_Name=sysdba
Password=masterkey

Your problem depends on operation your application does with information from INI-file.

Repeating hostname in database name seems to be redundant.

It may be the case that your application removes host information from database name and adds host name instead.

It might help to change "Hostname" to "localhost/3051".

Else, you have to look into application sources.

[Tim Crawford]

I would thing Elmar is correct.
I'm guessing the app is stripping out characters up to and including ':' from Database
And localhost without port in first try before changing to 3051 worked because it is the default,
or the app adds 3050 if not specified

So

HostName=localhost/3050
DataBase=DbAlias

Also, the app might use ':' for the port delimiter, so this might work

HostName=localhost:3050
DataBase=DbAlias

--

You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/5eb6016b-ae30-4458-859b-93f53c6b0905%40haneke.de.