Why ... n-tier development. Typically 3 tiers: presentation, business logic
and backend processing. And the COM component is the middle tier ...
enforcing business rules. ASP/CF acts as the presentation tier with T-SQL as
the third tier.
Why n-tier development ... because of scalability, security, control of
critical resources, maintainability, etc.
The middle-tier COM component can distribute requests across multiple
resources/servers. Also, these middle-tier objects can be MTS-ized [Microsoft
Transaction Server] ... thus providing connection polling and multi-object
transactional processing.
It is awful early ... hope that helps.
Bill
In a message dated 1/26/01 10:13:53 PM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
>
>
>
>
> Can I ask why you would want to use a COM object to access a Stored
> Procedure instead of just calling the procedure directly?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
