Connection string with role name

[bdecharly]

Hi

What should be the connection string to connect with a specific role to a database in a server?

that is, for example:

112.179.0.1:/var/Firebird/databases/butterflies.fdb...

what more?

Thanks

[Dimitry Sibiryakov]

bdecharly wrote 17.03.2025 19:46:
> What should be the connection string to connect with a specific role to a
> database in a server?

It depends on the tool you use to connect.

--
WBR, SD.

[basura de charly]

I'm using Libreoffice, but the connection string I give in my question is in the Firebird's Quick start gide, so I suspect it is used in many other connections 

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
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, visit https://groups.google.com/d/msgid/firebird-support/bafefb79-e1f9-40b7-b98c-06d44326f6b4%40ibphoenix.com.

[Dimitry Sibiryakov]

basura de charly wrote 18.03.2025 15:41:
> I'm using Libreoffice, but the connection string I give in my question is in the
> Firebird's Quick start gide, so I suspect it is used in many other connections

Then you should read Libre Office manual and ask in Libre Office support.
Firebird connection string itself has no provision for role name (as well as
user name or anything else).

--
WBR, SD.

[Norbert]

Hi,

 

This help : https://help.libreoffice.org/latest/en-US/text/sdatabase/dabawiz02firebird.html

 

Norbert

 

De : firebird...@googlegroups.com <firebird...@googlegroups.com> De la part de basura de charly
Envoyé : mardi 18 mars 2025 16:41
À : firebird...@googlegroups.com
Objet : Re: [firebird-support] Connection string with role name

To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/CAELS3W8EgfS-ttfOiEZJNj3k_vQd2KgL6dq2m2EB0nYTkHDsjQ%40mail.gmail.com.

[Mark Rotteveel]

On 18/03/2025 15:41, basura de charly wrote:
> I'm using Libreoffice, but the connection string I give in my question
> is in the Firebird's Quick start gide, so I suspect it is used in many
> other connections

The connection string as used by fbclient does not support connection
properties, because connection properties like the role name are passed
in something called the database parameter buffer (or DPB).

Looking at the available options, it looks like LibreOffice Base simply
does not support connection properties beyond username and password.

You could use a JDBC connection using Jaybird, as that does allow you to
specify connection properties in the URL, but be aware that Jaybird 6
and higher no longer support the jdbc:firebird:oo: protocol which you'd
need to use to address some problems LibreOffice has with the normal
jdbc:firebird: implementation due to some differences in interpretation
of JDBC, so you need to use Jaybird 5.

Mark
--
Mark Rotteveel