Categories
ASPTips and Tutorials → Database-related

Compact && Repair Access Database

Compact and repair your access database online from ASP code. This is example code of how this can be done.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Using MyODBC To Access Your MySQL Database Via ASP

MySQL is the most popular open source database system available today, and is currently installed on over two million servers worldwide. This article takes a look at using the free MyODBC driver to talk to a MySQL database from an ASP script.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Two Ways To Connect To SQL Server 2000 Via ASP

This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN''s and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Analyzing Duplicate Records

This is the first of the four-part &"Advanced SQL Techniques&" series, which describes a quick and efficient way to delete duplicate records from a table.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Using Triggers to Track Database Action History

This article describes how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular database table in a customized history table.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Randomizing a Recordset

This article describes several ways to use a SQL calculated field and the ORDER BY clause to arrange a recordset in random order. It provides a simple tool for verifying that the results are uniformly random. Also shows a technique for bubbling recor...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Using Multiple Recordsets

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store m...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

ASP Access Database Tutorials

This is a group of 3 tutorials that guide you through the process of using an MS Access Database in ASP. The tutorials teach you how to connect to a database, add data to the database, update the database, and delete from the database. The 3 tutorial...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Fastest way of Database Access : Caching Records in Memory

A step by step tutorial on caching data in memory. This tutorial goes one step further from simply caching data in memory to allow you to set a time limit in seconds after which it refreshes the data in memory. Extremely useful technique. Online demo...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Using Disconnected Recordsets

This article covers rarely discussed feature of ADO Recordsets, disconnected Recordsets. It examines what disconnected Recordsets are, how to use them, and what advantages they offer over connected Recordsets. Also examines how to create custom, disc...
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com