Re: [Firebird-net-provider] Problems using the Provider in VS .NET / System.IO.FileNotFoundException

[Carlos G. A. <car...@te...>]

Hello:


> That´s right, CreateDatabse was the function I meant. The default PageSize
> for 
> Interbase 6.0 is 2048. Due to performance issues it is recommended that you
> increase
> the pagesize to 4096. Normally I used in C++ with the IB6 API these commands
> to create a database:
> 
>   isc_db_handle db = 0L;  // DB Handle
>   isc_tr_handle tr = 0L;  // Transaction Handle
>   ISC_STATUS status[20];
> 
>   t_string sql = (t_string)"CREATE DATABASE " + "'" + dbname + "' PAGE_SIZE
> 4096 USER '" + ownerid + "' PASSWORD '" + ownerpwd + "' DEFAULT CHARACTER SET
> ISO8859_1";
>   isc_dsql_execute_immediate(status, &db, &tr, 0, sql.Value(), 3, NULL);
> 
> Afterwards I connect to this database and create all the external functions
> which are defined in the ib_udf.dll. If not, you don´t have alle the
> functions liek upper, lower, abs, substr, strlen etc.



Done, now you can spcefy the page size and the character set ( i need to 
verify if this works i will try to see it later today ).




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.