This is a tutrial about
SQL, Structured Query
This is a set of ASP
ODBC is great and all but for
connecting an Access
Language, is the most
examples/tutorials that
speed and reliability you
database with ASP pages. It
powerful tool to connect to
demonstrate exactly how to
should switch to OLE DB to
focuses on connecting Access
a database regardless of the
use ASP with a database.
power your database driven
with PWS 4.0 on a Win95
form of the database.
Topics include: Using ADO To
apps. This tutorial will
machine. You can use the
However, building a perfect
Add A New Record, Using ADO
show you how to do it two
same procedure on Win98. It
SQL statement can be very
To Update An Existing
ways: in the global.asa and
also shows you how to create
frustrating. Especially
Record, Using An Update
in any ASP page.
a database table in Access
debugging -- the error
Query To Modify An Existing
and how to retrieve it's
message simply didn't tell
Record, Using Delete
content and display it
you where the error is. This
Statement to Delete Records,
through ASP.
tutorial provides a nice
Using A Select Statement
summary of SQL statements.
(With A Loop), and ACCESS
DATABASES ( DSN vs DSN-LESS).
Date: Feb, 25 2000 Date: Feb, 15 2000 Date: Feb, 14 2000 Date: Feb, 13 2000 |
Many a time, you are
Active Server Pages allow us
This article will help you to
Displaying specific subsets
confronted with creating a
an easy means of querying
create a System Data Source
of data from a database is
system DSN for use with ASP.
and updating a database from
Name (DSN) for Microsoft SQL
easy to accomplish in .asp.
If you have an ISP account,
a webpage. This article
Server on your local
The following example
this might take time and
describes the basics of
machine. After a System DSN
utilizes an Access database
more than sometimes - money.
using this technique in a
has been created you can use
of Mark "The Bird"
This article describes how
nutshell. The examples given
it within any ASP page
Fidrych and displays all of
to use File DSNs and save
here utilize a Microsoft
located on the same computer.
his season statistics for
time and money. Also, you
Access database, but the
1976 contained in the
can reuse these DSNs and
principles elucidated apply
database rather than
thus, with some
equally well to ASP
displaying the entire db.
modifications, use the same
integration with other
DSN for as many database
databaes.
connections.
Date: Jan, 25 2000 Date: Jan, 25 2000 Date: Jan, 21 2000 Date: Jan, 20 2000 |