Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP VS SQL 1

Status
Not open for further replies.

e1k4l3cs

MIS
Nov 11, 2002
56
SG
Can anybody define ASP from SQL to me ??? I am kind of stuck !!! Can ASP work under MicroSoft Access 2002 just like SQL can ??? I am totally CONFUSED !!! Please help me out... A MILLION thanks...
Kelvin
 
Ermmmm...... Then can I say that a user extracts datas from SQL using SQL statments through ASP and ADO while a user adds datas to a database over the internet through ASP and into the SQL database ??? (Is VBA part of this family too ???) @_@

Kelvin
 
Wow. Everyone has put in their two-cents, so I will as well.

1. ASP is not a language. Its a format that tells a MS server, "Hey, there is going to be MS languages in here, so make sure you do what it says." For instructional purposes only, I'll say that in the internet world there is really only two sides. Client side (that's you) and Server side (that's the computer generating the web page AND the database). Your side, or your computer, hears HTML, Javascript, Flash, etc spoken by the server after the server speaks SQL to the database in order to tell your computer the right HTML. So ASP is a bunch of VB code you dont see consumed by the server and the HTML it spits out for you.

2. ASP uses Visual Basic (usually), pretty much like you would in VBA when programming in your Access 2002 forms and actions (I think you mentioned using that before), only since this is a web application it has to follow those rules. So it needs to be in HTML for public broswer consumption.

3. So we use VB to tell the server how to do things. Where SQL comes in (like in Access) is after you use Visual Basic to tell the server to open up a data source (could be Access 2002, SQL Server, whatever DBMS you're using) and the server speaks "database" through the use of SQL scripts, much like an Access interface interacts with the table structure of your database.

4. ASP was established so that web pages could be tailored to the content, and written on the fly. If you and I bank at the same bank and visit it online, we will see the same page format but very different balance information. IF this bank uses ASP, then it basically compared a username and password, used SQL in one way or another to speak to the bank's database and present to you your specific data in HTML.

5. For what its worth, ASP can only be used on an MS sever, so don't try telling an Apache server <% language=&quot;vbscript&quot; %>.

In all reality its super easy once you get going, so good luck, and don't be intimidated when programming.
 
Thank you Shadyness... Ur contribution helps me understand DB programming even better now... Thx again...

Kelvin
 
A figure of speach, it basicly means &quot;Just my opinion&quot;.
 
I apologize for my misrepresentation of ASP as a language (thanks onpnt :) ).
Also as a note, ASP can be run under *nix environments with third party software, the most well known being chilisoft.
And I want to stress the fact that ASP uses VBScript(or javascript) not VB(as was also mentioned by onpnt :p). VBScript is a subset of the VB language.

Sorry to make the post longer,
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...) :p
 
Also if you were to go with ASP.NET vs. ASP the language issue in terms of being limited is out the door. you have roughly over 20 languages that you have at your means in ASP.NET which makes it easier to find the one that you may have knowledge in already. A language that doesn't affect the way you think about programming is not worth knowing.
admin@onpntwebdesigns.com
 
Very true. There is a difference between &quot;Visual Basic&quot;, &quot;Visual Basic Script&quot;, and &quot;Visual Basic for Applications&quot;. The real differences is found in slight syntax adjustments and language rules. Kind of like regional dialects. It is just taking one language and adjusting it to work in a different environment. It is also true that ASP may be run with third party software, but Chilisoft costs $, and though I have seen some freeware replacements, I have been disappointed in them. In my humble opinion, your best bet is to learn PHP, CGI, PERL and keep open source the &quot;free-est&quot; by learning their languages (they all really have great similarities in the end). However, the point about ASP.NET is true and the wide variety of scripting choices.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top