ActiveX Component in Linked Server Function...?

Hi Everyone
I have a question regarding a function I have which is licensed on a
particular server and
uses an ActiveX component to pull a list of names and addresses from a
Post Office Address File.
Its expensive to license the component on another server so I was
wondering if its possible to have a linked server
and open the function to return the data to another server?
Any help would be very much appreciated.
Mattie
Chester Zoo> Its expensive to license the component on another server so I was
> wondering if its possible to have a linked server
> and open the function to return the data to another server?
I haven't actually done this via a linked server but you ought to be able to
encapsulate the ActiveX requests in a stored procedure using the sp_OA*
procs. However, be sure to thoroughly review the vendor licensing agreement
to make sure this use is allowed. Many EULAs have provisions that prohibit
multiplexing.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"MattieG" <mattiegriffin@.hotmail.co.uk> wrote in message
news:1192366692.494333.154910@.i38g2000prf.googlegroups.com...
> Hi Everyone
> I have a question regarding a function I have which is licensed on a
> particular server and
> uses an ActiveX component to pull a list of names and addresses from a
> Post Office Address File.
> Its expensive to license the component on another server so I was
> wondering if its possible to have a linked server
> and open the function to return the data to another server?
> Any help would be very much appreciated.
> Mattie
> Chester Zoo
>|||On 14 Oct, 16:40, "Dan Guzman" <guzma...@.nospam-online.sbcglobal.net>
wrote:
> > Its expensive to license the component on another server so I was
> > wondering if its possible to have a linked server
> > and open the function to return the data to another server?
> I haven't actually done this via a linked server but you ought to be able to
> encapsulate the ActiveX requests in a stored procedure using the sp_OA*
> procs. However, be sure to thoroughly review the vendor licensing agreement
> to make sure this use is allowed. Many EULAs have provisions that prohibit
> multiplexing.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "MattieG" <mattiegrif...@.hotmail.co.uk> wrote in message
> news:1192366692.494333.154910@.i38g2000prf.googlegroups.com...
>
> > Hi Everyone
> > I have a question regarding a function I have which is licensed on a
> > particular server and
> > uses an ActiveX component to pull a list of names and addresses from a
> > Post Office Address File.
> > Its expensive to license the component on another server so I was
> > wondering if its possible to have a linked server
> > and open the function to return the data to another server?
> > Any help would be very much appreciated.
> > Mattie
> > Chester Zoo- Hide quoted text -
> - Show quoted text -
Hi
Thanks for that.
The only other way is to install IIS on the SQL box and transfer the
system to that.
It should be ok as the IIS is not going external so security isnt much
of a problem.
Thanks
Mattie