Subject Re: [firebird-support] RE: FB 2.5 database allow only one connection to SYSDBA
Author Thomas Steinmaurer
> You'r so clever :), or is it FireBird?

Both. ;-)



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!


> ________________________________
> 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]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>