Subject Re: [ib-support] Connect to DB from Procedure ??
Author Paul Reeves
Damian Dowling wrote:
> At 07:44 08/08/2001, you wrote:
> >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
> I need to be able to log updates to another DB and was hoping to do it in
> Stored Procedures - it would make the solution more portable to other
> server platforms. Looks like i am stuck with UDFs.

I wasn't actually being serious when I suggested using a UDF.

Using a UDF is not the way to handle logging. The connection (and txn)
for a UDF is outside the transaction control of the main application.
Have you thought about how you will handle rollbacks? And what about
the performance drag of instantiating a connection every time?

If you need this sort of logging I would suggest that you investigate Alternatively, for a 'fuller' solution,
IBReplicator from http:// would work -
although it is designed as an industrial strength replication solution,
so might be more than you need.


Paul Reeves
taking InterBase further