Some of the connection string values have corresponding read-only properties. In this case, none of the properties are updated. If no database is specified, a server-only connection is created. Prohibited if a User ID is not given. Using these statements without proper management can lead to unexpected results. If you set the Persist Security Info attribute to false the default , if the connection has ever been opened, the returned connection string will not contain any security information. The service name or port number through which the server is listening for connection requests.
|Date Added:||21 November 2004|
|File Size:||34.31 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
If an attribute name occurs more than once in the connection string, the value associated with the last occurrence is used. Enables or disables automatic enlistment in a distributed transaction.
If you set the Persist Security Info attribute to true, the returned connection string contains security information. The size in bytes of the buffers used to send data to or from the server. The name or alias of the instance of ztring Informix server to which to connect. The maximum number of connections allowed in the pool.
NET Provider does not automatically recognize when these commands are issued. If another user has already opened the database, exclusive access is denied, an error is returned, and the database is not opened. If any of those are missing, the server ignores the remaining attributes and next checks the environmental variables, followed by the values in specified in setnet When set to true, the IfxConnection object is drawn from the appropriate pool, or if necessary, it is created and added to the appropriate pool.
Reduces the number of round trips to the server for result-set queries. IfxConnection properties return those settings contained in the Pdbc as well as default values or values gathered elsewhere. Using these statements without proper management can lead to unexpected results.
In this case, none of the properties are updated. If errors in syntax are found when parsing, a runtime exception, ArgumentException, is returned.
You fog only set the ConnectionString property when the connection is closed. The connection string is parsed immediately after being set. CP Windows Connection Lifetime When a connection is returned to the pool, the creation time of the connection is compared with the current time, and the connection is destroyed if that time span in seconds exceeds the value specified by connection lifetime.
The name or IP address of the machine on which the Informix server is running. Maximum value is 2GB. The connection string that is returned inforix the same as the one set by the user.
The following table shows the connection string attributes. If no database is specified, a server-only connection is created.
Resetting the connection string resets all connection string values, including the password. The minimum required connection string attributes that must be set for non-DSN connections are Server, Protocol, Service, and Host name. Required if the client machine or user account is not trusted by the host.
Some of the connection igm values have corresponding read-only properties. The communication protocol used between the CreateConnection and the database server.
The name of the database within the server instance. The language locale of the database.
The default value of the ConnectionString property is an empty string. The password associated with the User ID. The Server attribute is mandatory in all situations. When the connection string is set, all of these properties are updated, except when an error is detected.
Resetting the ConnectionString on a closed connection resets all connection string values and related properties, including the password. The minimum number of connections allowed in the pool. The service name or port number through which the server is listening for connection requests.