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

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

Connecting to Microsoft SQL Server Databases 121
Connecting to Microsoft SQL Server Databases
ColdFusion lets you access SQL Server databases from Windows NT and UNIX, using
ODBC and OLE DB drivers.
Configuring Microsoft SQL Server Options (Windows)
If you install the ColdFusion Server on a Windows NT server, you can configure
Microsoft SQL Server 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.
The following table describes ColdFusion ODBC options for Microsoft SQL Server
data sources. You set these options when you configure a ColdFusion data source.
Option Description
Data Source Name A name for your ODBC data source.
Description A short description of the data source.
Server The name of the server hosting the database that you want to
use. If the SQL Server database is local and you are using the
Microsoft SQL Server driver, enclose the word local in
parentheses: (local).
•
Use Trusted Connection Allows SQL Server to
authenticate users based on their Windows NT logins. You
can use this option if the SQL Server database uses an
Integrated or Mixed security mode.
Login Info
•
Database The name of the SQL Server database.
•
Language The national language used by SQL Server.
•
Generate Stored Procedure for Prepared
Statement
Stored procedures are created for prepared
statements when you select this option. The SQL Server
driver prepares a statement by placing it in a procedure and
compiling that procedure.
Translation Convert OEM to ANSI characters Select this option if the
SQL Server client computer and SQL Server are using the
same non-ANSI character set. For example, if SQL Server uses
code page 850 and the client computer uses code page 850 for
the OEM code page, selecting this option ensures that
extended characters stored in the database convert properly to
ANSI for use by Windows-based applications.
install.book Page 121 Thursday, May 10, 2001 12:59 PM