[firebird-support] service_mgr is not defined - calling from PHP

Hi I am trying to write a PHP script to create a new Firebird user but when I run the code I get the following: Service DB - Could not connect: Cannot attach to services manager service var/lib/firebird/2.5/data/grip.fdb:service_mgr is not defined I am running Firebird 2.5 on Ubuntu. This is the

[firebird-support] Re: service_mgr is not defined - calling from PHP

; } Thanks Neil --- In firebird-support@yahoogroups.com, grip_2ls lists@... wrote: Hi I am trying to write a PHP script to create a new Firebird user but when I run the code I get the following: Service DB - Could not connect: Cannot attach to services manager service var/lib/firebird/2.5/data

[firebird-support] Re: service_mgr is not defined - calling from PHP

) { $smarty-assign('msg', 'Service DB - Could not connect: ' . ibase_errmsg()); $smarty-display('feedback.tpl'); break; } Thanks Neil --- In firebird-support@yahoogroups.com, grip_2ls lists@ wrote: Hi I am trying to write a PHP script

[firebird-support] Re: service_mgr is not defined - calling from PHP

Lester/Thomas Thanks for your help - you are right as soon as I took out the db name it worked! Thanks again Neil --- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote: grip_2ls wrote: * Service DB - Could not connect: Cannot attach

[firebird-support] Is it possible to suspend a generator?

Hi I need to insert some data with fixed IDs. The table that I am inserting into already has data and a generator for the IDs. The new data is below the value of the generator and the IDs do not already exist. Can I suspend the generator while I insert these new rows and if so how? Thanks

[firebird-support] Passing process name via jdbc

Hi I want to be able to pass the process name when connecting from JSP. Currently my code is setup as follows: String DB = jdbc:firebirdsql://123.123.123.123:3050/C:\\grip\\data\\grip.fdb; java.sql.Connection con = java.sql.DriverManager.getConnection(DB, user, password); Is it possible to

[firebird-support] Re: Passing process name via jdbc

Thanks for the info I will give it a go. Thanks Neil --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Tue, 24 Jan 2012 13:55:23 -, grip_2ls lists@... wrote: Hi I want to be able to pass the process name when connecting from JSP. Currently my code

[firebird-support] Re: UK based Firebird on Linux expert

of the disk is formatted as ntfs. I believe that this is because the machine is also used as samba mounts for Windows, but I could be wrong on this point. Does any of the above provide any pointers? Thanks Neil --- In firebird-support@yahoogroups.com, Lester Caine lester@... wrote: grip_2ls wrote

[firebird-support] Feature not supported on ODS version older than 11.1 - how to find out what?

Hi I am trying to create the following SP but am receiving the message Feature not supported on ODS version older than 11.1 but I cannot work out what it is that it doesn't like about the SP. For information this is a Firebird 2.1 database but it is an ODS v10 SET AUTODDL OFF; SET TERM ^ ;

[firebird-support] Re: Help with trigger syntax

Thank you all for your help and advice. N --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Tue, 01 Nov 2011 10:00:38 +1300, Helen Borrie helebor@... wrote: At 07:56 AM 1/11/2011, you wrote: On 31-10-2011 17:46, grip_2ls wrote: Hi Mark Thanks for the advise

[firebird-support] Help with trigger syntax

Once again I am struggling with the syntax of a trigger. When I run the following I get the error: Error at line 3: Dynamic SQL ErrorSQL error code = -104Token unknown - line 19, column 25; There isn't even a semi-colon on line 19! Any advice gratefully received. Neil SET TERM ^ ; /* Triggers only

[firebird-support] Re: Help with trigger syntax

@yahoogroups.com, Mark Rotteveel mark@... wrote: On Mon, 31 Oct 2011 15:19:30 -, grip_2ls lists@... wrote: Once again I am struggling with the syntax of a trigger. When I run the following I get the error: Error at line 3: Dynamic SQL ErrorSQL error code = -104Token unknown - line 19, column 25

[firebird-support] Re: Help with trigger syntax

Hi Mark Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine. N --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel mark@... wrote: I am a bit

[firebird-support] Re: Find out how a user has connected to the database

Thomas We would be connected from Delphi and all our clients are on 2.1. But before I get this implemented in code I would like to see it in SQL. I have tried in both IBQuery and isql but whenever I run the following: select * from MON$ATTACHMENT; I always get an error that the table is

[firebird-support] Re: Find out how a user has connected to the database

Hi Thanks all for the information. The database is ODS 10.1 so I guess that is the problem. Thanks you all for your help. I will upgrade the db. Neil --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: Hello Neil, We would be connected from Delphi and all our

[firebird-support] Re: Find out how a user has connected to the database

Thanks Helen, I have just been looking at your Firebird 2 Supplement to work out just exactly how I do it! Neil --- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote: At 09:31 PM 20/10/2011, grip_2ls wrote: Hi Thanks all for the information. The database is ODS 10.1

[firebird-support] Re: What to install for Firebird client on Ubuntu

Hi Mark Coming from a Windows background what you are suggesting sounds counter intuitive but it does seem like the simplest approach. Thanks Neil --- In firebird-support@yahoogroups.com, markopetejan marko.petejan@... wrote: Yes, manually. It's much harder and you en up saving nothing.