Re: [firebird-support] is it a bug?

2020-07-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I think that double quotes are used only if you want case sensitive They are required for any SQL identifier that contains non-allowed characters. -- WBR, SD.

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.06.2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > I don't know if I will be such a novice, but I can't find the language > reference manual for firebird 3 https://firebirdsql.org/en/reference-manuals/ Google Translate can help you read it. -- WBR,

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > And how do I assign the pre-benefits to the user that I am going to use to > create the database? Using "GRANT" statement as described in Language Reference. -- WBR, SD.

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

2020-06-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support] wrote: > Is it possible to open database 2.5.9 on servers 3.0.5? No. > Is it possible to create databases on a 3.0.5 server with a user other than > sysdba? Yes, but appropriate privilege must be granted to

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.06.2020 14:20, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > the issue is not resolved. Now it complains the database does not exist. That's another issue. Check that path and name of database are right. -- WBR, SD.

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > the Process Explorer reports the dll as under  : > > D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll That's the problem. This library must not be used from this place but copied into

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: >    Use Process Explorer to find out which exactly fbclient.dll is loaded. > > I do not find fbclient.dll listed in the Task Manager of the client Windows > machine when i > attempt to connect to the Firebird

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > I have not set any environment variable. > > But I do have Firebird 3..0 installed on the client Windows machine, to this > the > flamerobin connects without issues. Use Process Explorer to find out which

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA' > password 'myPassword'; I see. Normally Firebird client library cannot find plugins and don't try to use them. Is environment variable

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: >    Do not use embedded mode. > > I am not using embedded mode. Show connection string. -- WBR, SD.

Re: [firebird-support] Error Loading Pluggin Engine12

2020-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > But when I try to connect using Flamerobin, i get the message: > > Error loading plugin Engine12 > Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can > be loaded > unknown Win32 error 193 Flame

Re: [firebird-support] SQL Error 303

2020-05-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.05.2020 13:29, 'Olaf Kluge' olaf.kl...@satron.de [firebird-support] wrote: > what function can I take instead of the isc_expand_dpb? There is no replacement for this function. You must use the same allocation function that was used for original DPB which depends on the host language. --

Re: [firebird-support] SQL Error 303

2020-05-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.05.2020 12:51, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > The name of the function is /*isc_expand_dpb*/ This function is deprecated since Firebird 1.0. -- WBR, SD.

Re: [firebird-support] Firebird running many databases

2020-05-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > It just shows > > Firebird SQL Server (32 bit) > - Firebird Server - DefaultInstance > > No mention of the mode that I can see. You should also read documentation about differences between the modes.

Re: [firebird-support] Firebird running many databases

2020-05-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > Is there a way to check what mode FB v3.0 server is running in? Windows Task Manager. -- WBR, SD.

Re: [firebird-support] Firebird running many databases

2020-05-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.05.2020 06:57, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > My application (Delphi using IBX) has started randomly raising > exceptions "Error writing data to the connection" when the user queries > their database. What is in server's firebird.log at this timestamp?

Re: [firebird-support] Timestamp in different regions

2020-04-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.04.2020 17:30, 'Zoran' zoran...@gmail.com [firebird-support] wrote: > What I was hopping for is if someone with Delphi background can shed some > light on Delphi > handling this situation. Usually such situations are handled by debugging. You use debugging version of VCL and RTL, enable

Re: [firebird-support] Firebird 2.5 and CentOS 7.7

2020-04-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.04.2020 15:40, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support] wrote: > Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so' > > Some ideas? Check dependencies using ldd. -- WBR, SD.

Re: [firebird-support] Re: Technical IT specialist Firebird corruption

2020-04-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.04.2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote: > But Like I said Errors where produced with restoring, like size error A new feature for you to learn: copy-paste from console window to mail client. -- WBR, SD.

Re: [firebird-support] List Users after CREATE/DROP USER without commit

2020-04-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.04.2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote: > Now I'd love to use the transaction-mechanism for giving the user of > my app a possibility to revoke the changes made. > > Can this be achived somehow? User management is outside of database and performed in an

Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.04.2020 06:47, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] wrote: > What I'd like to do is to reset the pw to something known Connect to any database in embedded mode with user name SYSDBA (without password) and use ALTER USER query. -- WBR, SD.

Re: [firebird-support] Firebird vs Intebase

2020-03-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] wrote: > Form Embarcadero marketing matriel Already was discussed here a couple of months ago. Look into archives. -- WBR, SD.

Re: [firebird-support] Firebird 4.0.0-1436 beta 1

2020-03-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.03.2020 13:24, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > How do I make the current snapshot work. I run the file > "Install_service.bat". The > Firebird service is running, but when I try to connect, the following message > appears > > Install incomplete, please read

Re: [firebird-support] error: -901: invalid BLOB ID

2020-03-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.03.2020 09:29, Pro Turm protu...@mailbox.org [firebird-support] wrote: > What could be the possible reasons for getting this error? BLOB id must be used in the same transaction where it was obtained. -- WBR, SD.

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2020 18:32, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > Then the setting shouldn't be called ConnectionTimeout in my opinion. In > any case, why can't Firebird do this, when for example Java has no > problem with using a connection timeout for sockets? Java can

Re: [firebird-support] Firebird client connection timeout

2020-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com > [firebird-support] wrote: > > No, there wasn't. I copied fbclient.dll and firebird to the application > > folder. Still the same! > > Well, as far as

Re: [firebird-support] Select with a timestamp + 24 hours

2020-03-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.03.2020 13:58, 'Paul Coshott' p...@coshott.com [firebird-support] wrote: > So something like: > > Select from STAFF where PASSWORD_TIME + 24 hours < Now > > Can anyone tell me how to do this? Exactly that: password_time < dateadd(-1 day to current_timestamp) -- WBR, SD.

Re: [firebird-support] order by takes too long

2020-03-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.03.2020 13:23, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The question is when and how decides the generator > of the "plan" that it connot use the indexes http://www.ibase.ru/dataaccesspaths/ -- WBR, SD.

Re: [firebird-support] Scalability of connection numbers of client-server solution with Firebird 3.0?

2020-03-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.03.2020 07:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > What is the reason for such limit? This is select()'s limit on POSIX platforms. The code is unified. -- WBR, SD.

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.03.2020 23:15, Robert martin r...@chreos.com [firebird-support] wrote: > Obviously this doesn't > work if your dfms are binary. Single line of CMD code: for /r %i in (.) do convert %i -- WBR, SD.

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.02.2020 09:38, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > I'm surprised that there is no automatic > coercion within Delphi. DB VCL has some dumb parts because it was designed for using with BDE only. -- WBR, SD.

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-03-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.02.2020 21:33, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > I cannot use SET BIND? This command really exists? In Firebird 4 only. And it will bind ANY bigint, not only result of count(). -- WBR, SD.

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

2020-02-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.02.2020 20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > Ps.: I have a very big old-application written in Delphi 7, with a lot > of TSQLQuery with hardcoded count queries mapped to TIntegerField. So > is impossible to do a migration right now. I need other

Re: [firebird-support] double precision remove last 2 numbers

2020-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.02.2020 19:41, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I need to store long decimals numbers maybe more than 15 decimals, is it > possible without > store as string? If your task requires such number you should consider using of Firebird 4 or Oracle. -- WBR, SD.

Re: [firebird-support] How to set the locale of firebird process in linux

2020-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2020 21:49, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > So, you're saying that is not possible to set the locale to the server > without reinstall the SO in the desired locale? Your UDF must not rely on system or current locale. Use overloaded FloatToStr()

Re: [firebird-support] How to set the locale of firebird process in linux

2020-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2020 20:46, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > Any idea whats happening? Firebird server doesn't call setlocale() thus it ignores locale settings and uses C locale only. -- WBR, SD.

Re: [firebird-support] How to set the locale of firebird process in linux

2020-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.02.2020 14:42, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > Can you provide an example? env += LANG=ru_RU.UTF-8 -- WBR, SD.

Re: [firebird-support] How to set the locale of firebird process in linux

2020-02-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.02.2020 18:22, Roberto Vieweg jjw.roberto.fireb...@gmail.com [firebird-support] wrote: > How can I set the locale of firebird process in linux? > I'm using Firebird 2.5 classic. Use (x)inetd configuration file to set the environment variable. -- WBR, SD.

