Sams Teach Yourself SQL in 10 Minutes

Using Microsoft ASP

Microsoft ASP is a scripting language for creating Web-based applications. To test your SQL statements within an ASP page, you must create a page that you can execute by calling it from your Web browser. Here are the steps need to execute a SQL statement within an ASP page:

1. ASP uses OBDC to interact with databases, so an ODBC Data Source must be present before proceeding (see the earlier instructions).

2. Create a new ASP page (with an ASP extension) using any text editor.

3. Use Server.CreateObject to create an instance of the ADODB.Connection object.

4. Use the Open method to open the desired ODBC Data Source.

5. Pass your SQL statement to a call to the Execute method. The Execute method returns a result set. Use a Set command to save ...