Firebird 3 and later In Firebird 3 it is easy to create, as it introduced identity columns. In practice it is syntactic sugar for generating a sequence + trigger (as shown for Firebird 2.5) for you. For example create table t1 ( id integer generated by default as identity primary key ) Firebird 3 only … Read more
Given you haven’t provided the information I asked for in the comments, I have to guess you are using Firebird 3 with Jaybird 2.2.x based on the described behavior. The error connection rejected by remote interface can also occur under other conditions than described below. Possible cause: wire protocol encryption required Firebird 3 introduces a … Read more
The VistaDB client runtime is free. The runtime will never “expire at 3am” as you put it. Only the developer tools are licensed in that manner. You need 1 license per developer, simple. We even offer a really inexpensive Lite version with no Visual Studio tools. Some other benefits 100% managed code – there are … Read more
The problem has nothing to do with SRP in itself, but that the Firebird .NET provider version 5.0.0.0 only added SRP support, but does not yet implement the wire protocol encryption. This wire protocol encryption does – by default – depend on SRP for its session key, but the fact SRP is implemented, does not … Read more
You can’t have parameters inside of a string literal in the query. Make the entire value the parameter, and add the wildcards to the string: var SQL = string.format(“SELECT * FROM {0} WHERE {1} LIKE ?”, TABLE, NAME); Cmd.Parameters.AddWithValue(NAME, “%” + “JOHN” + “%”);
It is not possible to do this with a JOIN. The Firebird UPDATE statement has no FROM clause. The syntax is: UPDATE {tablename | viewname} [[AS] alias] SET col = newval [, col = newval …] [WHERE {search-conditions | CURRENT OF cursorname}] [PLAN plan_items] [ORDER BY sort_items] [ROWS <m> [TO <n>]] [RETURNING <values>] <m>, <n> … Read more
Personally I can see two tricks you can pursue. And one “blast from the past” more. Route #1. Use GTT: GLOBAL TEMPORARY TABLE GTTs were introduced in FB 2.1 (and u use it) and can be per-connection or per-transaction. You would want the per-transaction one. This difference is about the data(rows), the schema(structure and indexes, … Read more
Make sure that Firebird is running Firebird is listening on port 3050 on the specified IP (or on 0.0.0.0) Your firewall allows access to port 3050