How to call SQL server with ASP views and stored procedure?

[Acalapati]

Active Server Pages is a server-side scripting environment it can be used to create dynamic Web pages or build powerful Web applications. ASP page to include HTML tags, text and script command files. ASP pages can call ActiveX components to perform tasks such as connecting to a database or business computing. Through the ASP, can add interactivity to your Web page content or with the HTML pages constitute the entire Web application, these applications using the HTML page as your client interface. But I want to discuss this topic related to calling of SQL server with ASP views and stored procedure.

[Praetor]

If you want to discuss this topic then you must have this information that is the browser from a Web server requests. Asp file, ASP script starts running. Web server then calls ASP, ASP fully read the requested documents, the implementation of all the script commands, and Web pages sent to the browser. ASP offers an HTML page to use existing scripting languages such as Microsoft VBScript and Microsoft JScript framework.

[Katty]

Yes ASP provides built-in objects, these objects make it easier for users through the browser sends a request to collect information in response to the browser and store user information. Including the Application, Request, Response, Server, Session, and ObjectContext object. One of the most commonly used for the Request, Response, and Server 3 objects, which were used to request information from the browser, send a message to the browser and access the server object's properties and methods.

[Modifier]

Normally ASP and database connectivity using Microsoft's ADO (ActiveX Data Objects), ADO is an easy to use and scalable database access will be added to the Web page technology. You can use ADO to write compact and simple scripts in order to link to the Open Database Connectivity (ODBC) compliant databases and OLE DB-compliant data source. ADO includes seven built-in objects, which were Connection, Command, RecordSet, Fields, Error, Parameters, and Properties. Through these objects, ASP can complete all operations on the back-end database.

[MindSpace]

ASP call to views and stored procedures can be achieved by following these steps. In the general MIS applications, there will be a large number of reports, this time we can write the corresponding back-end database view or stored procedure, using ASP through ADO calls to complete the statements of work.
1. Create ODBC DSN file
2. Call database view
3. Call database stored procedure