To work with uni labs I need to write procedures and so that I need to execute given settings script with a command SET TERM ; ^. Executing this produces this error: [42000][335544634] Dynamic SQL ...

I have a VPS hosting both a PostgreSQL (port 5432) and a Firebird (port 3050) database. I wish to connect to the databases through an SSH tunnel. I succesfully establish the SSH tunnel as follows: ssh ...

I try to pass string values in a sql query but with no luck Values are for example 'CAR, TREE, HOUSE' etc user can freely choose these values 1, 2 ore more. So my creation string contains only the ...

My task is to perform continous replication on a Firebird 3.0.5 database. I only have read-only access. The data will go to the Google Cloud Platform, either Cloud SQL or BigQuery. Read-only means I ...

for some reason the connection timeout does not seem to work when connecting to a Firebird database. For example, if an incorrect IP address is specified, the script hangs and waits for a long time. #!...

I have several Firebird databases, some created with Firebird v2.5.9 (ODS 11.2) and some with Firebird 5.0.3 (ODS 13.1.) Both Firebird versions are installed on my VM using different ports, and using ...

I am now using C++ for Firebird database UDR Function. The following code is the code for generating a JSON string for Firebird. I have two tables of Category and Product with following data CREATE ...

I have an app using Firebird 2.5.9. We're going to be releasing a major new version of the app, and I want to migrate to FB 5.0. The database schema has changed dramatically between old and new app ...

Using Delphi 12.2 Enterprise with FireDAC and Firebird 2.5, I'm trying to connect to a DB via the following code: type TFD3Base = class(TDataModule) dbConn: TFDConnection; private FDBHost: ...

We have a number of C# service type apps that connect to a Firebird database. Occasionally this Firebird DB might be restarted for various reasons, or the network between the Db and the app might get ...

If record number 21 does not exist in table1, create them from 21 to 30. merge into table1 tab2 using table1 tab1 on tab1.number = tab1.number and tab2.number = 21 when not matched then insert (number,...

When using a Firebird 3 database (server), but connecting through a .NET library, FirebirdSql.Data.FirebirdClient (I tried V. 7.10.1 and the newest 10.3.2), I get the following error (in this example, ...

We're using Firebird 2.5.9 x64 Windows, Delphi XE4. When doing a backup using TIBBackupService, there is an attachment in MON$ATTACHMENTS, but both MON$REMOTE_PID and MON$REMOTE_PROCESS are NULL. Why? ...

I have a string field in a Firebird database. The data in some rows contains an ampersand. I'm trying to select the rows but the result is an empty dataset. Using Delphi 12, FireDAC (TFDConnection + ...

I'm working on upgrading my Firebird database from 3.0 to 4.0. I've completed the migration steps and I'm now testing with my web application and I ran into an issue. I'm using ColdFusion and the ...