Oracle 5.0, Справочное руководство

Страница: 1959 / 3232

Connector/Net Connection String Options Reference
1939
Name Default Description
Logging
false When true, various pieces of information is output to
any configured TraceListeners. See
Section 20.2.5.14,
“Using the MySQL Connector/Net Trace Source Object”
for further details.
Old Guids
,
OldGuids
false This option was introduced in Connector/Net 6.1.1.
The backend representation of a GUID type was
changed from
BINARY(16)
to
CHAR(36)
. This was
done to allow developers to use the server function
UUID()
[967] to populate a GUID table -
UUID()
generates a 36-character string. Developers of
older applications can add
'Old Guids=true'
to the connection string to use a GUID of data type
BINARY(16)
.
Old Syntax
,
OldSyntax
,
Use
Old Syntax
,
UseOldSyntax
false This option was deprecated in Connector/Net 5.2.2. All
code should now be written using the '@' symbol as the
parameter marker.
Password
,
pwd
The password for the MySQL account being used.
Persist Security Info
,
PersistSecurityInfo
false When set to
false
or
no
(strongly recommended),
security-sensitive information, such as the password, is
not returned as part of the connection if the connection
is open or has ever been in an open state. Resetting
the connection string resets all connection string
values, including the password. Recognized values are
true
,
false
,
yes
, and
no
.
Pipe Name
,
Pipe
,
PipeName
mysql When set to the name of a named pipe, the
MySqlConnection
attempts to connect to MySQL
on that named pipe. This setting only applies to the
Windows platform.
Port
3306 The port MySQL is using to listen for connections. This
value is ignored if Unix socket is used.
Procedure Cache Size
,
ProcedureCacheSize
,
procedure cache
,
procedurecache
25 Sets the size of the stored procedure cache. By default,
Connector/Net stores the metadata (input/output data
types) about the last 25 stored procedures used. To
disable the stored procedure cache, set the value to
zero (0). This option was added in Connector/Net 5.0.2
and Connector/Net 1.0.9.
Protocol
,
Connection Protocol
,
ConnectionProtocol
socket Specifies the type of connection to make to the server.
Values can be:
socket
or
tcp
for a socket connection,
pipe
for a named pipe connection,
unix
for a Unix
socket connection,
memory
to use MySQL shared
memory.
Replication
false Indicates if this connection is to use replicated servers.
Respect Binary Flags
,
RespectBinaryFlags
true Setting this option to
false
means that Connector/Net
ignores a column's binary flags as set by the server.
This option was added in Connector/Net version 5.1.3.
Shared Memory Name
,
SharedMemoryName
MYSQL The name of the shared memory object to use for
communication if the connection protocol is set to
memory
.
Sql Server Mode
,
sqlservermode
false Allow SQL Server syntax. When set to
true
, enables
Connector/Net to support square brackets around
symbols instead of backticks. This enables Visual
Studio wizards that bracket symbols with [] to work with