[firebird-support] Object dependencies in Firebird OO API

2020-02-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. In the description of OO API I failed to find if objects (classes) are depended or not. I.e. I would like to know if order of releasing of them matters. Can I release IProvider before IAttachment and IAttachment before IStatement or it is required to release acquired

Re: [firebird-support] Bad performance with select first(1) + order by

2020-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2020 12:47, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > But I need to deal with a heap of old code and re-designing > it, is not a real option :-) Still you can use "update or insert ... matching gen_id(..., 0)" instead. -- WBR, SD.

Re: [firebird-support] Bad performance with select first(1) + order by

2020-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2020 12:42, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The last entry is considered the "current" entry and should be updated > when the programm encounters e.g. a error. > (Then the field error_count of the "current" entry is then incremented) That's a bad design.

Re: [firebird-support] Bad performance with select first(1) + order by

2020-02-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.02.2020 12:36, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The PRIMKEY is ASC and unique. For this query it must be DESC. > Is the another way to achieve the same? What's the purpose of it? Unique id generation used to be handled by generators. -- WBR, SD.

Re: [firebird-support] ODBC driver with SQLLEN equal to 8

2020-01-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.01.2020 14:42, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > You must build it first: > > cd Builds/Gcc.lin > make -f makefile.linux And "make -f makefile.linux install"

Re: [firebird-support] ODBC driver with SQLLEN equal to 8

2020-01-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.01.2020 14:06, Daniel Wenzel danielwenz...@hotmail.com [firebird-support] wrote: > I downloaded the source code (OdbcJdbc-src-2.0.5.156.tar.gz), from Firebird > ODBC page You'd better get it from github: https://github.com/FirebirdSQL/firebird-odbc-driver > I run install script You

Re: [firebird-support] ODBC driver with SQLLEN equal to 8

2020-01-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.01.2020 19:23, Daniel Wenzel danielwenz...@hotmail.com [firebird-support] wrote: > So my question is, there's a way of modifying SQLLEN of Firebird ODBC driver > to match > unixODBC configuration? I would suggest to build it from sources in your environment. It looks like distributed

Re: [firebird-support] Speedup big table after delete

2020-01-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.01.2020 12:48, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Do I need to do anything else to improve performance fo the table? Analyse queries' plan and stats. Simple delete is not a solution. -- WBR, SD.

Re: [firebird-support] Executing isql without server running

2020-01-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.01.2020 12:24, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Its firebird 2.1.7 It must be Classic Server, not Super Server. -- WBR, SD.

Re: [firebird-support] Executing isql without server running

2020-01-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.01.2020 12:01, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Any ideas? You have no read-write right to database file or libengineXX.so is missing. strace can help you in investigation. -- WBR, SD.

Re: [firebird-support] Statement freezes firebird

2020-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2020 07:59, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The major problem is, that with firebird 2.1.3 the query also completes > within 3 seconds. > Something seems to have changed with the optimizer, execution plan or > whatever (~ sorry I > dont know the terms here)

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 15:19, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > It sounds to me like this is should be optimized by executing the > uncorrelated sub-queries only once. Yes, but Firebird optimizer cannot do it. -- WBR, SD.

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 15:01, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > Is there a way to force limiting the result set before sorting it? No. It is also meaningless because you in fact will get several pseudo-random records. Such result hardly have a practical purpose. --

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 14:49, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > The result are just 8 entries. Sorting those 3 entries should then take no > time at all, right? Wrong. Sorting happens before result set limit apply. > Any ideas? Rule number one: never use "not in".

Re: [firebird-support] Statement freezes firebird

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 14:29, Matthias Winkler spmm...@gmail.com [firebird-support] wrote: > I see the very same issue with firebird 3.0.4. Any ideas? You made nested loop on 18000*18000 records with sorting on each itaretion. It cannot be fast. -- WBR, SD.

Re: [firebird-support] Can i change write mode "On the fly" and does it take effect right away?

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 09:48, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > > If yes, will the changed write mode take effect immediately, or does it > require a restart of the superserver process, all connections to be > closed, or what? I.o.w. when does the changed write mode

