Thanks!




________________________________
From: Helen Borrie <helebor@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, August 16, 2009 9:40:49 PM
Subject: Re: [firebird-support] How to set database page size in embedded mode?


At 01:17 PM 17/08/2009, you wrote:

>Sorry, Firebird 2.1.2 and Jaybird 2.1.6.
>
>I am creating a brand new database. Where can I change the default page size?

Include the PAGE_SIZE attribute in the CREATE DATABASE statement. The v.2.1 engine creates a database with the default page size of 4096 bytes. Higher sizes can be 8192 or 16384.

>Is there a tool that can connect to the database file created in embedded mode? (I am using Windows XP)

That's an ambiguous question. ;-) So, to handle both angles of the ambiguity:

Any tool can connect to a database, whether it was created by the embedded engine or by the full server engine.

You can use your favourite tool to connect to a database in embedded mode. You will need the embedded client (fbembed.dll) to be in the same directory as the tool executable. The tool can only connect to the database if it can get exclusive access to the database. As a tip, don't use embedded mode to do your database development: it's not designed for that. It is a deployment model.

As for Jaybird-specific ways to create databases, ask on the firebird-java list.

./heLen




[Non-text portions of this message have been removed]