• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Creating Dynamic Web Pages > Exporting Tables, Queries, and Forms t...

Exporting Tables, Queries, and Forms to Active Server Pages

Active Server Pages (ASPs) play the primary role in Microsoft's strategy to gain for IE and IIS the predominate position in the Internet browser and server markets. ASP uses server-side scripting, OLE DB, and ActiveX Data Objects (ADOs) to generate HTML files from desktop and client/server databases. ADO is an Automation wrapper (interface) for Microsoft's new OLE DB API, which first appeared in late 1996. OLE DB's objective is to provide a simpler mechanism than SQL-oriented ODBC for accessing data stored in any type of row/column format. ADO defines an Automation object, similar in concept to Access's ODBCDirect and Visual Basic's Remote Data Object (RDO). ADO supplies a Recordset object created from a table or query that you can manipulate with Visual Basic Script (VBScript) contained in .asp files stored on the Internet server. VBScript is a simplified subset of VBA 5.0. Jet and ODBCDirect Recordset, and RDO's rdoResultset objects require the full version of VBA 5.0.

▸▸ See "Using ODBCDirect and the Remote Data Object,"


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint