First Enterprise Development Project
We are proposing to design and build a distributed 3-tier architecture
application for a client. We're fairly VB & SQL savvy but just wanted to
briefly detail our requirements and "plan of attack" to see if anyone can
offer any general tips, suggestions and/or things to lookout for, being
that this is our first foray into the world of true enterprise
development. This could sure help soothe our management's concerns
before starting the project. Thanks in advance.
100 users (15 w/ read-write access, 85 read-only), 25-50 Max. concurrent
Design IDE: VB 6 w/ SP5, Professional Edition
GUI: VB "thin-client", w/ 3rd party grid control
Business logic: VB DCOM component (ActiveX EXE) located on database server
Database: SQL Server 2000
Data access: ADO 2.5, (possibly via SQL stored procedures)
Email functionality: Exchange Server
Security: Code-based program access controlled through user-defined login
table entries.
Database Server: Windows 2000 Server (Dedicated)
Local Clients: Pentium III, 512MB, 20GB HD, w/ NT 4.0
Network: Ethernet LAN, 10Mbit
# 1 Re: First Enterprise Development Project
> Business logic: VB DCOM component (ActiveX EXE) located on database server
Why are you chosing DCOM over MTS or COM+?
Guy
# 2 Re: First Enterprise Development Project
back in my VB days - 2 1/2 years ago - I designed an architecture like this
using MTS as the middle-tier. Using MTS will likely change your secuirity
model
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
--------------------
"Mark Sanchez" <msanchez@specservices.com> wrote in message
news:3d618c27$1@10.1.10.29...
>
> We are proposing to design and build a distributed 3-tier architecture
> application for a client. We're fairly VB & SQL savvy but just wanted to
>
> briefly detail our requirements and "plan of attack" to see if anyone can
>
> offer any general tips, suggestions and/or things to lookout for, being
> that this is our first foray into the world of true enterprise
> development. This could sure help soothe our management's concerns
> before starting the project. Thanks in advance.
>
> 100 users (15 w/ read-write access, 85 read-only), 25-50 Max. concurrent
> Design IDE: VB 6 w/ SP5, Professional Edition
> GUI: VB "thin-client", w/ 3rd party grid control
> Business logic: VB DCOM component (ActiveX EXE) located on database
server
> Database: SQL Server 2000
> Data access: ADO 2.5, (possibly via SQL stored procedures)
> Email functionality: Exchange Server
> Security: Code-based program access controlled through user-defined
login
> table entries.
> Database Server: Windows 2000 Server (Dedicated)
> Local Clients: Pentium III, 512MB, 20GB HD, w/ NT 4.0
> Network: Ethernet LAN, 10Mbit
>
# 3 Re: First Enterprise Development Project
First of all, thanks for your input!
To answer your question, I was thinking that based on the size of our
proposed project, MTS was somewhat overkill. Am I naiive in this idea?
So then, why would you use MTS or COM+ over DCOM (assuming this was your
project)?
"Guy Smith" <no@email.com> wrote:
>
>> Business logic: VB DCOM component (ActiveX EXE) located on database server
>
>Why are you chosing DCOM over MTS or COM+?
>
>Guy
# 4 Re: First Enterprise Development Project
my answer w/b if it is not biggest enough for MTS, it is not big enough for
3 tier.
"Mark Sanchez" <msanchez@specservices.com> wrote in message
news:3d62567a$1@10.1.10.29...
>
> First of all, thanks for your input!
> To answer your question, I was thinking that based on the size of our
> proposed project, MTS was somewhat overkill. Am I naiive in this idea?
> So then, why would you use MTS or COM+ over DCOM (assuming this was your
>
> project)?
>
>
> "Guy Smith" <no@email.com> wrote:
> >
> >> Business logic: VB DCOM component (ActiveX EXE) located on database
server
> >
> >Why are you chosing DCOM over MTS or COM+?
> >
> >Guy
>
# 5 Re: First Enterprise Development Project
And - Why have you chosen your tools before designing? Oh well.
"Guy Smith" <no@email.com> wrote:
>
>> Business logic: VB DCOM component (ActiveX EXE) located on database server
>
>Why are you chosing DCOM over MTS or COM+?
>
>Guy
MarkN at 2007-11-11 23:57:25 >
