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. You can only use DML statements (select, insert, update, delete) in
stored procedures.

Of course, if you like living dangerously you could write a UDF to do
the job, but I wouldn't recommend it in a multi-user database.

What is it you are trying to achieve?

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further