Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2021-01

SQLDB: Set port in TSQLConnector

4 messages · 4 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Luis - SoftSAT Sistemas

I'm trying to connect to a Firebird database with TSQLConnector, but I can't seem to find a way to set the port number.

Looking at TIBConnection, there is a port property, but none in TSQLConnector.

Reply by email

Virgo Pärna
to Luis - SoftSAT Sistemas
Luis - SoftSAT Sistemas wrote
I'm trying to connect to a Firebird database with TSQLConnector, but I can't seem to find a way to set the port number. Looking at TIBConnection, there is a port property, but none in TSQLConnector.
	You can use
HostName := ServerName/Port;
Virgo Pärna

Reply by email

Michael Van Canneyt
to Virgo Pärna
Virgo Pärna wrote 8 lines
On Fri, 08 Jan 2021 14:25:09 -0300, Luis - SoftSAT Sistemas via fpc-pascal wrote: > I'm trying to connect to a Firebird database with TSQLConnector, but I can't > seem to find a way to set the port number. > > Looking at TIBConnection, there is a port property, but none in TSQLConnector. You can use HostName := ServerName/Port;

Port is normally handled using the Params property, so

Params.Values['port']:='1234'

should do.

Michael.

Reply by email

Luis Henrique
to Michael Van Canneyt

12.01.2021, 06:06, "Michael Van Canneyt via fpc-pascal" :

Show quoted text 23 lines
On Mon, 11 Jan 2021, Virgo Pärna via fpc-pascal wrote: >  On Fri, 08 Jan 2021 14:25:09 -0300, Luis - SoftSAT Sistemas via fpc-pascal wrote: >>  I'm trying to connect to a Firebird database with TSQLConnector, but I can't >>  seem to find a way to set the port number. >> >>  Looking at TIBConnection, there is a port property, but none in TSQLConnector. > >          You can use >  HostName := ServerName/Port; Port is normally handled using the Params property, so Params.Values['port']:='1234' should do. Michael. , _______________________________________________ fpc-pascal maillist - https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Thanks Virgo and Michael both ways work!

Reply by email