|
 |
asp_components thread: Call COM out of a SQL Stored Proc
Message #1 by "Stephen Biggerstaff" <stephenb@w...> on Tue, 10 Oct 2000 16:41:59 +0100
|
|
I'm looking for a way to call a COM Component out of a SQL Stored Procedure.
I can't find any documentation on that nor people that knows if it's doable.
If you come by someone that could help, it will be greatly appreciated.
Thanks,
Maxime
-----Original Message-----
From: Maxime Bombardier [mailto:maximebombardier@h...]
Message #2 by Andrew Lowcock <Andrew.Lowcock@4...> on Tue, 10 Oct 2000 16:56:55 +0100
|
|
Maxime,
use the extended stored procdeure sp_OACreate to instantiate a COM object in
a stored procudure
could use it to
- send an email
- write a text file
- create an MS Word document
the list is endless - joy
HTH
Andrew
-----Original Message-----
From: Stephen Biggerstaff [mailto:stephenb@w...]
Sent: Tuesday, October 10, 2000 4:42 PM
To: ASP components
Subject: [asp_components] Call COM out of a SQL Stored Proc
I'm looking for a way to call a COM Component out of a SQL Stored Procedure.
I can't find any documentation on that nor people that knows if it's doable.
If you come by someone that could help, it will be greatly appreciated.
Thanks,
Maxime
-----Original Message-----
From: Maxime Bombardier [mailto:maximebombardier@h...]
Message #3 by kgrant@p... on Tue, 10 Oct 2000 12:04:00 -0400 (EDT)
|
|
Maxime,
User "sp_OACreate". You will find info about it at msdn.microsoft.com. Hope this helps.
ComputerSage
======================================================
I'm looking for a way to call a COM Component out of a SQL Stored Procedure.
I can't find any documentation on that nor people that knows if it's doable.
If you come by someone that could help, it will be greatly appreciated.
Thanks,
Maxime
-----Original Message-----
From: Maxime Bombardier [mailto:maximebombardier@h...]
Message #4 by Toby Anscombe <tanscombe@m...> on Wed, 11 Oct 2000 08:09:50 +0100
|
|
But there are issues with VB COM, C++ works fine...
Can't recall the work around but it's in Ted Pattersons book - Hitchhikers
guide to SQL Server and VB
Regards
T
-----Original Message-----
From: kgrant@p... [mailto:kgrant@p...]
Sent: 10 October 2000 17:04
To: ASP components
Subject: [asp_components] RE: Call COM out of a SQL Stored Proc
Maxime,
User "sp_OACreate". You will find info about it at msdn.microsoft.com.
Hope this helps.
ComputerSage
======================================================
I'm looking for a way to call a COM Component out of a SQL Stored Procedure.
I can't find any documentation on that nor people that knows if it's doable.
If you come by someone that could help, it will be greatly appreciated.
Thanks,
Maxime
-----Original Message-----
From: Maxime Bombardier [mailto:maximebombardier@h...]
|
|
|
View Cart
