Chapter 1
Advanced Data Source
Management
This chapter describes how to create and configure ColdFusion data sources for
several databases using ODBC, OLE DB, and native drivers. It also describes how to
use ColdFusion to create a database file in a
cfquery
and how to use connection
string options.
For basic information on data sources and for information on how to connect to SQL
Server, Access, and Oracle databases, see Installing and Configuring ColdFusion
Server.
Contents
•
About ColdFusion database drivers........................................................................... 4
•
Using ColdFusion to Create a Data Source (UNIX only)........................................ 10
•
Using Connection String Options ............................................................................ 12
•
Connecting to DB2 Databases ................................................................................. 15
•
Connecting to dBASE/FoxPro Databases................................................................ 21
•
Connecting to Excel Databases ................................................................................ 24
•
Connecting to Informix Databases .......................................................................... 26
•
Connecting to Sybase Databases ............................................................................. 32
•
Connecting to Text Databases.................................................................................. 35
•
Connecting to Visual FoxPro Databases.................................................................. 37
Summary of Contents for COLDFUSION 5-ADVANCED ADMINISTRATION
Page 1: ...Macromedia Incorporated Advanced ColdFusion Administration ColdFusion 5...
Page 20: ......
Page 56: ...38 Chapter 1 Advanced Data Source Management...
Page 74: ...56 Chapter 2 Administrator Tools...
Page 76: ......
Page 86: ...68 Chapter 3 ColdFusion Security...
Page 87: ...To Learn More About Security 69...
Page 88: ...70 Chapter 3 ColdFusion Security...
Page 130: ...112 Chapter 5 Configuring Advanced Security...
Page 132: ......
Page 154: ...136 Chapter 6 Configuring Verity K2 Server...
Page 162: ...144 Chapter 7 Indexing XML Documents...
Page 202: ...184 Chapter 8 Verity Spider...
Page 236: ...218 Chapter 10 Verity Troubleshooting Utilities...
Page 238: ......
Page 348: ...330 Chapter 14 ClusterCATS Utilities...
Page 349: ...Using sniff 331...
Page 350: ...332 Chapter 14 ClusterCATS Utilities...
Page 362: ...344 Chapter 15 Optimizing ClusterCATS...
Page 372: ...354 Index...