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

2011-10-20 Thread grip_2ls
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

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

2011-10-20 Thread Alex
Write it as select * from MON$ATTACHMENTS; You were missing the last S Alex - Original Message - From: grip_2ls li...@2ls.com To: firebird-support@yahoogroups.com Date: Thu, 20 Oct 2011 07:54:42 - Subject: [firebird-support] Re: Find out how a user has connected to the database

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

2011-10-20 Thread grip_2ls
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

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

2011-10-20 Thread Helen Borrie
At 09:31 PM 20/10/2011, grip_2ls wrote: 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. ...after CAREFULLY studying the v.2.1 release notes and migration/compatibility guide, natch. ;-) You have a

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

2011-10-20 Thread grip_2ls
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