Categories
ASPTips and Tutorials → Database-related

Connections, Commands and Procedures

Connections, Commands and Procedures is a sample chapter from Professional Active Server Pages which discuss in depth all the issues related with establishing connection to a database to the carrying out of commands and procedures.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Accessing Database from ASP

This tutorial shows you step-by-step how to incorporate MS Access databases into your web site using ASP.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Simple Web-Database System Application

This article will show how to connect an Access database to your Active Server Pages using Microsoft FrontPage. This is a beginning-level article with plenty of screen shots to show how to connect via ODBC, generate a SQL query in Access and construc...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

SQL Tutorial

SQL, Structured Query Language, is the most powerful tool to connect to a database regardless of the form of the database. However, building a perfect SQL statement can be very frustrating. Especially debugging -- the error message simply didn''...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Using ASP to create, edit, or delete information in a database.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete S...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Making the Switch from ODBC to OLE DB

ODBC is great and all but for speed and reliability you should switch to OLE DB to power your database driven apps. This tutorial will show you how to do it two ways: in the global.asa and in any ASP page.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

File DSNs - Use and Reuse

Many a time, you are confronted with creating a system DSN for use with ASP. If you have an ISP account, this might take time and more than sometimes - money. This article describes how to use File DSNs and save time and money. Also, you can reuse th...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Querying an Access database in ASP

Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles el...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

How to create DSN for Microsoft SQL Server

This article will help you to create a System Data Source Name (DSN) for Microsoft SQL Server on your local machine. After a System DSN has been created you can use it within any ASP page located on the same computer.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Simple Table Display With Where Clause (Hard Coded)

Displaying specific subsets of data from a database is easy to accomplish in .asp. The following example utilizes an Access database of Mark &"The Bird&" Fidrych and displays all of his season statistics for 1976 contained in the da...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com