Re: [firebird-support] Timestamp in different regions

2020-04-30 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
On Thursday, April 30, 2020, 05:30:22 PM GMT+2, 'Zoran' zoran...@gmail..com [firebird-support] wrote:   Thank you, Karol.   Probably not FB message. I guess it’s coming from Delphi. It happens right after I execute ‘qry.Open;’ statement. What I was hopping for is if someone

Re: [firebird-support] FB1 to FB3

2020-04-30 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
Thankfully I moved from D1 to D3 many years ago. So now just need to get to FB3. Cheers, Kevin > On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support] > wrote: > > Hi Kevin, > > Can I ask what dialect you are going from and to? >

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 RT

RE: [firebird-support] Timestamp in different regions

2020-04-30 Thread 'Zoran' zoran...@gmail.com [firebird-support]
Thank you, Karol. Probably not FB message. I guess it’s coming from Delphi. It happens right after I execute ‘qry.Open;’ statement. What I was hopping for is if someone with Delphi background can shed some light on Delphi handling this situation. From: firebird-support

ODP: [firebird-support] Timestamp in different regions

2020-04-30 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
I do not suppose that this is Firebird message. This looks like client program message. regards, Karol Bieniaszewski

ODP: ODP: ODP: [firebird-support] SQL slower after N executions?

2020-04-30 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
I suppose you have two different queries – one with where clause and one without on one of the tables involved in the query. Are you sure that the queries are the same? But also it is quite usual that after new data changes the plan is about to change. Is this true for your case that some table

Re: [firebird-support] FB1 to FB3

2020-04-30 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
Step 1 is better if you are going from dialect 1 to 3, mostly due to the difference in the numerics internal storage. I see no problem with any of the approaches. I would add that, imho, step 4 in process 2 is not really necessary, unless you want to reset the metadata versions count of the

[firebird-support] Timestamp in different regions

2020-04-30 Thread 'Zoran' zoran...@gmail.com [firebird-support]
Firebird 3.0.5, Delphi 10.3.3 In a table I have TIMESTAMP column. If I read that table from the client in the same Region as server all is ok. If I read the same table where client is in the different region than server, I get error message 'Could not parse SQL TimeStamp string'. In

RE: [firebird-support] FB1 to FB3

2020-04-30 Thread 'Jason (PN)' ja...@jac2.co.uk [firebird-support]
Hi Kevin, Can I ask what dialect you are going from and to? Sorry I don’t have an opinion on P1 vs P2. Do you know why P1 is recommended over P2? As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?. Thanks, Jason From: firebird-support@yahoogroups.com Sent:

[firebird-support] FB1 to FB3

2020-04-30 Thread Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support]
Greetings! Process 1: Via a script, I have successfully exported and migrated all data and objects from a FB1 database to FB3. Creating the objects originally had just a few errors but those have been fixed and it now goes across cleanly, no errors. This process has been the one most widely

Re: ODP: ODP: [firebird-support] SQL slower after N executions?

2020-04-30 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
like that, to reduce query complexity. Kjell Den 2020-04-30 kl. 13:04, skrev Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]: > > Yes, but the transaction just wasn't there. > > I did let it run during the night. Here are FBMonitor diagrams from > about 1 hour

Re: ODP: ODP: [firebird-support] SQL slower after N executions?

2020-04-30 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
    -> Table "Befattningsinnehav" as "UHANT BI" Full Scan     -> Filter     -> Table "TmpFKExportId" as "UHANT L" Access By ID  

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

2020-04-30 Thread Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]
Are you using EPEL package ? or Firebird project binaries ? There is a compilation issue in Epel package since 2.5.8, and nobody understand exactly what fbintl from 2.5.7 package is ok cf https://bugzilla.redhat.com/show_bug.cgi?id=1636177 and http://tracker.firebirdsql.org/browse/CORE-5925 but

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

2020-04-30 Thread 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]
soft.biz <http://www.p-soft.biz/> pec: amministrazi...@pec.p-soft.biz cod.intermediario SDI: KRRH6B9 -- Messaggio originale -- Da: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" A: firebird-support@yahoogroups.com Inviato: 29/04/2020 16:11:44 Oggetto: Re: [f

ODP: ODP: [firebird-support] SQL slower after N executions?

