Few
637
IN THIS CHAPTER
Examining the structured world
of databases
Dreamweaver Technique: Setting
up a Dynamic Site
Making a basic connection
Dreamweaver Technique:
Declaring an ODBC Data Source
Dreamweaver Technique:
Creating an ASP Connection
Dreamweaver Technique:
Defining a ColdFusion
Connection
Dreamweaver Technique: Setting
up a PHP Connection
Crafting custom connection
strings
Pinpointing data with recordsets
Dreamweaver Technique:
Defining a Recordset
Writing SQL queries
Establishing Connections
and Recordsets
methods, however, store information in a way that facilitates structured and uniform retrieval. The precise
nature of the structure varies from one type of database to another, but fundamentally, they are all the same.
The term data source is a more generic name for a database. In this book, the two terms are
used interchangeably.
The two different types of data sources are system-based and file-based. File-based data sources store their
data in physical files; Access, Excel, and dBase are all examples of file-based data sources. A system-based
data source works with data stored in its own dedicated server where the database system resides. MS SQL
Server, Oracle, PostgreSQL, and MySQL are system-based. Both types of data sources are structured in fundamentally
the same way.
Pages:
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136