Attribute

InitializationString (IS)

Purpose

A SQL command that is issued immediately after connecting to the database to manage session settings.

Valid Values

SQL_command

where:

SQL_command

is a valid SQL command that is supported by the database. Separate multiple commands by semicolons. If this option is specified in a connection URL, the entire value must be enclosed in parentheses when multiple commands are specified.

Example

To set the date format on every connection, specify:

InitializationString=Set DateStyle='ISO, MDY'

Notes

• If the statement fails to execute, the connection fails and the driver reports the error returned from the server.

Default

None

GUI Tab

Advanced tab