AuthServer = Legacy_Auth, Srp, Win_Sspi
AuthClient = Legacy_Auth, Srp, Win_Sspi
UserManager = Legacy_UserManager, Srp

execute ibeblock
as
   declare variable str varchar(256);
begin
  create connection con1 dbname '127.0.0.1:work'
   user 'SYSDBA' password 'masterkey'
   
   clientlib 'c:\Program Files\Firebird\Firebird_3_0\fbclient.dll'
   
   sql_dialect 1 names win1251;
   use con1; 


   delete from mn_cd;

   commit;


   close connection con1;
end

Error in script: mn_cd.sql
Error occurred while executing following statement (line 20):
--------  STATEMENT ----------
CREATE CONNECTION connection con1 dbname '127.0.0.1:work'
   user 'SYSDBA' password 'masterkey'

   clientlib 'c:\Program Files\Firebird\Firebird_3_0\fbclient.dll'

   sql_dialect 1 names win1251

--------  ERROR ----------
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
operating system directive CryptAcquireContext failed.
Библиотека поставщика проинициализирована неправильно. .



Script executed with errors.
Total execution time: 47ms

clientlib 'c:\Program Files\Firebird\Firebird_3_0\fbclient.dll'

#DatabaseAccess = Full
#RemoteAccess = true
#ExternalFileAccess = None
#UdfAccess = Restrict UDF
#TempDirectories =
#AuditTraceConfigFile =
#MaxUserTraceLogSize = 10
#DefaultDbCachePages = 2048
#DatabaseGrowthIncrement = 128M
#FileSystemCacheThreshold = 64K
#FileSystemCacheSize = 0
#RemoteFileOpenAbility = 0
#TempBlockSize = 1M
#TempCacheLimit = 64M
#AuthServer = Srp
AuthServer = Legacy_Auth, Srp, Win_Sspi

#AuthClient = Srp, Win_Sspi, Legacy_Auth
AuthClient = Legacy_Auth, Srp, Win_Sspi

#UserManager = Srp
UserManager = Legacy_UserManager, Srp

#TracePlugin = fbtrace
#WireCryptPlugin = Arc4
#KeyHolderPlugin =
#Providers = Remote,Engine12,Loopback
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#RelaxedAliasChecking = 0
#ConnectionTimeout = 180

#WireCrypt = Enabled (for client) / Required (for server)
WireCrypt = enabled

#WireCompression = false
#DummyPacketInterval = 0
#RemoteServiceName = gds_db
#RemoteServicePort = 3050
#RemoteAuxPort = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#IPv6V6Only = 0
#RemoteBindAddress =
#LockMemSize = 1M
#LockAcquireSpins = 0
#LockHashSlots = 8191
#EventMemSize = 64K

CpuAffinityMask = 255

#GCPolicy = combined
#SecurityDatabase = $(dir_secDb)/security3.fdb
#GuardianOption = 1
#ProcessPriorityLevel = 0
#IpcName = FIREBIRD
#RemotePipeName = interbas
#Redirection = 0

#ServerMode = Super
ServerMode = Super

create or alter procedure DM_SALDO(
    CON_STR varchar(50))
returns (
    CARD_NUM varchar(20),
    KREDIT_LIMIT double precision)
as
begin

for execute statement '
select card_num, kredit_limit as kredit_limit
from some_tbl
'                                                                                    2003 RR
    on external :con_str
    with autonomous transaction
    as user 'SYSDBA' password 'masterkey'
    into :card_num , :kredit_limit
    do
    suspend;
end

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Execute statement error at attach :
335544472 : Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Data source : Firebird::10.0.0.1:work.
At procedure 'DM_SALDO' line: 11, col: 1.

------ Информация о производительности ------
Время подготовки запроса = 0ms
Время выполнения запроса = 2s 90ms
Current memory = 47 895 856
Max memory = 49 198 392
Memory buffers = 2 048
Reads from disk to cache = 0
Writes from cache to disk = 0
Чтений из кэша = 0

D:\>SET SystemRoot
SystemRoot=C:\WINDOWS

C:\Program Files\Firebird\Firebird_3_0>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 127.0.0.1:work
CON> user 'SYSDBA' password 'masterkey';
Database: 127.0.0.1:work, User: SYSDBA
SQL>

d:\bin\IBEScript.exe mn_cd.sql