This is an online tutorial which is based on ASP that gives elaborate description about database maintenance from any web browser online from anywhere in the world. It also gives instruction about DSN (Data Source Name), ODBC, SQL etc.
An this document we will discuss the ability to access SQL Server databases through Visual Basic commands, both in Visual Basic programs and Visual Basic Script. In order to begin a Windows NT 4.0 Server or Windows 2000 Server machine must be installed. SQL Server must then be set up on this machine. Internet Information Server 4.0 (3.0 will work, but the drivers must be installed) must also be configured (5.0 for Windows 2000).

Sessions are a very convenient ASP feature. When someone visits a web page on your site, ASP calls that a "session" and immediately can differentiate that user from all other users at a site. Anything stored in that user's session can be retrieved and manipulated from that page and the next pages they visit, and the data will be tied to that user. 

Session data is generally attached to one user. When a user visits their first page of your site, that page and every page they visit is collectively called a session. Any data attached stored in that session object is private to the pages that user is visiting.

Active Server Pages are a server-side scripting technology primary developed to work under IIS (Internet Information Server) on Windows NT Server (3rd party products exist enabling the use of ASP on other server platforms). ASP enables the server to deliver dynamic, database driven content to the client with minimal effort.

The goal of this article is not to move developers from other wonderful technologies to ASP, but to explain the advantages of Active Server Pages to Web designers, programmers and anyone interested in Web development. ASP is not my first server-side scripting technology. I was developing with Netscape Server-Side JavaScript, Borland IntraBuilder and Oracle Web Application Server before I moved to ASP. Now I'm an ASP developer, and I will try to explain why I think ASP is currently the best choice for general Web developer.

One of the first things you are likely to notice when working with ASP.NET is the new file extension: ASP.NET pages use .aspx, as opposed to the .asp extension used with ASP. Additionally, when an ASP.NET page is requested, IIS hands off the request to the aspnet_wp.exe process; ASP uses asp.dll.

ASP and ASP.NET can both be used on the same Web server. That is, a Web site or Web application within a site can contain both ASP.NET pages and ASP pages. Because both ASP and ASP.NET pages can be accessed from the same Web server, you are not required to port your existing ASP pages over to ASP.NET-compatible pages. However, there are many advantages to porting your application from ASP to ASP.NET. Some of the biggest advantages include:

There are two major components of Active Server Pages along with five built-in software objects that permit creation of data-driven Web pages. These components and objects provide a comprehensive set of properties, methods, and collections that the developer can use to help carry out information processing tasks.

• Object properties are their settings or characteristics. Properties can be read and written to access or change their settings.
• Object methods are their actions. These methods are used to activate the object to perform processing functions.
• Object collections are their data sets. Certain objects encapsulate sets of data that are used within processing operations.