I have managed to get one done myself, I havent used any of the ASP objects (Only referneced ADODB) because the component may be used in over Apps later. The perfomance is roughly just under twice as fast as my existing ASP/VbScript methods so it looks as though I will be doing more COM components in the future!!
Dan -----Original Message----- From: Michael Elfial [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 17:26 To: ActiveServerPages Subject: RE: First COM/DLL I can't still catch the need of COM component (BTW I am mostly COM programmer so do not think I am trying to tell you to stop this - I am just estimating the efforts - nothing more). Well if you have VB you can do it with it. No need to create specific ASP component if the purpose is generation of different formats. Note that ASP specific COM object means object that is informed for the ASP objects when created - e.g. Request, Response etc. As long as you do not deadly need them - better avoid creating such a component - it will not be useful in other environments and who know you may need it outside ASP - for example DB maintenance script or something else. Thus everything you need is creating an ActiveX DLL project and go on. If you want to try WSC you will see it is enough for your purpose and probably more suitable. See this URL if you do not have the WSC wizard: http://www.microsoft.com/scripting With WSC you will be able to write in VBScript a COMponent - more closer to ASP and easy to change the code. You write it in VBScript, specify what functions/subs to be exported and this is packed in a XML file loaded by the WSC engine. If you expect frequent changes in the code I recommenf you this way. VB will involve you in side tasks - not too much but add the fact you need to recompile it every time some change occurs, stop and restart IIS because the DLL file is locked and you will begin to think for something else. Of course if you are using ASP code that implements heavy calculations this will make sense - performance will be imporeved. If you never wrote COMponents in C++ better do not this for such kind of reason - C++ is good for reusable components but for handy work it costs too much efforts and you can't avoid some low level knowledge. In case of VB and WSC there is no need of any COM knowledge beyond the general concepts. The way WSC works is very similar to the VBScript classes but you can think for the entire script as for one Class. This abstract conception will be true enough to help you to plan the component. Michael -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 6:55 PM To: ActiveServerPages Subject: RE: First COM/DLL I am putting alot of our business logic into the COM object, we have various methods of outputing the data, a quick arrayset, a XML results set and a HTML results set. I can put all of these into one COM object making it easier for us to maintain. Dan -----Original Message----- From: Michael Elfial [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 16:43 To: ActiveServerPages Subject: RE: First COM/DLL Do you realy need this? If the DB will do the most of the work creating a COM DLL will not worth the effort I think. Why not a WSC - windows script component? -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 3:41 PM To: ActiveServerPages Subject: First COM/DLL Hi all, I am going to have a go at creating my first COM object for use within ASP. What I have is a Stored Procedure on SQL2K that I want to call from my COM object and then return the results to the calling ASP page. Anyone have any links to some basic tutorials? Thanks, Dan _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
