Re: [firebird-support] Changing SYSDBA password

2018-09-11 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]

Re: [firebird-support] how to resolve this deadlock

2018-09-11 Thread 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support]
On 10/09/18 22:52, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > > Hi Hamish. > > I am not sure if I understood clearly your problem. If I did, you > probably should use "WITH LOCK" clause. Thanks Hugo, that might work. But as the row might not exist yet, I would have to lock the whole

Re: [firebird-support] how to resolve this deadlock

2018-09-11 Thread 'Hamish Moffatt' ham...@risingsoftware.com [firebird-support]
On 11/09/18 00:48, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Hi Hamish! > > What exactly do you mean by "The queries kind of don't > actually conflict"? If they're trying to MERGE into the same row > simultaneously, then they do actually conflict, even if they contain

[firebird-support] Question on IB components

2018-09-11 Thread Robert Tulloch tult...@hughes.net [firebird-support]
Hi:   Trying to get old app using IB components to connect to FB 2.5. Should these components work with FB 2.5? Have all source etc. Thanks Best regards

Re: [firebird-support] Changing SYSDBA password

2018-09-11 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 11-9-2018 10:09, Tony Christiansen t...@adegroup.com.au [firebird-support] wrote: > I am using FB 3.0 and had the SYSPDA pw as masterkey. > > I changed it per the notes as I understood ie opened a database and ran > this query > > alter user sysdba set password 'newpassword' > > It

[firebird-support] Changing SYSDBA password

2018-09-11 Thread Tony Christiansen t...@adegroup.com.au [firebird-support]
I am using FB 3.0 and had the SYSPDA pw as masterkey. I changed it per the notes as I understood ie opened a database and ran this query alter user sysdba set password 'newpassword' It committed ok with no errors but I can still open databases using SYSDBA and masterkey as the password. I