Post reply

Can we use any ActiveX Object in SQL Server

  • September 2, 2001 at 11:39 am

    #151623

    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

    #417927

    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

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply