| Subject | RE: [firebird-support] Can't access MON$ tables |
|---|---|
| Author | Michael D. Spence |
| Post date | 2013-05-05T20:05:03Z |
Ah. FlameRobin shows ODS Version 11, not 11.1 so that explains that. The
thing is, I downloaded the latest versions of Firebird and FlameRobin last
night and created a new database. Before I did that I removed an older
version (2.1, IIRC). Would there have been stuff left behind that tells FB
what ODS version to use? There were a couple of the old databases still
registered to FlameRobin and of course the new version was aware of them.
Anyway, I unregistered the server and the databases, then reregistered the
server and created a database and now the ODS version is 11.2.
Thanks for the quick response!
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Sunday, May 05, 2013 3:29 PM
To: firebird-support@yahoogroups.com; firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can't access MON$ tables
At 07:11 a.m. 6/05/2013, mspencewasunavailable wrote:
The MON$ tables are created in databases of ODS 11.1 or higher. Probably
you haven't upgraded your databases yet.
Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The
Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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
thing is, I downloaded the latest versions of Firebird and FlameRobin last
night and created a new database. Before I did that I removed an older
version (2.1, IIRC). Would there have been stuff left behind that tells FB
what ODS version to use? There were a couple of the old databases still
registered to FlameRobin and of course the new version was aware of them.
Anyway, I unregistered the server and the databases, then reregistered the
server and created a database and now the ODS version is 11.2.
Thanks for the quick response!
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Sunday, May 05, 2013 3:29 PM
To: firebird-support@yahoogroups.com; firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can't access MON$ tables
At 07:11 a.m. 6/05/2013, mspencewasunavailable wrote:
>I just installed the latest 64-bit version of Firebird(Firebird-2.5.1.26351_1_x64.exe). The MON$ tables don't seem to be there:
>do anything extra. Anyone have a suggestion?
>select * from mon$statements
>
>Engine Code : 335544569
>Engine Message :
>Dynamic SQL Error
>SQL error code = -204
>Table unknown
>MON$STATEMENTS
>At line 1, column 15
>
>
>I didn't see anything in firebird.conf or the release notes about having to
The MON$ tables are created in databases of ODS 11.1 or higher. Probably
you haven't upgraded your databases yet.
Helen Borrie, Support Consultant, IBPhoenix (Pacific) Author of "The
Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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