Vista - Extended stored procedures and WSC

09-03-2008

Hi

I have seen an example of how to wrap a com object up using TSQL and
extended stored procedures.

I have seen how to use WSC files both after they are registered and by
referencingthe file.

What I would like to know is, can you use SQL to consume a WSC file and
whether you can use it without registering it?

Basically I want to write com objects using script and use them via
tsql..has anyone ever done anything liek that/

09-04-2008

"Robert" <Robert@xxxxxx> wrote in message
news:7EF4D634-D8B2-4D87-B44E-F9BBCEB9BD54@xxxxxx

Quote:

> Hi
>
> I have seen an example of how to wrap a com object up using TSQL and
> extended stored procedures.
>
> I have seen how to use WSC files both after they are registered and by
> referencingthe file.
>
> What I would like to know is, can you use SQL to consume a WSC file and
> whether you can use it without registering it?
>
> Basically I want to write com objects using script and use them via
> tsql..has anyone ever done anything liek that/

Here is a question:- What does VBScript (the language not any COM
components that are typically used in VBScript) do that you can't do in
T-SQL?

--
Anthony Jones - MVP ASP/ASP.NET

09-03-2008	#1 (permalink)
Robert n/a posts	Extended stored procedures and WSC Hi I have seen an example of how to wrap a com object up using TSQL and extended stored procedures. I have seen how to use WSC files both after they are registered and by referencingthe file. What I would like to know is, can you use SQL to consume a WSC file and whether you can use it without registering it? Basically I want to write com objects using script and use them via tsql..has anyone ever done anything liek that/
My System Specs

09-04-2008	#2 (permalink)
Anthony Jones n/a posts	Re: Extended stored procedures and WSC "Robert" <Robert@xxxxxx> wrote in message news:7EF4D634-D8B2-4D87-B44E-F9BBCEB9BD54@xxxxxx Quote: > Hi > > I have seen an example of how to wrap a com object up using TSQL and > extended stored procedures. > > I have seen how to use WSC files both after they are registered and by > referencingthe file. > > What I would like to know is, can you use SQL to consume a WSC file and > whether you can use it without registering it? > > Basically I want to write com objects using script and use them via > tsql..has anyone ever done anything liek that/ Here is a question:- What does VBScript (the language not any COM components that are typically used in VBScript) do that you can't do in T-SQL? -- Anthony Jones - MVP ASP/ASP.NET
My System Specs

Similar Threads
Thread	Forum
Execute Scalar Stored Procedures in Entity Framework	.NET General
calling Oracle Stored Procedures from powershell	PowerShell
functions or procedures	PowerShell
Starting procedures	Vista General
New install of VISTA procedures...	Vista installation & setup