Re: [firebird-support] Firebird begin backup and forced writes off, timestamp update delayed

2020-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2020 09:08, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > I assume this is caused by forced writes off and the fact that Windows > may delay some writes for an arbitrary amount of time. In other words, I > assume that the Firebird engine does in fact not write

Re: [firebird-support] Isql exclusive mode?

2020-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2020 11:59, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > So is it correct that I avoid embedded mode by specifying > "localhost/3050:AliasName" instead of just "AliasName"? Yes. -- WBR, SD.

Re: [firebird-support] Isql exclusive mode?

2020-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Can anyone explain in which situations this happens, and in particular > how I can make sure it does NOT happen? If it is version 3 - do not use embedded mode. -- WBR, SD.

Re: [firebird-support] Dates Without the Day of Month

2020-01-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.01.2020 14:18, Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote: > But how easy is it to write queries that ask for items > that are, for example, 24 months old? It can be easy but slow. It can be fast but complex. If I were you I would keep in an integer field number of

Re: [firebird-support] Safe to clean out C:\ProgramData\firebird folder when FB offline?

2020-01-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.01.2020 08:23, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Is it safe to clean out the contents of the C:\ProgramData\firebird > folder, i.e. wipe it, when the Firebird service (superserver) is not > running? Yes. Only temporary files are there. -- WBR,

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 15:20, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > Yes, I have the source of all the stored procedures. But I wanted to > understand if it was > possible recompile without external resources. No. > Sometimes I must recompile because other software made a change

Re: [firebird-support] Database server Clock Incorrect

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 14:07, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Restarting FB server worked. Some users in others foruns reported the same > bug and the > same "solution", but do you know if this bug is restricted to what FB version > and if there > is something we can do to avoid

Re: [firebird-support] Recompile stored procedure

2020-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2020 09:58, Marco Andreolli dra...@gmail.com [firebird-support] wrote: > What is the best way to recompile a stored procedure that has no dependence > on any another > and without making changes? Issue ALTER PROCEDURE statement in WAIT transaction. -- WBR, SD.

Re: [firebird-support] Create view on external table

2020-01-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.01.2020 16:52, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support] wrote: > That why I need to select directly an external table in a view, instead a > stored procedure You cannot. Firebird doesn't support that. -- WBR, SD.

Re: [firebird-support] Create view on external table

2020-01-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
06.01.2020 14:48, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support] wrote: > I can't use Stored procedure to do this, because index are not used with it Index cannot be used with ES either, so there is no difference and no need in a view. -- WBR, SD.

Re: [firebird-support] Need help upgrading win 7 to win 10

2020-01-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.01.2020 23:04, John M buff...@gmail.com [firebird-support] wrote: > Will the win 10 > upgrade break during this upgrade?  If so, what is the best way to avoid > this issue? The best way is not to upgrade old server but to install a brand new one. This way if something go wrong you always

Re: [firebird-support] Remote backup using gbak

2020-01-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.01.2020 20:23, Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] wrote: > I’m hoping someone can help me out here. FB 1.56 (upgrading soon), trying to > perform a > remote backup. https://firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gbak.html --

Re: [firebird-support] Plan problem en CTE

2019-12-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.12.2019 17:57, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > How can I specify the right plan? Your strange query cannot work at all. Natural scan is unavoidable with it. -- WBR, SD.

Re: [firebird-support] Database/Table Corruption

2019-12-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.12.2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Any help will be apreciated. http://www.ibphoenix.com/services/repair https://ib-aid.com/en/firebird-interbase-recovery-service/ -- WBR, SD.

Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.12.2019 15:12, ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > I did not > understand how I should be re-writing my sample SQL. Just remove "left". -- WBR, SD.

Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.12.2019 13:11, ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > left join Left join here can unnecessary kill performance. There cannot be fields without corresponding table. -- WBR, SD.

Re: [firebird-support] Identify computed by columns in table

2019-12-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.12.2019 11:53, ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > I need to identify columns in a table created as "computed by" These columns have DRB$FIELDS.RDB$COMPUTED_BLR not NULL. -- WBR, SD.

