Subject | Re: [ib-support] Connect to DB from Procedure ?? |
---|---|
Author | Helen Borrie |
Post date | 2001-08-08T08:47:51Z |
At 09:20 AM 08-08-01 +0100, you wrote:
If your app opens a connection to another DB, why can't it pass parameters from your main database to a stored proc on the other database? I really DON'T recommend a UDF to implement this, especially if you are planning to port it cross-platform.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>At 07:44 08/08/2001, you wrote:Why?
> >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.
If your app opens a connection to another DB, why can't it pass parameters from your main database to a stored proc on the other database? I really DON'T recommend a UDF to implement this, especially if you are planning to port it cross-platform.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________