Re: [firebird-support] connecting to an existing firebird database using new user id/pw

2016-12-15 Thread 'Helen Borrie' hele...@iinet.net.au [firebird-support]
i have a database created and access on Firebird for years. i've always used the id/pw sysdba/masterkey all i want to do is: change my delphi IBO Objects tIBConnection.username to 'mynewuser' and .password to 'mynewpassword' i am not sure what to use in .SQLROLE?  i've tried 'RDB$ADMIN'  and

Re: [firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

2016-12-15 Thread Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support]
Well I would prefere to do a commit in this case. It's a hanged connection because power went out and could not commit some large transaction. But i guess i can't do it as they answer it. Thanks anyway Jaume 2016-12-15 9:39 GMT+01:00 liviuslivius liviusliv...@poczta.onet.pl [firebird-support]

Re: [firebird-support] Commit MON$TRANSACTIONS by TRANSACTION_ID

2016-12-15 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi,   did you mean rollback? not commit?   regards, Karol Bieniaszewski   W dniu 2016-12-14 17:44:16 użytkownik Jaume Llunell Gómez jaumellun...@gmail.com [firebird-support] napisał:   Hi,   is it possible to commit a transaction that is hanged in the