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

2011-10-19 Thread grip_2ls
Hi Thomas Thanks for the quick response. I have a few further questions... When I try and select from this table I get a message to say that it doesn't exist. I am logged in as sysdba - do I need to do anything else? My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185 I assume that

[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 unkno

[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 wrote: > > Hello Neil, > > > We would be connected from Delphi and all our clients

[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 wrote: > > At 09:31 PM 20/10/2011, grip_2ls wrote: > >Hi > > > >Thanks all for the information. > > > >The database is ODS 10.1 s

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

2011-10-19 Thread Thomas Steinmaurer
Hi Neil, > Thanks for the quick response. > > I have a few further questions... > > When I try and select from this table I get a message to say that it doesn't > exist. I am logged in as sysdba - do I need to do anything else? > > My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185 > >

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

2011-10-19 Thread Thomas Steinmaurer
>> Thanks for the quick response. >> >> I have a few further questions... >> >> When I try and select from this table I get a message to say that it doesn't >> exist. I am logged in as sysdba - do I need to do anything else? >> >> My db is 2.1.3.18185 and the GDS32.dll is version 6.3.3.18185 >> >>

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

2011-10-19 Thread Mark Rotteveel
On Wed, 19 Oct 2011 12:43:49 +0200, Thomas Steinmaurer wrote: >> But I know from Jaybird for instance, that one needs to specify specific >> properties, see: >> http://tracker.firebirdsql.org/browse/JDBC-118 >> >> But I guess this is related to the thin driver not communicating via the >> client l

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" To: firebird-support@yahoogroups.com Date: Thu, 20 Oct 2011 07:54:42 -0000 Subject: [firebird-support] Re: Find out how a user has connected to the

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

2011-10-20 Thread Thomas Steinmaurer
Hello Neil, > 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

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