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

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 i

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

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 edi

[firebird-support] delete from mon$attachments

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 n

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

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] connecting to an existing firebird database using new user id/pw

Hi-- Seems simple enough i shouldn't need to ask BUT i can't get it to work 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 .passw

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

Thanks for the detailed response Helen. I think i figure out the main reason none of the stuff i saw about "grant" and "users roles" etc. etc. worked... my database file is 2.1 format. Once i converted it to 2.5 format, everything worked how i figured it out given what you said and i read

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

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] using a stored procedure to return the value for an existing field in the table

Hi All, I have a table, Parts, with 30 fields in it. One is named: ExtraData5 and it's varchar(20). the Parts table has millions and millions of rows and ExtraData5 is in each. here's my question... when a normal statement: select * from parts where _some conditions_ is ex

[firebird-support] remote firebird server connection question

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 (o

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

[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