I am currently evaluating Firebird for my company. One of the requirements they have is to keep a log of login attempts for auditing purposes. Is this somehow...
... Clarification :: Double or single quotes in isql (both work); double quotes needed at the command line if you have spaces in the path name; otherwise NO...
... Tried using SET TRANSACTION and get message ODBC [State::HY000] Error::invalid transaction handle (expecting explicit transaction start) Tried with an...
Hi Friends!
Does anyone know a free tool for convert Oracle database to Firebird? I am
needing to perform such a job.
Thanks in advance.
Regards,
Carlos...
... SET TRANSACTION isn't used directly with the ODBC interface. Ask on the firebird-odbc-devel list for the syntax to control the transaction, and where the...
Hi, I want to do a constant synchronization between one main DB on one server and multiple "satellite DBs" on other servers. Whenever a record (of the relevant...
... with ... the same ... computer I ... error; ... double ... Hi Helen, Thanks for your reply. I'm still not sure why the command line I typed in didn't work...
... there are numerous replication regimes and methodologies around. Check out www.ibphoenix.com for a full list of tools. I prefer the method of triggered...
Hi Guys, I am tryin to restore a database. Almost at the end, maybe after index creation I receive the following message: gbak: ERROR: invalid request BLR at...
I have a problem with this query: "SELECT KOD_ZONES FROM ZONES ORDER BY KOD_ZONES NULLS FIRST" On that query I get following error message: "Dynamic SQL Error...
... No offence, but if - according to you - it's trivial enough to build a free tool to do this, feel free to do so :) If this is a one-time thingy, you might...
... How could you order by nulls, exactly? Your statement above is perfectly valid syntax for a Dialect 3 database. It won't work on a Dialect 1 database. ...
Hi, I have a problem with Firebird 1.5.2 on a Red Hat 9.0. The firebird.log show me a message error: server.domain (Server) Mon Aug 1 10:36:54 2005 ...
What can I do to prevent DELETE/INSERT/UPDATE on a table? I suspect a trigger will be involve, but... Thank you. </doru> [Non-text portions of this message...
Doru Constantin
doru.constantin@...
Aug 1, 2005 1:56 pm
64373
I have a Linux box (Fedora 3) runnign FB 1.5.2 and i need to install FB 1.0.3 in the same box. - Is there some problem of doing this? - Is it just to extract...
... The log is reporting an error from the TCP/IP network - "Connection reset by peer". In this case, the server has lost contact with a client. Often it...
... Not really. By the time a trigger fires, the operation is already under way, i.e. allowed. Use privileges. Assign the desired set of restrictive...
Just curious.... What, if I creat a before delete trigger, and depending on circumstences, I raise an exception? Wouldn't it keep record from deleting? ... ...
... Alternatively, raise an exception in the trigger and the changes will be cancelled. With regards, Martijn Tonies Database Workbench - tool for InterBase,...
... I raise an exception? Wouldn't it keep record from deleting? Yes, but you also have to handle the exception in the calling application, of course. With...
... I raise an exception? Wouldn't it keep record from deleting? ... If my only aim is to prevent a record from deleting, it isn't necessary. For the poor...
Hello Carlos, ... isn't ... develop ... was ... Ah, but Firebird wasn't created from scratch :-) And yes, Firebird is free, but Firebird development isn't. ...
... Yes. For example, you can do this: create exception KICK_BAD_GUYS 'You are not allowed to interfere with this data'; Commit; -- of course! create trigger...
... I'm sorry. I checked dialect again and found that dialect is correct -3, but I found I use isql version 1.5 but server is running 1.0.3 (that is the reason...
... the ... Thanks Helen Downloaded latest ODBC driver from http://www.praktik.km.ua/ as the SET TRANSACTION was implemented about January 2005. Appears OK now...
... Nothing is "free beer". You are lucky that you don't have to pay to use Firebird. You get that luck because skilled developers are working for nothing,...
