Gentlefolk,
I am having trouble connecting to a remote FB 3.0 server from Lazars/Pascal.
Environment:
Client: Linux Mint 19, 64 bit. Link in /usr/lib ln -s /usr/lib/x86_64-linux-gnu/libfbclient.so.3.0.2 libfbclient.so.2.5.1
Firebird: 3.0.2
Laz/Pascal: 1.84, 3.04
Host: Linux Mint 19, 64 bit. Can use isql-fb to access FB and database.
Firebird: 3.0.2
Database is in /home/iru/FDB/TrackFb.fdb, User iru (me) and firebird have read/write access to FDB and TrackFb.fdb.
The problem:
I have some code which programatically sets up the FB connelction (TIBConnection), this gave errors
For simplicity I created a new project, singe form with a TIBConnection.
Filled in all parameters on the IBConnection using the object inspector.
Clicked on "Connected" and I get an error "No such file or directory". The directory and file exist on the remote system.
If I disconnect the remote system from the network I get a failure to connect error - correct.
Placed a button on the form, the 'click' event simply sets the IBConnection true.
An error occurs at IBConnection 625:
FSQLDatabaseHandle := nil;
if HostName <> '' then ADatabaseName := HostName+':'+DatabaseName
else ADatabaseName := DatabaseName;
if isc_attach_database(@FStatus[0], Length(ADatabaseName), @ADatabaseName[1],
@FSQLDatabaseHandle,
Length(DPB), @DPB[1]) <> 0 then
CheckError('DoInternalConnect', FStatus);
ADatabaseName contains the correct path and file name /home/iru/FDB/TrackFb.fdb.
Parameter on the IBConnection are:
Database name: /home/iru/FDB/TrackFb.fdb
Dialect 3
Hostname 192.168.1.99 - correct, can ping and telnet to port 3050.
Login prompt false
Options default
Params nil
Password valid password
Username valid name.
I am stuck, cant get down below isc_attach_database......
Any ideas, suggestions, whatever appreciated Ian