Menu
  • HOME
  • TAGS

SQL query joining tables from diffrent fdb databases

sql,firebird,jointable,firebird2.1

You can't. In Firebird you can only join tables in the same database file. Firebird 2.5 expanded EXECUTE STATEMENT to also execute a statement on an external datasource, but having a single query reference tables in different databases is not possible. You have the following options: Create a temporary table,...

Connecting to Firebird on Linux from a CGI application under Apache gives permissions error

linux,apache,cgi,freepascal,firebird2.1

I figured out how to get it working by reading the solution to a different problem. Not sure why disabling the firewall didn't work (I had to completely uninstall it) and don't know what SELinux is yet (had to set it to "permissive"), but I will need to study those...

Firebird and Entity Framework Error -804 Unknown data type

c#,exception,entity-framework-6,firebird2.1

The generated uses @p__linq__1 IS NULL (which is actually sent as ? IS NULL to the server), and this was only introduced in Firebird 2.5. To be able to use this you either need to upgrade to Firebird 2.5, or handle the steel.HasValue condition in code and not in the...

How to catch an event coming from database to C# (chat application)

c#,mysql,database,firebird2.1

Below is a very simple program that handles events, it was copied/modified from Firebird .NET - Examples of use. The class that handles the events is FbRemoteEvent. You register the event(s) you are interested in on an instance and you add event handler(s) to be notified when an event occurs....

Creating table in Firebird script causes “unsuccessful metadata update” with deadlock

sql,firebird,firebird2.1

DDL from PSQL is not allowed, using EXECUTE STATEMENT it is not directly forbidden, and usually possible, but still not wise exactly because of these kinds of problems. I am not exactly sure about the reasons, but part of it have to do with how DDL changes are applied in...

Entity framework with Firebird throws dynamic SQL error

entity-framework-6,firebird2.1

The error suggests you are connecting using dialect 1. Dialect 1 is the old dialect of Interbase 5 and earlier and should be considered deprecated (although unfortunately 15 years on it is still supported by Firebird...). In dialect 1 it is not possible to quote object names, and double quotes...