Learnthat.com Free Certification and Computer Online Courses
ThatNetwork.com Internet Media Network Givethat.com free gift ideas Definethat.com - Free technical definitions, define Free Romance Tips, Romantic Tips, Date Ideas Free POD publisher comparison print on demand
Learnthat.com Free A+ Certification, Computer Classes, Certification Courses, Business, Lifestyle, ApplicationsFree business tutorials and definitionsFree certification tutorials and definitionsFree computer and technical tutorials and technical definitionsFree Finance Tutorials and DefinitionsFree House Repair TutorialsFree Lifestyle and Fun Tutorials
  • All Online Courses • New Courses • QuickTips • Word Definitions • Submit a Tutorial • Links •
Search Learnthat.com

÷ Resources
Home
free tech tutorials
Free Tutorials
free tech tutorials
Certifications
free tech tutorials
Definitions
free tech tutorials
Resources/Links
free tech tutorials
Forums
free tech tutorials
Distance Education
free tech tutorials
Highest Rated Tutorials
÷ Popular Tutorials

1. A+ Core Certification Tutorial
2. Microsoft Word
3. Macromedia Dreamweaver MX 2004
4. Baby Shower
5. i-Net+ Certification
6. Network+ Tutorial
7. How to Build a PC
8. Basic Windows Tutorials
9. Windows XP Tutorials
10. Learn How to Play Card Games

More Free Tutorials >>
÷ New Tutorials

1. Quickbooks 2005 Tutorial
2. Administering Windows 2003
3. Microsoft Excel  Foundation
4. Active Server Pages (ASP)
5. Dreamweaver MX 2004
6. How to Consolidate Your Debt
7. Resolving Business Conflicts
8. How Do I Dispute my Credit Report?
9. How Do I Create a Network of People?
10. How to Find a Mentor

More Tutorials >>
Home / Certification / Internet

Active Server Pages (ASP)

 

Creating Server Objects

Much of the power of dynamic content can be found in its ability to interact with a database. From any Internet connection, users can browse, sort, update and delete records using a simple but flexible interface that is, on the developer's side, both secure and easy to code.

You use the Server.CreateObject statement to create the objects necessary for interacting with a database. The following code creates a Connection object to connect to a database:

<HTML>

<BODY>

<%

Dim cnn

Set cnn=Server.CreateObject("ADODB.Connection")

cnn.ConnectionTimeout=60

cnn.Open "DSN=TestDB"

<!-- Interact with the database -->

cnn.Close

Set cnn=Nothing

%>

</BODY>

</HTML>

You can also create a Recordset object:

<HTML>

<BODY>

<%

Dim cnn

Dim rs

Set cnn=Server.CreateObject("ADODB.Connection")

cnn.ConnectionTimeout=60

cnn.Open "DSN=TestDB"

Set rs=Server.CreateObject("ADODB.Recordset")

rs.Open "Select * From tblTest",cnn

cnn.Close

Set cnn=Nothing

%>

</BODY>

</HTML>

 

 

by Summer Doucet

Find more free Internet tutorials from Learnthat.com.

More Information:
Help us by rating this tutorial: [---] [--] [+] [++] [+++]
[---] lowest; [+++] highest

 

 

  


Learn: Free Tutorials - Links to Free Tutorials
Understand: Free Technical Definitions - ExplainThat Whitepapers
Use: Certification Section - Discussion Forum

Visit Our Network Sites:

DefineThat.com Technical Defintions Romancetips.com
Free Gift Ideas - GiveThat Planthat.com Free Unique Business Ideas
PublishOnDemand.net - Learn about Print on Demand (POD) - Self Publishing Seekthat.com - Technical Search Engine
ThatNetwork.com  

About Us : Contact Us : Advertise : Privacy Information

© 1998-2004 Learnthat.com