473,237 Members | 1,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,237 software developers and data experts.

IIS ASP is front end or back end?

I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is
for server side programming and dynamic content generation, how could it is
called front end? Because I thought it is executed in the server, which is
back end? I think I am confused with the term front end and back end here.

Please advise. Thanks!!
Jul 19 '05 #1
3 5193
"Matt" wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl...
: I always heard people saying IIS ASP front end, and MS-SQL back end. ASP
is
: for server side programming and dynamic content generation, how could it
is
: called front end? Because I thought it is executed in the server, which is
: back end? I think I am confused with the term front end and back end here.

Hi Matt...

In the scenario you described, back-end refers to dynamic data-driven web
sites. You can have ASP files without using a database. Using a database
on the back end will give more of a dynamic site with less duplication.
Your ASP files will work as templates and the data will be provided by the
ASP processor making ADO connections to the database to provide content.

When comparing client/server side scripting, front/back end is not relevant
because static HTML pages do not have a back end. ASP code is processed by
the ASP processor, dynamic content can be retrieved by using dynamic content
from files or databases and the result will be served to the client
[browser] to render along with any client-side scripting, if included. Once
the browser gets the content, the ASP and database processing has been
completed until another trip to the server to get more.

HTH...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Jul 19 '05 #2
Matt wrote:
I always heard people saying IIS ASP front end, and MS-SQL back end.
ASP is for server side programming and dynamic content generation,
how could it is called front end? Because I thought it is executed in
the server, which is back end? I think I am confused with the term
front end and back end here.

Please advise. Thanks!!


Front-end/back-end used to apply to 2-tiered client-server database
applications: the database is the backend, and the application code is the
front-end.

With a database application using asp, you actually have 3 or more tiers:
the client-side gui, the webserver asp code, and the database.

It is still common to refer to the database as the back end, despite the
fact that only one of the 3 tiers is being described. I guess the
client-side code could be called the front-end, the server-side asp code the
middle, and the database the back end. But this analogy breaks down when
other components are involved in the middle. So some people take the easy
way and call all the code that delivers the content to the user the "front
end". It's not exactly accurate, but, it does serve the purpose of providing
a short-hand way of referring to all those tiers.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #3
Hi Matt,

I think it just depends on how you look at it. I agree that because ASP is
server-side it should therefore technically be considered a "back-end" tier.
However when compared, for example, to a VB6 application the part that
creates the forms and presents the data to the user (creates the UI) is
considered the "client". For this reason most people think of the ASP tier
as being the client or "front-end" because it is responsible for generating
the part the user interacts with. While you could perform intense business
logic in ASP/VBScript code you probably shouldn't. ASP should be used for
taking the data and presenting it to the user in a nice way. You would then
also use it to take input from the user, roll it up and send it to your
middle-tier COM object or to your database. Technically the only part of
the process that is truly "front-end" code is any JavaScript that you may
have on the page. This actually runs inside the users browser and therefore
on the client machine.

I do all my business logic in COM or, better yet, in stored procedures on
the data-tier. I like to use the principal of moving my processing to my
data rather then my data to my processing. This is the reason I do as much
as I can in the data tier. I also find this scales well.

For example the order-entry system used by our sales staff for taking orders
over the telephone is web-based. When adding items to the order I use a
stored procedure like this

OEAddOrderDetail @OrderID, @ItemNumber, @Qty

These are the only three pieces of information the server needs from the UI.
It does not need the price. In our scenario prices cannot be overridden so
they are figured out on the server side by the Qty ordered. The same stored
procedure does a SUM to recalculate the subtotal. It then estimates Freight
and calculates the tax. This is all done server-side in the data-tier. The
data I need to figure these things out is all in my database. Why pass it
up through 10 layers of software (OLDB, ODBC, ADO) just to add it up and
send it back down?

Cheers,

Ken.

"Matt" <ma*******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is for server side programming and dynamic content generation, how could it is called front end? Because I thought it is executed in the server, which is
back end? I think I am confused with the term front end and back end here.

Please advise. Thanks!!

Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: John Baker | last post by:
Hi: I have an application that has a back end and a front end. I need to add a table which is identical to one in the back end, and then use it for a temporary holing place form some records. I...
4
by: Tempy | last post by:
I am not a programmer, but love to dabble with VBA, mainly in Excel, but I have made an Access data base which is getting a bit outa hand for me!! I am using it to display information only; as a...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
3
by: lorirobn | last post by:
Hello, I am in the process of bringing my Access application to client's server, and need some help! The background is: I created application (mdb) using Access 2003 on my laptop, converted it to...
1
by: Julia | last post by:
Hello there. I have a question somewhat related to this topic, and I don't know where else to go. I hope somebody can help. I've created a database in access, that I'd like to share with less...
35
by: robert d via AccessMonster.com | last post by:
I was asked to provide a proposal. I provided a proposal on my application and the prospective client likes what I have but is wary of it having been developed in Access. I don't understand this...
5
by: The alMIGHTY N | last post by:
Hi all, Let's say I have a simple math formula: sum (x * y / 1000) / (sum z / 1000) I have to do this across 50 items, each with an x, y and z value, when the page first loads AND when a...
11
by: Max Vit | last post by:
I have deployed few Access apps splitting it in Front End and Back End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers and Access 2003. The max. number of clients is about 50...
14
by: Brian Nelson | last post by:
Sorry for the long post, I've tried so hard to solve this one but I'm just stuck! We've had a multiuser .mdb file on a network share for years. I know it's not ideal, but it's worked well from...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.