--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 07:39 AM 31/05/2005 +0000, you wrote:
> >hi. im trying to find a solutions for connecting two database.
> >
> >Im trying to get/post data from DB1 to DB2 by using procedures but im
> >not sure how to do it in firebird. In oracle i can use DBLink but for
> >firebird ??
>
> Firebird does not support "database namespaces" -- so it is not

possible to

> single-statement requests that read from one database and write to
> another; or that refer in any way to objects in multiple databases.
>
> What you can do is read from and write to multiple databases from

within a

> single transaction in your client application. For example, you can

query

> one database, passing the output to a client structure; read that

output

> and pass a write request, using that data, to the other database;

and do

> the same thing in the opposite direction. The data writes are

posted to

> both databases.
>
> Then, if COMMIT is called on that transactions, both databases are
> permanently updated. If ROLLBACK is called, neither database is

updated.

>
> Some of the datapump utilities work with cross-database transactions

like this.

>
> ./heLen

thanks for all the help and information...i think of getting ASP to do
this get/post into 2diff database. the reason im asking for another
options is because i think by using a client application it will be
slower compare to using procedure to do so(in oracle it is faster) :)
thanks again...