Re: [firebird-support] firebird found more than one transation isolation in tbp

2019-12-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.12.2019 15:41, SOFTDZ m_brahi...@yahoo.fr [firebird-support] wrote: > My application is executed fine but when I try to execute an SP I get > that message above > the SP do some works to clean the db at app first installation > before it worked fine for two years and did not make changes the

Re: [firebird-support] Re: Securing Firebird Embedded database

2019-12-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.12.2019 16:30, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Is there any way to secure the FDB file from unauthorized access (other than > compression > and encryption, which I am starting to implement in my project) No. Firebird is an open source project,

Re: [firebird-support] When opening an .FDB file, Firebird says the database is already open by the same computer

2019-12-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.12.2019 22:00, David Wurdeman david.wurde...@mvpmt.com [firebird-support] wrote: > We have an application that uses Firebird to open .FDB databases, that are > stored on a shared directory on a server. Don't do that. Ever. > I’m assuming this message is coming from the Firebird server.

Re: [firebird-support] oracle numeric conversion (22).

2019-12-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.12.2019 17:26, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > As to what I was trying to respond to, you note in your message below that > you would > recommend FB 4.0. However, that is not available yet in any version, other > than beta, correct? Yes but

Re: [firebird-support] oracle numeric conversion (22).

2019-12-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.12.2019 16:40, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > what do you recommend for conversion? Numeric and FB 4. -- WBR, SD.

Re: [firebird-support] backup security3.fdb

2019-12-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.12.2019 12:30, ehmmm.fireb...@seznam.cz [firebird-support] wrote: > Not good:  :) In this case nbackup is your only way. -- WBR, SD. ++ Visit

Re: [firebird-support] backup security3.fdb

2019-12-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.12.2019 08:58, ehmmm.fireb...@seznam.cz [firebird-support] wrote: > Please, what is the best way? Try "gbak -se inet://server/serice_mgr security.db d:\backup\security.bak -user sysdba -pass masterkey". -- WBR, SD.

Re: [firebird-support] Changing the database owner in Firebird 3

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 12:11, kga...@dgcs.pl [firebird-support] wrote: > Is there any other way to change the database owner in Firebird 3? Backup-restore. Could you provide an example of practical purpose for this action? -- WBR, SD.

Re: [firebird-support] Re: Nagle Algorithm

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 05:22, nvat...@yahoo.com [firebird-support] wrote: > Am I missing something here or what is slowing down these firebird > communications??? Firebird uses protocol with full acknowledgment. In combination with badly designed application the result is predictable. -- WBR, SD.

Re: [firebird-support] installing firebird 2.5 on Suse linux enterprise 12.1

2019-12-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.12.2019 04:16, Ferry Sumendap ferry_new2...@yahoo.com [firebird-support] wrote: > Is there any step installation I missed ? Installing and running xinetd. > How execute firebird server to run manually ? There is no way for Firebird Classic Server 2.5. -- WBR, SD.

Re: [firebird-support] Nagle Algorithm

2019-12-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.12.2019 22:28, nvat...@yahoo.com [firebird-support] wrote: > I see that NoNagle can be Enabled on the server by setting True in the > Firebird Server Config file. On contrary, it can be Disabled because by default it is enabled. > However, I do not see anywhere to adjust TCP No Delay on

Re: [firebird-support] Error opening a database

2019-12-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.12.2019 00:18, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > What would cause this and what remedy would be possible. It looks like your Firebird run out of system resources. Make sure that: 1) It is 64 bits. 2) Configured as superserver 3) Hardware and OS provide

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 19:19, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: > If you have a compiled version with the fix, I think a lot of people > would enjoy if you can share the executable ;-) I'm sorry, I'm not sure if I'm allowed to share it. -- WBR, SD.

Re: [firebird-support] A recommendation (database migration)

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 18:28, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: > IB DataPump from Clevercomponents has problems with FB 3, but now it > is open source. It is made in Delphi. If someone interested and with > some free time can fix the problem and even update the application:

Re: [firebird-support] Fail to create external table

2019-12-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.12.2019 16:35, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Any ideas? In short: give up. Just give up. In long: both client side and server side ANSI code pages must support these letter. -- WBR, SD.

