I already have to fb3 running alongside fb4
but with some strange problems ..

some examples :

isql from firebird 4
C:\Program Files\Firebird\Firebird_4_0>isql.exe fb3 -user SYSDBA -password
masterkey
Database:  fb3, User: SYSDBA

1---------------------
SQL> select current_user from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 8
-current_user

2-------------------------------
SQL> select current_date from rdb$database;

             CONSTANT
=====================
   0.0000000006702624

3-------------------------------
SQL> select current_time from rdb$database;

USER
===============================
SYSDBA

 4-------------------------------
SQL> select current_timestamp from rdb$database;

ROLE
===============================
NONE


select * from [any table from database] runs ok


Firebird versions
  FB3 : 3.0.4.33054
  FB4:  4.0.0.1963

Configuration :
   copy engine12.dll to plugins
   copy security3.fdb  to firebird root page

  database.conf
fb3 = d:/Projectos/database/fb3/PINGWIN_30.FDB
{
Providers = Remote,Engine12,Loopback
SecurityDatabase = $(dir_secDb)/security3.fdb
}


Any mistake on my configuration or is firebird problem?

I have another question ...
The provider configuration must be on a database level or can I configure
one a folder level ?


Regards
jGoncalves


<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to