Unit IbConnection - CreateDB
lazarus / 63-Database

----------------------------------------------------------------------
fcb · 2021-11-13 02:51

Hello,

I have a Firebird service installed on another port (3052) instead of
using the default 3050, so the CreateDB function of the IBConnection
unit does not set the Port variable.
I modified the file (ibconnection.pp) and implemented in line
412...418, in atachment

Thanks

----------------------------------------------------------------------
winni · 2021-11-17 09:28

Wrong thread. Sorry

----------------------------------------------------------------------
Zvoni · 2021-11-17 11:16

Quote from: fcb on November 13, 2021, 03:51:54 amHello,

I have a Firebird service installed on another port (3052) instead of
using the default 3050, so the CreateDB function of the IBConnection
unit does not set the Port variable.
I modified the file (ibconnection.pp) and implemented in line
412...418, in atachment

Thanks
That's bull!
https://www.freepascal.org/docs-
html/fcl/ibconnection/tibconnection.html
There is a published property called "Port" (whatever could that be
for?!?!)
You'll even find it in the Object Inspector

Could one of the mods remove the OP's attachment,, before someone
inexperienced downloads it and borks his installation?

----------------------------------------------------------------------
marcov · 2021-11-17 13:10

Zvoni, language please!

the port is added in the ConnectFB statement.
Code: [Select]  HN:=HostName;
  if HN <> '' then
    begin
    if Port<>0 then
      HN:=HN+'/'+IntToStr(Port);
    ADatabaseName := HN+':'+DatabaseName
    end
  else
    ADatabaseName := DatabaseName;

If that somehow doesn't work to you, please file a bug on gitlab with
an unified DIFF attachment or a pull request. Don't add modified files
like this, since due to version issues, that doesn't make very clear
what exactly you modified. Describe how you test or encounter the
problem.

----------------------------------------------------------------------
Zvoni · 2021-11-17 14:17

Quote from: marcov on November 17, 2021, 02:10:59 pmZvoni, language
please!

Sorry, marco und to OP.
Just having a bad day.....

What really mystifies me: Since when do you need a port to Create a
Database?
OP stated he has a Firebird-Server running, which listens on Port 3052
(instead of 3050).
You need the port to CONNECT to the Server.
Once you're connected, you can create, drop, change Databases, Tables,
dirty socks, wifes, girlfriends without specifying which port

----------------------------------------------------------------------
fcb · 2021-11-18 14:30

Quote from: Zvoni on November 17, 2021, 03:17:19 pmQuote from: marcov
on November 17, 2021, 02:10:59 pmZvoni, language please!

Sorry, marco und to OP.
Just having a bad day.....

What really mystifies me: Since when do you need a port to Create a
Database?
OP stated he has a Firebird-Server running, which listens on Port 3052
(instead of 3050).
You need the port to CONNECT to the Server.
Once you're connected, you can create, drop, change Databases, Tables,
dirty socks, wifes, girlfriends without specifying which port

To test, simply change the firebird server port, when trying to
connect to a database that does not exist, the exception will happen,
in the exception handling run the CreateDB command

----------------------------------------------------------------------
Zvoni · 2021-11-18 16:49

Does Firebird have maintenance database? Like MySQL has „mysql“?
With MySQL i always connect to that database since it exists on every
server.
If FB has something similar, connect to that, and then create your DB