September 2, 2001 at 11:39 am
Can we use any kind of activex object in SQL server stored procs. I have used CDONTS component to send mails from SQL Server.
I know there is xp_sendmail in sql server to send mails. But what if I create my own activex control. Can I use it. And how?
Paras Shah
Evision Technologies
Mumbai, India
Paras Shah
Evision Technologies
Mumbai, India
September 2, 2001 at 4:32 pm
Yes,pretty much, as long as you're using it without a UI (although come to think of it I dont know what would happen if your dll DID have a UI - probably bad things). I've used this technique once so far, works pretty good. Take a look at sp_oacreate in BOL - there is a sample script that is very helpful as a starting point. My advice is to start simple, get the object to instantiate and set to nothing, then add from there.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy