On Mon, Jan 5, 2009 at 22:52, Dean Harding <[email protected]> wrote:
>> I think, FbBatchScript not support CREATE DATABASE in Embedded Server?
>
> Right. As I said, the embedded server works on database files directly, so
> you need to create the database with FbConnection.CreateDatabase. You can
> still use FbBatchScript to populate the database with tables and so on.
FbBatchExecution is in fact internally calling
FbConnection.CreateDatabase, but there's no way to tell thru standard
command:
// CREATE {DATABASE | SCHEMA} 'filespec'
// [USER 'username' [PASSWORD 'password']]
// [PAGE_SIZE [=] int]
// [LENGTH [=] int [PAGE[S]]]
// [DEFAULT CHARACTER SET charset]
// [<secondary_file>];
that it should use embedded server, so it will use isc_create_database
from fbembed.dll.
What comes to my mind - but not tested, just guess that it may work -
is to provide dummy connection string with ServerType=1. Then maybe
the create database isql command will not rewrite the ServerType so it
will be done using embedded server.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
