MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER, Руководство пользователя

Страница: 135 / 160

Connecting to Microsoft Access Databases 123
Connecting to Microsoft Access Databases
ColdFusion lets you access Microsoft Access databases on Windows NT, using ODBC
and OLE DB drivers. Microsoft Access is a desktop database, and is not intended or
designed for high-volume, multiuser use.
For more information about using Microsoft Access in your application, see the
Knowledge Base article #564, “Using Microsoft Access Databases in a Production
Environment.”For information on securing Access and other file-based databases,
such as dBASE, FoxPro, and Paradox, see Knowledge Base article #10953, “Security
Best Practice: Securing File-based Databases.”
Configuring Microsoft Access Options (Windows)
If you install ColdFusion Server on a Windows NT server, you can configure a
Microsoft Access database as a ColdFusion data source using an ODBC or an OLE DB
driver. For information about using OLE DB drivers with ColdFusion data sources,
see Advanced ColdFusion Server Administration.
Note
OLE DB and ODBC connections to Access function identically at the programmatic
level, but OLE DB connections under load are substantially more robust than ODBC.
Wherever possible, you should use OLE DB instead of ODBC to connect to Access
data sources. For details on how to configure an OLE DB data source, see Advanced
ColdFusion Server Administration.
ODBC: Microsoft Access options (Windows)
The following table describes ColdFusion ODBC options for Microsoft Access data
sources. You set these options when you configure a ColdFusion data source.
Option Description
Data Source Name A name for your data source.
Description Descriptive information about the data source.
Database File Click Browse to select a database file for a file-based ODBC
data source.
System Database Click Browse to select a shared database. The default user is
Admin and the default password is an empty string. A system
database can be used to secure Microsoft Access database
files.
install.book Page 123 Thursday, May 10, 2001 12:59 PM