MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manual do Utilizador descarregar pdf (Página 53)

Connecting to Microsoft SQL Server 53

Note: This driver uses the Microsoft Jet list of reserved words, including the word Last. For a

complete list, see http://support.microsoft.com/?kbid=248738.

Connecting to Microsoft SQL Server

To see a list of SQL Server versions that ColdFusion MX supports, go to

www.macromedia.com/go/sysreqscf. Use the settings in the following table to connect

ColdFusion MX to Microsoft SQL Server:

CLOB Select to return the entire contents of any CLOB/Text columns in the database

for this data source. If not selected, ColdFusion MX retrieves the number of

characters specified in the Long Text Buffer setting.

BLOB Select to return the entire contents of any BLOB/Image columns in the database

for this data source. If not selected, ColdFusion MX retrieves the number of

characters specified in the BLOB Buffer setting.

LongText Buffer The default buffer size, used if the CLOB option is not selected. The default

value is

64000 bytes.

BLOB Buffer The default buffer size, used if the BLOB option is not selected. The default

value is

64000 bytes.

Allowed SQL The SQL operations that can interact with the current data source.

Setting Description

CF Data Source

Name

The data source name (DSN) used by ColdFusion MX to connect to the data

source.

Database The database to which this data source connects.

Server The name of the server that hosts the database that you want to use. If the

database is local, enclose the word local in parentheses. If you are running SQL

Server locally (or using MSDE), specify 127.0.0.1 for the

server name instead of the actual instance name.

Port The number of the TCP/IP port that the server monitors for connections.

Username The user name that ColdFusion MX passes to the JDBC driver to connect to the

data source if a ColdFusion application does not supply a user name (for

example, in a

cfquery tag).

Password The password that ColdFusion MX passes to the JDBC driver to connect to the

data source if a ColdFusion application does not supply a password (for

example, in a

cfquery tag).

Description (Optional) A description for this connection.

Connection

String

A field that passes database-specific parameters, such as login credentials, to

the data source.

Setting Description

1 2 ... 48 49 50 51 52 53 54 55 56 57 58 ... 169 170

Comentários a estes Manuais

Sem comentários

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manual do Utilizador Página 53

Comentários a estes Manuais

Manuais e produtos relacionados com Servidores MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER