Firebird - Connecting using an IP address
lazarus / 16-Databases

----------------------------------------------------------------------
guest64555 · 2019-09-03 06:30

Hello everyone,,
I am re-writing a program of mine which used DBF and now trying to use
firebird. My first problem I am having is when I try and point the
databasename location to the following path using an UNC:
\\10.1.1.1\database\data.fdb

I get an error when trying to set connect to true which is:

fblinks DoInternalConnect:
 - Unable to complete network request to host "10.1.1.1"
 - Failed to establish a connection

Does Firebird not accept IP UNC paths ? I know if I point via the
drive instead it does not error

Thanks.

----------------------------------------------------------------------
devEric69 · 2019-09-03 08:23

Which controls do you use: IBX?

----------------------------------------------------------------------
rvk · 2019-09-03 08:59

Quote from: Gabru on September 03, 2019, 08:30:54 amDoes Firebird not
accept IP UNC paths ?
No, Firebird doesn't accept UNC paths for database names.

You need to specify a IP or hostname and a LOCAL path on the server to
the database.

So:
10.1.1.1:C:\LocalServerPath\data.fdb

If there is a separate field for hostname you need to set the 10.1.1.1
in that field and just use C:\LocalServerPath\data.fdb for the
databasename.

----------------------------------------------------------------------
tonyw · 2019-09-03 13:01

You will find this all documented in the Fireburd 3 Release notes in
the section "Connection String and Protocols".
If you are using an IP Address, I would recommend using the URL style
syntax:

inet://192.168.0.11/C:\db\mydb.fdb (windows)

inet://192.168.0.11//db/mydb.fdb (unix derivatives)

IBX transparently handles the connect string and will accept all
formats for the DatabaseName. I assume that other database connectors
do the same.

----------------------------------------------------------------------
valdir.marcos · 2019-09-03 13:06

Quote from: Gabru on September 03, 2019, 08:30:54 amHello everyone,,
I am re-writing a program of mine which used DBF and now trying to use
firebird.You'll be more productive if you reserve some time to study
Firebird:
http://firebirdsql.org/en/firebird-rdbms/
https://www.youtube.com/results?search_query=firebirdsql

QuoteMy first problem I am having is when I try and point the
databasename location to the following path using an UNC:
\\10.1.1.1\database\data.fdb
I get an error when trying to set connect to true which is:
fblinks DoInternalConnect:
 - Unable to complete network request to host "10.1.1.1"
 - Failed to establish a connection
Does Firebird not accept IP UNC paths ? I know if I point via the
drive instead it does not error
Thanks.No.

Quote from: rvk on September 03, 2019, 10:59:24 amYou need to specify
a IP or hostname and a LOCAL path on the server to the database.
...
10.1.1.1:C:\LocalServerPath\data.fdb+1

----------------------------------------------------------------------
Paul Breneman · 2019-09-03 13:58

Quote from: valdir.marcos on September 03, 2019, 03:06:09 pmYou'll be
more productive if you reserve some time to study Firebird:
http://firebirdsql.org/en/firebird-rdbms/
https://www.youtube.com/results?search_query=firebirdsql

I just spent several weeks learning Firebird in Win10. See very bottom
here: https://wiki.freepascal.org/Firebird#Links_and_more_information

----------------------------------------------------------------------
Mathias Burbach · 2019-09-09 16:52

Hello guest64555,

you can use an alias to specify the Firebird DB on a particular
server. In Firebird 2.X the alias names are specified in the file
alias.conf under the Firebird folder. In Firebird 3.X the file is
named databases.conf. The following entry exists for Firebird 3.0.4:
employee = $(dir_sampleDb)/employee.fdb

So then the connection string con just be localhost:Employee

Here is an exerpt of my lfm file:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i object
SQLConnector1: TSQLConnector  Connected = False  LoginPrompt = False 
DatabaseName = 'Employee'  KeepConnection = False  Password =
'YourPassword'  UserName = 'YourUserName'  HostName = 'localhost' 
ConnectorType = 'Firebird'  left = 44  top = 62end
Salut,
  Mathias