Subject Re: [ib-support] Connect to DB from Procedure ??
Author Helen Borrie
At 03:43 PM 07-08-01 +0100, Damian Dowling wrote:
>Is it possible to connect to Database B from a Procedure in Database A, e.g.
>from within a procedure:
> CONNECT 'c:\Program Files\Firebird\isc4.gdb' USER 'SYSDBA'
>PASSWORD 'masterkey';

No, a stored procedure can only perform data manipulation; and it can't be a "client" to the server since it runs inside the server, not through the client library.

Is there a reason why you can't have your application make a connection to the other database through the client, as usual?


All for Open and Open for All
InterBase Developer Initiative ยท