System information

CONFIGURING AND ADMINISTERING COLDFUSION 9

Data Source Management

Last updated 2/21/2012

Note: If the database driver attempts to connect to a database server that does not support SSL, connection might hang.

You can avoid issues when connecting to a server that does not support SSL by setting a login timeout.

For more information on enabling SSL for DB2, Microsoft SQL Server, Oracle, and Sybase, see the DataDirect

documentation available at the following URL:

http://media.datadirect.com/download/docs/jdbc/alljdbc/wwhelp/wwhimpl/js/html/wwhelp.htm

For more information on enabling SSL for MySQL, see MySQL documentation available at the following URL:

http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-configuration-properties.html

Connecting to ODBC Socket

Use the settings in the following table to connect ColdFusion to ODBC Socket data sources (this is a Type 3 driver):

Oracle Oracle EncryptionMethod=SSL; KeyStore=path to keystore; KeyStorePassword=keystore

Password; KeyPassword=key Password; TrustStore=path to keystore;

TrustStorePassword=trustStorePassword;

ValidateServerCertificate=true|false;

HostNameInCertificate=host_name|#SERVERNAME#};

Sybase Sybase EncryptionMethod=SSL;TrustStore=path to keystore;

TrustStorePassword=trustStorePassword;

ValidateServerCertificate=true|false;

HostNameInCertificate=host_name|#SERVERNAME#;

MySQL MySQL (4/5) useSSL=true&requireSSL=true|false&

verifyServerCertificate=true|false&clientCertificateKeyStoreUrl=URLToClie

ntCertificate&clientCertificateKeyStoreType=KeyStoreType&clientCertificat

eKeyStorePassword=keystorePassword&trustCertificateKeyStoreUrl=URLToRootC

ertificate&trustCertificateKeyStoreType=

KeyStoreType&trustCertificateKeyStorePassword=trustedRootCertificatePassw

ord

Note: Not all MySQL (4/5) properties listed are supported by all MySQL versions.

See MySQL documentation for details of the supported properties for your version.

Setting Description

CF Data Source Name The data source name (DSN) that ColdFusion uses to connect to the data source.

ODBC DSN Select the ODBC DSN to connect to ColdFusion.

Trusted Connection Specifies whether to use domain user account access to the database. Only valid for SQL Server.

User name The user name that ColdFusion 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 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.

Return Timestamp as String Enable this option if your application retrieves Date/Time data and then reuses it in SQL statements

without applying formatting (using functions such as

DateFormat, TimeFormat, and

CreateODBCDateTime).

Database Database Driver Connection Property