MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manual de usuario descargar pdf (Pagina 43)

Adding data sources 35

11 (Optional) To verify this data source later, click the verify icon:

Note: To check the status of all data sources available to ColdFusion, click Verify All

Connections.

Specifying connection string arguments

You can use the ColdFusion Administrator to specify connection string arguments for

data sources that use the Microsoft Access,ODBC Socket, MYSQL, or DB2 drivers. In

the Advanced Settings page for one of these drivers, enter name=value pairs separated by

a semicolon in the Connection String field. The following figure shows how to specify

the application name and workstation ID for an ODBC Socket connection to SQL

Server:

The Administrator configures the following ODBC connection string:

DSN=odbcdsnname;APP=RaiseGenerator;WSID=TWriter01

In the preceding string, odbcdsnname is the name of the ODBC DSN. This is the string

that the Microsoft Access or ODBC Socket driver uses to connect to the data source at

runtime.

Note: The connectstring tag attribute is not supported in ColdFusion MX.

Adding data source notes and considerations

When adding data sources to ColdFusion MX, keep these guidelines in mind:

• Data source names should be all one word.

• Data source names can contain only letters, numbers, and the underscore.

• Data source names should not contain special characters.

• Although data source names are not case-sensitive, you should use a consistent

capitalization scheme.

A data source must exist in the ColdFusion Administrator before you use it on an

application page to retrieve data.

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 67 68

Sin comentarios

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Manual de usuario Pagina 43