![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961957.webp)
Connector/Net Connection String Options Reference
1937
Name
Default
Description
CharSet
,
Character Set
,
CharacterSet
Specifies the character set that should be used to
encode all queries sent to the server. Resultsets are
still returned in the character set of the result data.
Check Parameters
,
CheckParameters
true
Indicates if stored routine parameters should be
checked against the server.
Command Interceptors
,
CommandInterceptors
The list of interceptors that can intercept SQL
command operations.
Connect Timeout
,
Connection Timeout
,
ConnectionTimeout
15
The length of time (in seconds) to wait for a connection
to the server before terminating the attempt and
generating an error.
Connect_Attrs
Passes a predefined set of key/value pairs containing
connection-specific data items to the server, for
application-defined purposes. connector/Net
automatically transmits the following attributes:
_pid
,
_client_version
,
_platform
,
_program_name
,
_os
,
_os_details
, and
_thread
. See
Performance
Schema Connection Attribute Tables
for the
Performance Schema
tables to query on the server
side to make use of these attributes.
Convert Zero Datetime
,
ConvertZeroDateTime
false
True to have
MySqlDataReader.GetValue()
and
MySqlDataReader.GetDateTime()
return
DateTime.MinValue
for date or datetime columns
that have disallowed values.
Default Command Timeout
,
DefaultCommandTimeout
30
Sets the default value of the command timeout to be
used. This does not supercede the individual command
timeout property on an individual command object.
If you set the command timeout property, that will be
used. This option was added in Connector/Net 5.1.4
Default Table Cache Age
,
DefaultTableCacheAge
60
Specifies how long a
TableDirect
result should
be cached, in seconds. For usage information about
table caching, see
Section 20.2.5.7, “Using Connector/
Net with Table Caching”
. This option was added in
Connector/Net 6.4.
enableSessionExpireCallback
false
When set to
true
, causes the session-expiry scanner
to raise the
session_end
event before deleting the
session data stored in the
my_aspnet_sessions
table, when a session times out. Enable this option to
write additional application-specific cleanup code to
handle the
session_end
event of the
global.asax
class, before the stored data of the session gets
deleted. Within the session_end method, any other
required cleanup can be done. This option was
added in Connector/Net 6.4.5; it is not yet available in
Connector/Net 6.5.x releases.
Encrypt
,
UseSSL
false
For Connector/Net 5.0.3 and later, when
true
, SSL
encryption is used for all data sent between the client
and server if the server has a certificate installed.
Recognized values are
true
,
false
,
yes
, and
no
. In
versions before 5.0.3, this option had no effect. From
version 6.2.1, this option is deprecated and is replaced
by
SSL Mode
. The option still works if used. If this
option is set to true, it is equivalent to
SSL Mode =
Preferred
.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...