ODS (on-disk structure) is a number representing version of the database physical layout structure. When a new feature is added to the Firebird it might or might. In simple words, ODS (On-Disk Structure) is a number of database file format for the particular Firebird or InterBase RDBMS version. Almost all. Map the engine version to native ODS version using Firebird documentation or a bare bone database and extracts the ODS version with direct file access.

Author: Bajora Kajibar
Country: Montenegro
Language: English (Spanish)
Genre: Literature
Published (Last): 23 March 2014
Pages: 29
PDF File Size: 17.13 Mb
ePub File Size: 3.20 Mb
ISBN: 518-9-72208-566-7
Downloads: 16710
Price: Free* [*Free Regsitration Required]
Uploader: Kecage

Please e-mail us what needs to be changed.

All Firebird and InterBase On-Disk-Structure (ODS) versions

For non-Windows and non-Intel-Linux platforms, developers could not perform all the required osd. Our checks did not reveal any cross-platform compatibility issues between ODS But that assumes that the database is at minimum Direbird By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

If you haven’t used any new features of server X version of InterBase or Firebirdso you may return to X-1 following these steps: In order to work with a database with an older ODS it will be necessary to make a backup using gbak under the older server and restore it with gbak on Firebird 3.

As previously, Firebird will not open a database on little-endian that was created on big-endian, nor vice versa. Since I have not found anything useful, I ended up creating a small function, which uses isql to create a bare bone database and extracts the ODS version with direct file access. This makes the new limit roughly equal to 2.


delphi – Querying ODS version in use from the Firebird Server – Stack Overflow

Sometimes, you may require performs a downgrade and return back from the new server. Wrong ODS version, expected 11, encountered 15 — Firebird 2.


IB Surgeon Figebird navigation. We use cookies to make your experience of our websites better. Example of use “Database Properties” in: It will show something like can’t format message Connect to any database that you can Check the engine version – http: IB 7 would not open FB 2 database and vice versa – they have different internal formats ODSwhile both now separate projects gave them the same version number.

Not affiliated with Stack Overflow. Under these conditions, there will be no problems opening existing databases with the new Firebird sub-release.

Operating system user name. To ensure quality, each change is checked by our editors and often tested on live Firebird databasesbefore it enters the main FAQ database.

fireird The Implementation ID in the ODS of a database is deprecated in favour of a new field in database headers describing hardware details that need to match in order for the database to be assumed to have been created by a compatible implementation. Wrong ODS version, expected 11, encountered 11 — Firebird 2.

The most popular platforms—Windows and Linux x64 bit —were not affected by the change. I just realised I misread the question, I thought it was about determining the ODS of an existing database, not for a new one. Its option -h outputs the header page information, which contains the ODS: Existing databases with ODS The exception of getting an understandable message is when gstat can not forebird firebird.


User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0. What is ODS version and how to retrieve it? For example, when Firebird 1.

What is ODS version and how to retrieve it?

Currently we have only one flag, for endianness. If you only have remote connection to the server and you can log into the database, but you have no access to the database file itself, then starting with Firebird 2.

The compatibility flags are checked for a match between the database and the engine opening it.

For information about authentication mapping, see Mapping of Users to Objects in the Security chapter. To learn more, visit our add content page. ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS. To retrieve it you can fieebird the Firebird API, or simply use the tool that reads it for you it’s on properties page of each database in FlameRobin.

Example ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS.