Hello! I was trying to install FB on Windows Server 2016. Need it for a app of mine which I wrote in Delphi.

I tried both FB 3 and 2.5. It installed correctly, the services where running.
However, I wasn't able to connect to the server at all.

Are FB and Win Server 2016 able to work together? Does anyone have experience with it, are there some special "tricks"?

I was using the normal ".exe" installation file.

Thanks for your help.

Regards,
Jürgen

Hi, how can I connect Google Sheets to a FireBird database?

Hi, how can I enable php interbase for php7 on ubuntu server 16? With php5, I've used: php5enmod interbase

Is there a tool (or way) to debug database step by step.

Now we have weird situation where delete from one database fails, on foreign key error, which sounds like it would be trivial thing, but seems so far it is not.

I was just thinking that if it would be our application code I would be able to debug through all of the related code and see if there is the culprit or not.

We suspect it has somethign to do with specific data on the rows. because some of them delete perfectly fine. This happens in this one database only. I've done backup restore for it, I ran gfix stuff on it. I even pumped the data in empty DB.

it should be problem of database structure (trickers and such), data or the Firebird. and most likely it problem of first two.

I was just thinking that is there an tool I could see step by step all the operations in the DB before the foreigh key error is raised. So I could step by step see the order the trickers and so fires and what they do.

Or if someone at Firebird project could check if it is indeed the Firebird bug. I think we could send the DB, if it he/she keeps it safe and keeps it secret :) 

Is anyone here using old Delphi apps with IBX to connect to FB3?
I would like to know is it possible and how to connect to FB3 server with WireCompression (cannot define it as a param of connection in IBX/Delphi since this new param is not recognized)?

Tried a suggestion from (+Carlos H. Cantu) - firebird.conf on client side (of course, server side has WireCompression set to true), zlib1.dll in app folder, but I don't see any performance improvements.

Regarding that, how can I check if certain DB and/or connection to FB3 server uses compression? Is there any log file setup on server that would give me that info or there is nothing else than tracking it with Wireshark? 

Post has attachment
Hello! My "Migration Guide to Firebird 3" eBook just got updated to revision 1.02, with some corrections and new content added. More details at http://www.firebirdnews.org/migration-guide-to-firebird-3/

i have problem with slow query like this:
SELECT
  T.TRXTOTAL,
  S.TRXDATE,
 M.NAME
FROM
  TRX_DETAIL T
  JOIN STRUK S ON T.TRX_ID = S.TRX_ID
  JOIN MEMBERS M ON T.ID_MEMBERS = M.ID_MEMBERS
WHERE
  (S.BRANCH = :BRANCH) AND
(S.CASIERID = :CASIERID) AND
  (S.TIPETRX = TIPETRX ) AND
  (S.TRXDATE BETWEEN :TRXDATE1 AND :TRXDATE2)

if the record is more than 300.000 process is very slow, is there any other way than changing the structure of the table? or what a good query?

I tried without using the clause 'WHERE' the process is very fast.
then I also try such as the following are also fast:
SELECT
  T.TRXTOTAL,
  S.TRXDATE,
 M.NAME
FROM
  TRX_DETAIL T
  JOIN STRUK S ON T.TRX_ID = S.TRX_ID
  JOIN MEMBERS M ON T.ID_MEMBERS = M.ID_MEMBERS
WHERE
  S.BRANCH = :BRANCH


thank you

I just installed firebird 3 and ran some benchmarks but I find firebird 3 to be up to 50% slower then 2.5.5. In inserts, updates, selects and number of connections. Am I doing something wrong? I've used an performance tweaked conf and am using Super server.

Post has shared content

Post has attachment
A new release is available for the faithful of version 2.5.x... ;-)
Wait while more posts are being loaded