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

Active Directory Queries

Hi,
I'm interested in querying my domain's Active Directory database from SQL
Server 2000. In particular, I would like to be able to take a network user
name and determine its membership in network groups so I can list all the
network logins that user has to a SQL server instance. I would like to do
this from T-SQL, if possible.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgDaniel,
there's not a huge amount of details about ADSI queries, but these links
should help you set it up:
http://msdn.microsoft.com/library/d...
uted_query.asp
http://msdn.microsoft.com/library/d...r />
_94fn.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Paul,
Cool, that looks like a good start. Now I just need to learn those LDAP
queries.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uIGwD$6xGHA.2396@.TK2MSFTNGP03.phx.gbl...
> Daniel,
> there's not a huge amount of details about ADSI queries, but these links
> should help you set it up:
> http://msdn.microsoft.com/library/d...buted_query.asp
> http://msdn.microsoft.com/library/d.../>
12_94fn.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

Active Directory Queries

Hi,
I'm interested in querying my domain's Active Directory database from SQL
Server 2000. In particular, I would like to be able to take a network user
name and determine its membership in network groups so I can list all the
network logins that user has to a SQL server instance. I would like to do
this from T-SQL, if possible.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgDaniel,
there's not a huge amount of details about ADSI queries, but these links
should help you set it up:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Paul,
Cool, that looks like a good start. Now I just need to learn those LDAP
queries.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:uIGwD$6xGHA.2396@.TK2MSFTNGP03.phx.gbl...
> Daniel,
> there's not a huge amount of details about ADSI queries, but these links
> should help you set it up:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/distributed_query.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>

AcquireConnection Error - Lookup Component

Hi,

Trying to get a particular SSIS is package working - while running the Package Installation wizard a package is reported with the following errors:

AcquireConnection method fails with error code 0xC0202009 Then Lookup fails validation and returns code 0xC020801C

The odd thing is the Lookup does not exist in the package, it did exist at one point but was deleted.

I have tried searching the XML and can't find any reference to the Lookup

Any suggestions appreciated...

Thanks,

John

Could you check if you are not somehow referencing the old package?|||

Any ideas how?

The steps I've tried are:

Delete all the packages in the server file system store

Check the local package for the Lookup (not found)

Rebuild the solution.

Double click the manifest to deploy on the server to a file store with the validate option turned on.

Validation warning above occurs.

If I open the package in notepad and search for the name of the lookup I don't find anything

|||

You may want to try a brute force here and search for all files with extension .dtsx on your machine. You could find some you do not know about (VS sometimes makes copies). If you do, see if any of them is the troublemaker.

HTH.