At 03:43 PM 07-08-01 +0100, Damian Dowling wrote:

>Hi
>
>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?

regards,
Helen



All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________