Re: [firebird-support] Insert into Select

2019-12-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.12.2019 04:56, dmil...@amfes.com [firebird-support] wrote: > As I said - I can do this via stored procedures - but is there a way to do it > without? If you want to insert records to two tables with single query - you cannot. If you don't want to use a stored procedure then the closest

Re: [firebird-support] What key word specifies a search for an entire word?

2019-11-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.11.2019 17:30, cte...@gmail.com [firebird-support] wrote: > What do I modify so it finds only "Rich"? Use SIMILAR TO. -- WBR, SD. ++ Visit

Re: [firebird-support] BLOB field null without update on that field

2019-11-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.11.2019 09:19, Oliver Garbe oliver.ga...@ttc-informatik.de [firebird-support] wrote: > Any idea why this happens? http://tracker.firebirdsql.org/browse/CORE-6090 https://github.com/FirebirdSQL/firebird/commit/27ae5889208eb93cdf090d79ee02fe22b96e6530 -- WBR, SD.

Re: [firebird-support] After downgrading database FB3 to FB2.5 - no permission for read/select access to DATABASE

2019-11-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.11.2019 13:27, kok...@yahoo.com [firebird-support] wrote: > i tried to downgrade it using this way It cannot work. The only way to downgrade in your case is creating database from scratch and pumping the data. -- WBR, SD.

Re: [firebird-support] Re: Unrecognized Service Parameter Block during FbBackup.Execute

2019-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2019 21:12, fbianch...@yahoo.com [firebird-support] wrote: > what's this error now? Now you are trying to open Interbase database using Firebird server. This is no-go. -- WBR, SD.

Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2019 20:38, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > I havent' Interbase installed on this computer, only Firebird... Look better. Use Process Explorer to see versions and locations of DLLs loaded into your application. -- WBR, SD.

Re: [firebird-support] ISC ERROR CODE:335544721

2019-11-18 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
18.11.2019 19:40, Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support] wrote: > Do you have an idea of what I have to do ? Remove Interbase client and use Firebird client to connect to Firebird. -- WBR, SD.

Re: [firebird-support] What is the optimum pageSize?

2019-11-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.11.2019 12:22, jerz...@o2.pl [firebird-support] wrote: > > Because it is hard to do. A lot of internals in Firebird and its clients > > rely on this maximum size (hint: the number itself fits in a 2-byte > > unsigned integer). It is not like you just need to update a MAX_ROW_SIZE > >

Re: [firebird-support] What is the optimum pageSize?

2019-11-16 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.11.2019 09:33, jerz...@o2.pl [firebird-support] wrote: > a few larger char fields with multibyte coding and we get an exception. An entity with several large text attributes is unusual. Can you provide an example? -- WBR, SD.

Re: [firebird-support] What is the optimum pageSize?

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 22:09, jerz...@o2.pl [firebird-support] wrote: > But only for FB 2.5, not for FB3! > My question was about FB3. Where is info about new versions? In Release Notes for these versions. Maximum size of record was not changed. -- WBR, SD.

Re: [firebird-support] Unrecognized Service Parameter Block during FbBackup.Execute

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 10:56, fbianch...@yahoo.com [firebird-support] wrote: > any hint? https://groups.google.com/forum/#!forumsearch/firebird-net-provider;context-place=overview -- WBR, SD.

Re: [firebird-support] Push notifications prom DB

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 12:56, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] wrote: > Does any database/standard have such mechanism in DB-Engine level that > application could > get some kind of notifications of updates. Firebird has events (read Language Reference about POST_EVENT), Oracle

Re: [firebird-support] with wrong sql i get no exception or firebird error

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 12:45, 'Harald Wolf' firebir...@online.de [firebird-support] wrote: > Any suggestions? Dig into IBPP sources and find out the reason. Use debugger. -- WBR, SD.

Re: [firebird-support] What is the optimum pageSize?

2019-11-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.11.2019 11:58, jerz...@o2.pl [firebird-support] wrote: > What is the max record size in FB3 (in bytes)? > I search for this information without success. https://firebirdsql.org/en/firebird-technical-specifications/ -- WBR, SD.

  1   2   3   4   5   6   7   8   >