2020-04-29 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Simply run query with join two tables MON$ATATACHEMENTS and MON$TRANSACTIONS – you can also be interested with joining with MON$STATEMENTS And then you can see which attachement consume this transaction (you can retrive IP port and proces ID (PID) Pozdrawiam, Karol Bieniaszewski

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

2020-04-29 Thread Emil Totev em...@tot-consult.com [firebird-support]
This is a known problem with the EPEL rpms. Workarounds include using the rpm packages for superclassic, which don't have the problem, or installing the project-provided rpms (which install under /opt). It *might* also work if you replace that specific file with the one from the EPEL rpm from

Re: ODP: [firebird-support] SQL slower after N executions?

2020-04-29 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
free. Regards, Kjell Den 2020-04-29 kl. 14:00, skrev Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]: > Hi > > There are many possibilities without access i can only hint you: > > Look at MON$Tranasctions maybe you have active one which stop garbage > collec

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. --

[firebird-support] Firebird 2.5 and CentOS 7.7

2020-04-29 Thread 'P-Soft - Fabio Codebue' f.code...@p-soft.biz [firebird-support]
We are trying to install Firebird 2.5.9 Super Server on Linux Server CentOS (Linux release 7.7.1908 (Core)) IT doen't start because it can't load moduloe /usr/lib64/firebird/intl/fbintl.so Into to the log file we read: Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so' Some

Re: [firebird-support] SQL slower after N executions?

2020-04-29 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
g" = F."ECO_ID" and Ar."Årtal" < Ar2."Årtal" ) in the second part of your query. This will probably not help with the slowdown, but it should not be slower than your max( and it may be slightly quicker (although the table names "FöretagO

ODP: [firebird-support] SQL slower after N executions?

2020-04-29 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi There are many possibilities without access i can only hint you: Look at MON$Tranasctions maybe you have active one which stop garbage collecion. Look also at sort buffer setting if firebird.conf Look at settings about buffers in database itself (gfix -h show you value). Look also at automatic

[firebird-support] SQL slower after N executions?

2020-04-29 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Hi, I have a batch job that among other things executes a certain SQL query to load some data. This query takes about 10-12 seconds the first ~320 times, but then suddenly takes ~45-50 seconds every time. Any idea what could be causing this? The query is rather long, see below. Firebird

Re: [firebird-support] How to inspect nbak state of a Firebird database

2020-04-22 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Excellent! Thanks! Feel free to anser that in StackOverflow too (link below). If not, I will do it myself after testing it and mark my own answer as the correct one. Regards, Kjell Den 2020-04-22 kl. 10:08, skrev 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]: > > MON$

RE: [firebird-support] How to inspect nbak state of a Firebird database

2020-04-22 Thread 'Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]
MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge. Regards Paul -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 22 April 2020 09:56 To: Firebird Forum Subject: [firebird-support] How to inspect nbak

[firebird-support] How to inspect nbak state of a Firebird database

2020-04-22 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]
Is there a way in C# to inspect the nbak state of a Firebird database? The state in the database header would be set to |nbak_state_diff| or |nbak_state_normal|. But how do I actually read this value? https://stackoverflow.com/questions/61359915/how-to-inspect-nbak-state-of-a-firebird-database

ODP: [firebird-support] Re: Explicit Login with Windows Domain username

2020-04-19 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi Ask self – do you have Windows Domain supported 2 passwords? No. You can have 2 different autentication methods. On Firebird3 you have autentication plugins. You can implement one self or use apropiate design on your rest service. Better to not allow all users to have same password is to

[firebird-support] Re: Explicit Login with Windows Domain username

2020-04-19 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, I posted a similar question on 20. September 2017 how to login with a windows domain username without using trusted authentication. At this time the answer was: ist not possible or you have to In the meanwhile I have some customers with FB 3.x and recognized that trusted authentication

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,

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

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-04-2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote: > > > Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that > script, but it did produce errors. > > http://www.firebirdfaq.org/faq141/ This is the backup script I used. >

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

2020-04-17 Thread Shane delphi_ric...@yahoo.co.uk [firebird-support]
produced with restoring, like size error On 17/04/2020 17:22, John vdW j...@jvdw.nl [firebird-support] wrote: For gbak on a windows machine: "c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA -pas masterkey backupfilename.fbk targetfilename.fdb -c to create a n

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

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
reef Shane delphi_ric...@yahoo.co.uk [firebird-support]: The Firebird version was not tampered with in this fault. Although what's I thought was strange is the support person uninstalled Firebird then re-installed. I never saw him going to Microsoft service file to stop Firebird. Could someo

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

