I typically use ASP to script all my sites, but need to move some code to VB COM but I am uncertain as to the best way to start my VB project.
Here are the items I will need to use.
Call stored procedure (ADODB.COMMAND)
Return recordsets (ADODB.RECORDSET)
Data Connections (ADODB.CONNECTION)
I will also need to reference objects such as Jmail to send emails from the object.
My question is
a) What is the best way to start to build the object
b) How do I make the object perform optimally (multithreading?)
3) If I reference 3rd party objects in my object, do they need to be installed on the box that runs my object after I compile with the reference?
4) How do I return recordsets from COM?
Any other helpful hints would be appreciated. I am basically rewriting ASP code in COM for performance issues.