O'Reilly logo

Active Server Pages 3.0 from Scratch by Nicholas Chase

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Connection to the Database

Arguably the most important built-in components of Active Server Pages are the ActiveX Data Objects. These are COM objects that use ODBC and/or OLEDB to access databases and other stores of information, so they are language independent. They can be used not only from Active Server Pages but also from Visual Basic, Visual C++, and other programming environments. ADOs enable you to connect to a database to

  • Insert: add new data to a table.

  • Update: change data that's already in a table.

  • Delete: remove data in a table.

  • Select: look at data in a table.

  • Execute Stored Procedures: many more advanced databases enable you to write code and store it directly in the database, where it's available to any connected program. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required