[firebird-support] Re: remote firebird server connection question

2017-07-10 Thread av...@telusplanet.net [firebird-support]
[solved] i kept hammering away at trying to figure out the configuration and finally did... virus software with very clumsy UI caused most of grief. thanks

[firebird-support] remote firebird server connection question

2017-07-09 Thread av...@telusplanet.net [firebird-support]
Hi, I've got a computer that is running Firebird and has a database on it. I can talk to the DB using FlameRobin or any SQL tool, locally on that computer. let's say the public IP of this computer is 68.68.68.171 The meat of my question: how do i configure this remote firebird server

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

2016-12-19 Thread av...@telusplanet.net [firebird-support]
Thanks for the information!! I tried doing a gbak on 2.1 and restoring on 2.5. Small DB. Worked great. Access seemed a lot faster too. Again, thanks. Cheers

[firebird-support] Re: delete from mon$attachments

2014-10-28 Thread av...@telusplanet.net [firebird-support]
great, thanks. i'll do some coding then to check the transactions that seem orphaned and delete the attachment that is the 'gone' application session that started that transaction and delete the attachment effectively deleting the transaction.

[firebird-support] delete from mon$attachments

2014-10-27 Thread av...@telusplanet.net [firebird-support]
Hi-- I've got a problem. I've got a FB 2.5.2 64-bit install. i believe it's installed as 'super server' (it's using \Firebird_2_5\bin\fbserver.exe' running as a service) there are always several instances of my application running, connected to the same DB using that FB. every

[firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
Hi-- I've got a FB 2.5 app that uses IBO components and Delphi The instance has perhaps 40 concurrent users. Someone would potentially have a record in 'edit' mode. Another user does a read-only (tIBOQuery.RequestLive := False) select from the same table. Not always, but once

Re: [firebird-support] read-only select generates 'lock conflict on no wait transaction'?

2014-09-18 Thread av...@telusplanet.net [firebird-support]
thanks for the quick reply i'll create another IBOTransaction and use it for the one query that is doing the 'read-only' simple select that is resulting in the error. would you expect that error to occur every time a 2nd user does a readonly select that includes the 1st users record in