2020-04-17 Thread Shane delphi_ric...@yahoo.co.uk [firebird-support]
on getting a file size error. On 17/04/2020 15:17, John vdW j...@jvdw.nl [firebird-support] wrote: Actually I meant the Firebird Server version. Are they the same on Linux and Windows? GBak is designed to make a backup on the fly, even with many users connected and using the database. No need

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

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
database file. Op 18-04-2020 om 16:01 schreef Shane delphi_ric...@yahoo.co.uk [firebird-support]: I agree with the version, as the company comes out with different version of there client software, that does an update change. The other part of not switch off the Firebird before copying

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

2020-04-17 Thread Shane delphi_ric...@yahoo.co.uk [firebird-support]
the Client program running from the Linux server through Samba will be the exact version as the one running correctly from Windows XP, which works. Still showing it's corrupted, according to the support person from Delfin company. On 17/04/2020 13:53, DougC d...@moosemail.net [firebird-support] wrote

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

2020-04-17 Thread DougC d...@moosemail.net [firebird-support]
In your description you did not include a step to shutdown the server or database on Windows before copying it to Linux. Did you do that? Doug C. On Fri, 17 Apr 2020 05:21:03 -0400 Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote I've been dealing with this company

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

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 17-04-2020 13:35, Nick Upson nick.up...@gmail.com [firebird-support] wrote: > I've had a similar issue when the database code was looking for custom > UDF's that had not been installed on the destination, in some ways that > can appear as corruption even though it isn't In Firebi

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

2020-04-17 Thread Nick Upson nick.up...@gmail.com [firebird-support]
I've had a similar issue when the database code was looking for custom UDF's that had not been installed on the destination, in some ways that can appear as corruption even though it isn't -- Nick On Fri, 17 Apr 2020 at 12:15, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote

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

2020-04-17 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote: > The scenario that I've setup is Opensuse is the main OS. I'm running > Windows XP on a VirtualBox. So within Windows XP I communicate to the > Linux OS through samba, copying to the folder the database i

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

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
with a generic error like "database corrupted" Sent from my iPhone > On 17 Apr 2020, at 11:17, Shane delphi_ric...@yahoo.co.uk [firebird-support] > wrote: > >  > > Thank you very much for the quick reply. > > The scenario that I've setup is Opensuse is the

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

2020-04-17 Thread Shane delphi_ric...@yahoo.co.uk [firebird-support]
I've been dealing with this company support. https://www.delter.co.za/ I'm an IT professional. Support Windows, Linux, Apple Mac. I have a technical question. When I copy a firebird database, from Windows to the Linux file system through Windows. Deactivate Linux firebird 2.5 first then replace

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

2020-04-17 Thread Shane delphi_ric...@yahoo.co.uk [firebird-support]
/2020 10:56, John vdW j...@jvdw.nl [firebird-support] wrote: Shane, AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database from one computer to another, especially from one OS to a different OS. Use the Gbak tool on the original machine to create a backup file. Use the GBak

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

2020-04-17 Thread John vdW j...@jvdw.nl [firebird-support]
to a FB database. Good luck! John Op 17-04-2020 om 10:47 schreef Shane Richmond delphi_ric...@yahoo.co.uk [firebird-support]: I see the Group is on Yahoo. Which I have also an account for a very long time. I've been dealing with this company support. https://www.delter.co.za/ <ht

[firebird-support] Technical IT specialist Firebird corruption

2020-04-17 Thread Shane Richmond delphi_ric...@yahoo.co.uk [firebird-support]
I see the Group is on Yahoo. Which I have also an account for a very long time. I've been dealing with this company support. https://www.delter.co.za/I'm an IT professional. Support Windows, Linux, Apple Mac. I have a technical question. When I copy a firebird database, from Windows to the

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

2020-04-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 11-04-2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote: > Hi @all! > > I'm trying to implement some sort of user manager into an app and want > to use the firebird-users and roles as user and authentification > source (using FB 3). > > Most of it works pe

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 a

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

2020-04-11 Thread Lukas Gradl fireb...@ssn.at [firebird-support]
Hi @all! I'm trying to implement some sort of user manager into an app and want to use the firebird-users and roles as user and authentification source (using FB 3). Most of it works perfectly. There's just one little problem: If I create or drop a user via CREATE USER or DROP USER and do a

Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl > [firebird-support] wrote: >> Hi >> >> Simply replace security3.fdb by ine from the zip install and >> initialize sy

