Connector/Net Connection String Options Reference
1936
General Options
Table 20.20. Connector/Net Connection String Options - General
Name
Default
Description
Allow Batch
,
AllowBatch
true
When true, multiple SQL statements can be sent with
one command execution. Note: starting with MySQL
4.1.1, batch statements should be separated by the
server-defined separator character. Statements sent to
earlier versions of MySQL should be separated by ';'.
Allow User Variables
,
AllowUserVariables
false
Setting this to
true
indicates that the provider expects
user variables in the SQL. This option was added in
Connector/Net version 5.2.2.
Allow Zero Datetime
,
AllowZeroDateTime
false
If set to
True
,
MySqlDataReader.GetValue()
returns a
MySqlDateTime
object for date or datetime
columns that have disallowed values, such as zero
datetime values, and a
System.DateTime
object
for valid values. If set to
False
(the default setting) it
causes a
System.DateTime
object to be returned
for all valid values and an exception to be thrown for
disallowed values, such as zero datetime values.
Auto Enlist
,
AutoEnlist
true
If
AutoEnlist
is set to
true
, which is the default,
a connection opened using
TransactionScope
participates in this scope, it commits when the scope
commits and rolls back if
TransactionScope
does
not commit. However, this feature is considered
security sensitive and therefore cannot be used in a
medium trust environment.
BlobAsUTF8ExcludePattern
null
A POSIX-style regular expression that matches the
names of BLOB columns that do not contain UTF-8
character data. See
Section 20.2.5.16, “Character Set
Considerations for Connector/Net”
for usage details.
BlobAsUTF8IncludePattern
null
A POSIX-style regular expression that matches
the names of BLOB columns containing UTF-8
character data. See
Section 20.2.5.16, “Character Set
Considerations for Connector/Net”
for usage details.
Certificate File
,
CertificateFile
null
This option specifies the path to a certificate file in
PKCS #12 format (
.pfx
). For an example of usage,
see
Section 20.2.4.7, “Tutorial: Using SSL with MySQL
Connector/Net”
. Was introduced with 6.2.1.
Certificate Password
,
CertificatePassword
null
Specifies a password that is used in conjunction
with a certificate specified using the option
CertificateFile
. For an example of usage, see
Section 20.2.4.7, “Tutorial: Using SSL with MySQL
Connector/Net”
. Was introduced with 6.2.1.
Certificate
Store Location
,
CertificateStoreLocation
null
Enables you to access a certificate held in a
personal store, rather than use a certificate file and
password combination. For an example of usage, see
Section 20.2.4.7, “Tutorial: Using SSL with MySQL
Connector/Net”
. Was introduced with 6.2.1.
Certificate Thumbprint
,
CertificateThumbprint
null
Specifies a certificate thumbprint to ensure correct
identification of a certificate contained within a personal
store. For an example of usage, see
Section 20.2.4.7,
“Tutorial: Using SSL with MySQL Connector/Net”
. Was
introduced with 6.2.1.
Содержание 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 ...