Hi,

> Helen - you answered previously to this stating that connection is a
> "client thang" (I didn't know you were from the texan part of oz ;-))
>
> but ... if I was to do the following (pseudocode only):
>
> within SP:
>
> call my_connect_UDF ...
> if UDF = 0 THEN
> SUCCESS;
> else
> raise EXCEPTION;
>
> within udflib.c:
>
> my_connect_UDF ()
> {
>
> if (system("connect_to_other_db") != 0)
> return failed_connection;
> else
> return success;
> }
>
> I will be attempting the above on Monday (too late now) ... do you
> envisage any problems ?

YES!! It's a very "not so nice" thing to do!

It's blocking, it's not thread safe, it's a whole lot of other things and
"plain ugly" is one of them.



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."