Re: [firebird-support] Forgot sysdba password

2020-04-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > Hi > > Simply replace security3.fdb by ine from the zip install and > initialize sysdba Doing that will lose all other users in the security database, so that is not a good idea. Instead, s

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,

RE: [firebird-support] Forgot sysdba password

2020-04-09 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiSimply replace security3.fdb by ine from the zip install and initialize sysdbaRegards,Karol Bieniaszewski null

[firebird-support] Forgot sysdba password

2020-04-08 Thread Andrea Raimondi andrea.raimo...@gmail.com [firebird-support]
Hi! I have googled around a bit but can't seem to find anything simple to sort this problem out. I may have to reinstall the thing altogether. What I'd like to do is to reset the pw to something known (for, I am fairly sure I can't just recover it, it'll need to be reset). Suggestions?

[firebird-support] Re: Re: error during the registratione of data on 2.5 FB database. SOLVED

2020-04-06 Thread 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
- - - - - - - - - Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] ha scritto: > > On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com > [firebird-support] wrote: > > He, > > I've an error that I don't undestrand. > > I use Delphi

Re: [firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 04-04-2020 13:01, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > No, there is not a trigger. > > You say than the error is referred to another part (with mistaken value) > of the entire script... but the compiler reports me the part that > (maybe

Re: [firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
Rotteveel m...@lawinegevaar.nl [firebird-support] ha scritto: > > On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com > [firebird-support] wrote: > > He, > > I've an error that I don't undestrand. > > I use Delphi 7 environment to create my applications, Zeos com

Re: [firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia.com [firebird-support] wrote: > He, > I've an error that I don't undestrand. > I use Delphi 7 environment to create my applications, Zeos components > for connections and Firebird 2.5 Superserver for database management. &

[firebird-support] error during the registratione of data on 2.5 FB database

2020-04-04 Thread 'Stellarancia.com' ni...@stellarancia.com [firebird-support]
knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings onl

Re: [firebird-support] Potential for improvements / optimization for the use case below?

2020-04-02 Thread Patrick Marten patrick_mar...@yahoo.com [firebird-support]
Thank you for your reply, Lester. I came across CTE during my research, but wasn't sure it was the right thing for this case. Looked more detailed into it and came up with this: with TOTAL_STOCKS as (   select PRODUCTID, STORAGE_AREA_ID_SOURCE, sum(AMOUNT) as TOTAL_STOCK   from

Re: [firebird-support] Potential for improvements / optimization for the use case below?

2020-04-02 Thread Lester Caine les...@lsces.uk [firebird-support]
On 02/04/2020 08:12, Patrick Marten patrick_mar...@yahoo.com [firebird-support] wrote: > There was an other procedure that took long, and I was able to > drasticaly improve it by adding one multi-segment index, but all my > attempts to do the same in the case above didn't have much

[firebird-support] Potential for improvements / optimization for the use case below?

2020-04-02 Thread Patrick Marten patrick_mar...@yahoo.com [firebird-support]
Greetings, I've the following table: CREATE TABLE STOCK_RECORDS (   ID                                    INTEGER                    NOT NULL,   LOCATION                            SMALLINT,   INSERTUSER                        SMALLINT                    DEFAULT 0,     <-- FOREIGN KEY

[firebird-support] Re: Firebird vs Intebase

2020-03-26 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Mark Rotteveel m...@lawinegevaar.nl [firebird-support] a écrit : > On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: >> 26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] >> wrote: >>> Form Em

Re: [firebird-support] Firebird vs Intebase

2020-03-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 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 int

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,

[firebird-support] Firebird vs Intebase

2020-03-26 Thread Tommi Prami tommi.pr...@suonentieto.fi [firebird-support]
Form Embarcadero marketing matriel, has there been any tests lately? Early on FB was faster I think. (https://community.idera.com/developer-tools/b/blog/posts/interbase-isv-database-comparison) InterBase v FirebirdFirebird Summary: InterBase is faster, vastly more scalable, is packed with

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

2020-03-25 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
Thanks a lot. Now it works. Gregor Sent from Yahoo Mail. Get the app On Wednesday, March 25, 2020, 2:27:12 PM GMT+1, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > Hello M

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

2020-03-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > Hello Mark > > Yes I am aware of that, but I have no experience with the snapshots. > How do I make the current snapshot work. I run the file > "Install_service.bat". The Firebird servi

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 > > Ins

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

2020-03-25 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
lease read the Compatibility chapter in the release notes for this version. Gregor Sent from Yahoo Mail. Get the app On Wednesday, March 25, 2020, 1:06:35 PM GMT+1, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:   On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com

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

2020-03-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com [firebird-support] wrote: > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the > fbclient.dll (64Bit) my program crashes! when i u

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

2020-03-24 Thread DougC d...@moosemail.net [firebird-support]
Please move messages about Firebird 4 (and any unreleased version) to developers mailing list!

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

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit : > SET BIND OF TIME ZONE TO LEGACY ; for more complete information on "bind", the documentation is here https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md -- Norbert Saint

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

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > But the new field typ Timestamp_tz are a bigger problem. So i think, we > running into a compatibility problem with older developer systems. I use > Delphi Rio 10.3.3 with FireDAC, but its not possible for me t

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

2020-03-24 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
Saint Georges n...@tetrasys.eu [firebird-support] wrote: Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the fbclient.dll &g

[firebird-support] فتح باب الالتحاق بالجامعات البريطانية لدرجة البكالوريوس في مجالات الادارة ونظم المعلومات

2020-03-24 Thread غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]
[Non-text portions of this message have been removed]

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

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the fbclient.dll > (64Bit) my program crashes! when i use the 64bit dll fr

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

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Newest version of what? EMS? FDAC? Or FB4? sources of FB4 :-) as a working client with FB4 currently, there is RedDatabase from RedSoft (https://reddatabase.ru/downloads/redexpert/) or IBExpert (https://www.ibexpert.

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

2020-03-24 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
Hello Norbert Newest version of what? EMS? FDAC?  Or FB4? Thx Gregor Sent from Yahoo Mail. Get the app On Tuesday, March 24, 2020, 11:02:39 AM GMT+1, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit

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

2020-03-24 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit : > Hello > > I try a little bit with the FB4 beta 1 > > two errors i got > 1. When i try to connect with my 64Bit program and using the fbclient.dll > (64Bit) my program crashes! when i use the 64bit dll fr

[firebird-support] Firebird 4.0.0-1436 beta 1

2020-03-24 Thread Gregor Kobler gregorkob...@yahoo.com [firebird-support]
Hello I try a little bit with the FB4 beta 1 two errors i got 1. When i try to connect with my 64Bit program and using the fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also when i use the 32bit version with my 32bit program. I used the dll from

Re: [firebird-support] Firebird and Sam Broadcaster

2020-03-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22-03-2020 03:06, Audio Buff npage@gmail.com [firebird-support] wrote: > During the install of Sam Broadcaster, there are a few database options, > Firebird being named as the most simple to get started. I used the Firebird > version from the official archive, the latest versio

[firebird-support] Firebird and Sam Broadcaster

2020-03-21 Thread Audio Buff npage....@gmail.com [firebird-support]
During the install of Sam Broadcaster, there are a few database options, Firebird being named as the most simple to get started. I used the Firebird version from the official archive, the latest version. When selecting Firebird with default options with in the Sam Broadcaster, it errors; [image:

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

2020-03-20 Thread Pro Turm protu...@mailbox.org [firebird-support]
> On March 20, 2020 11:16 AM Dimitry Sibiryakov > > What could be the possible reasons for getting this error? > >BLOB id must be used in the same transaction where it was obtained. And if the BLOB id is the same all over one transaction ?

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,

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

2020-03-20 Thread Pro Turm protu...@mailbox.org [firebird-support]
What could be the possible reasons for getting this error? error: -901: invalid BLOB ID 10x in advance!

[firebird-support] الحصول على البكالوريوس من خلال التعليم الإلكتروني فى الجامعات البريطانية

2020-03-17 Thread غادة الرفاعى ghada.elref...@yahoo.com [firebird-support]
[Non-text portions of this message have been removed]

Re: [firebird-support] problemtic User management on firebird 3

2020-03-15 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
n/reference_manuals/fblangref25-en/html/fblangref25-ddl-db.html [2]: https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-auth-create-user On 14-03-2020 18:07, Yannis Kozikopoulos jk...@freemail.gr [firebird-suppo

[firebird-support] problemtic User management on firebird 3

2020-03-14 Thread Yannis Kozikopoulos jk...@freemail.gr [firebird-support]
this is a new installation no existing databases no legacy code to support. After installing the 64bit server on windows 7 machine file name Firebird-3.0.5.33220_0_x64.exe then do the following c:> "c:\Program Files\Firebird\3_0\isql.exe" Use CONNECT or CREATE DATABASE to specify a database

Re: [firebird-support] Ubuntu 3.0.5 version

2020-03-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-03-2020 14:49, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released > in October 2019. The official version on the Firebird website is > 3.0.5.33220, released in January 2020. This is ok

Re: [firebird-support] mapping destroyed by backup / restore

2020-03-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
This sounds like a bug to me. Can you create bug report in the tracker at http://tracker.firebirdsql.org/browse/CORE Mark On 09-03-2020 03:50, FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support] wrote: > > > Hi – I have another question re user mapping… > > If

ODP: [firebird-support] Re: is it possible to drop all indexes, except those related to PKand FK?

2020-03-13 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
Hi If you join with contraints you have better control. An personally i prefere easier way, like simple select. If you really need to delete all instead of PK and FK you should not exclude uniques as you ommit custom unique indexes. SELECT 'DROP INDEX ' || TRIM(I.RDB$INDEX_NAME) || ';',

[firebird-support] Ubuntu 3.0.5 version

2020-03-13 Thread Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]
Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released in October 2019. The official version on the Firebird website is 3.0.5.33220, released in January 2020. This is ok in terms of stability, if I want to use the Ubuntu package? Thanks

[firebird-support] Re: is it possible to drop all indexes, except those related to PK and FK?

2020-03-13 Thread hamacker sirhamac...@gmail.com [firebird-support]
response to my self, is it correct? execute block returns (drop_index_name varchar(31), dropped boolean) as declare variable doit boolean; declare variable stmt varchar(2048); begin dropped=false; -- test before for select i.rdb$index_name from rdb$indices i where

[firebird-support] is it possible to drop all indexes, except those related to PK and FK?

2020-03-12 Thread hamacker sirhamac...@gmail.com [firebird-support]
Is it possible to drop all indexes, except those related to PK and FK? I would like to do a test and recreate them by script.

RE: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
"The mappings in our database survive one cycle of this but disappear on the second cycle (tested using gbak from Firebird 3.0.5).  Changing the backup procedure only hides this issue (if you actually have to restore a backup then you're halfway there…)"Go to the Firebird bug tacker and create

[firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-11 Thread FSPAPA INCA Team i...@foodstuffs-si.co.nz [firebird-support]
t part of db backups. The security db could be backed up as is rather than using gbak, and it's also feasible to store the entire security db setup as an sql script. Especially mappings, which don't contain passwords. From: firebird-support@yahoogroups.com Sent: Wednesday, 11 March 2020 9

Re: [firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support]
Thank you very much for all your replies. I will try the "Clear Pools" option with the Firebird ADO.NET provider first. If that doesn't work, I have come up with the idea to start a small, external process that will check for the release of the file by the application and then delete it...

[firebird-support] Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Elmar Haneke el...@haneke.de [firebird-support]
Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-sup

Re: [firebird-support] Re: Cannot delete Firebird database file as it is in use by the application..

2020-03-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-10 22:04, Steve Naidamast blackfalconsoftw...@outlook.com [firebird-support] wrote: > Hello... > > I am developing a security extension, which is used as a loaded > assembly to my main application, all of which use the Firebird > Embedded Edition 2.59 for my applica

Re: [firebird-support] Firebird client connection timeout

2020-03-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2020-03-10 20:14, Andrei Luís compuvale.softw...@gmail.com [firebird-support] wrote: > Hummm, I think Dimitry is right. I made some tests here on client > side: > > server IP: 10.0.2.2 > path: d:\database.fdb > > Using connection string: 10.0.2.2:d:\database.fdb Cor

AW: [firebird-support] RE: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-11 Thread 'Mathias Pannier (unitel)' pann...@ubsysteme.de [firebird-support]
> Though it might be helpful if a warning was issued when specifying an unknown > plugin name. This would be a nice feature. A check if the domain/group was correct is also desirable. Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 6

[firebird-support] AW: How can I use/map Active Directory Groups within my Firebird in Trusted Authentication mode?

2020-03-11 Thread 'Mathias Pannier (unitel)' pann...@ubsysteme.de [firebird-support]
Thank You very very much and sorry for this stupid mistake. Now it works as expected. Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 6. März 2020 04:46 An: firebird-support@yahoogroups.com Betreff: [firebird-support] RE: How can I use/map Active

<    1   2   3   4   5   6   7   8   9   10   >