Subject | RE: FB 2.5 database allow only one connection to SYSDBA |
---|---|
Author | Nols Smit |
Post date | 2011-01-12T12:25:13Z |
You'r so clever :), or is it FireBird?
________________________________
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær
Sent: 12 January 2011 12:30
To: 'firebird-support@yahoogroups.com'
Subject: [firebird-support] RE: FB 2.5 database allow only one connection to SYSDBA
Sounds like the database is shutdown.
Try (well, try it on a copy first - I've never used gfix -o myself, so although I believe it is safe, don't trust my advice on any production database)
gfix -o <databasename>
to bring it back online.
HTH,
Set
-----Original Message-----
From: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com> [mailto:firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com>] On Behalf Of Nols Smit
Sent: 12. januar 2011 10:45
To: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com>
Subject: [firebird-support] FB 2.5 database allow only one connection to SYSDBA
Hi,
On my PC, I have fb2.5 Super Server installed. Only one of many databases allows only one connection to SYSDBA at a time. Even with IBExpert, I expience the same problem. All the other databases do allow multiple simultaneous connecetions.
User SYSDBA has 'Grant to All WITH GRANT option' on all objects.
Has anyone advice about how to solve the problem?
Regards,
Nols Smit
[Non-text portions of this message have been removed]
________________________________
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær
Sent: 12 January 2011 12:30
To: 'firebird-support@yahoogroups.com'
Subject: [firebird-support] RE: FB 2.5 database allow only one connection to SYSDBA
Sounds like the database is shutdown.
Try (well, try it on a copy first - I've never used gfix -o myself, so although I believe it is safe, don't trust my advice on any production database)
gfix -o <databasename>
to bring it back online.
HTH,
Set
-----Original Message-----
From: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com> [mailto:firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com>] On Behalf Of Nols Smit
Sent: 12. januar 2011 10:45
To: firebird-support@yahoogroups.com<mailto:firebird-support%40yahoogroups.com>
Subject: [firebird-support] FB 2.5 database allow only one connection to SYSDBA
Hi,
On my PC, I have fb2.5 Super Server installed. Only one of many databases allows only one connection to SYSDBA at a time. Even with IBExpert, I expience the same problem. All the other databases do allow multiple simultaneous connecetions.
User SYSDBA has 'Grant to All WITH GRANT option' on all objects.
Has anyone advice about how to solve the problem?
Regards,
Nols Smit
[Non-text portions of this message have been removed]