VB 3 tier Architechture model ....

[vans]

Hi Guys,

In VB how to devide the application into 3 tier architechture.

as per my knowledge I thought as follows if wrong please tell me

1) Client
2) Business logic (Applciation server)
3) Database Server

we are putting the VB application in application server then

My questions are ..

1)how to run the Application from client by clicking the VBP or EXE or any other...?

2) Is it compulsary to load VB software in the client or not ?

PLEASE GIVE ME SOME IDEAS ON THIS HOW CLIENT-SERVER THREE TIER ARCHITECHTURE WILL WORK EXACTLY ????

It would be a great help .

PLEASE HELP ME ON THIS ..............

 

[MikeCox]

1.) the client machine contains the front end VB app that talks to the ActiveX exe or dll via DCOM
2.) the ActiveX exe or dll can reside where the database is, or on a different server, your choice.
3.) the ActiveX exe or dll interprets the database for the client application.

You may find Mocrosoft Transaction Server a useful tool for the job. You can find it on VB Enterprise Edition disk 2 in the \Ntoptpak directory

BTW: You typically deploy middle-tier components on a computer of their own if:

1.) The database server runs an operating system that doesn't support ActiveX

2.) You want to conserve processing power on the database server

The disadvantage is it requires an additional network hop, increasing network traffic.