If your application is single threaded, you might have better performance with this property. If no database is specified, a server-only connection is created. In this case, none of the properties are updated. Some of the connection string values have corresponding read-only properties. You can avoid SQL parsing overhead by setting this value to ‘true’.
|Date Added:||22 November 2017|
|File Size:||49.4 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Required if the client machine or user account is not trusted by the host. The language locale used on the client side of the client-server connection. Valid values are No, 0, Yes, or 1. The name of the database within the server instance. The size in bytes of the buffers used to send data to or from the server.
If no database is specified, a server-only connection is created. If another user has already opened the database, exclusive access is denied, an error is returned, and the database is not opened.
If an attribute name occurs more than once in the connection string, the value associated with the last occurrence is used. Send feedback Examples exchange Troubleshooting.
If the connection has not been opened, the returned connection string does contain security information, regardless of the setting of Persist Security Info. Resetting the connection string resets all connection string values, including the password.
The name or alias of the instance of the Informix server to which to connect. Reduces the number of round trips to the server for result-set queries. When the connection string is set, all of these properties are updated, except when an error is connectionn. The connection string that is returned is the same as the one set sgring the user.
You can avoid SQL parsing overhead by setting this value to ‘true’. The connection string is parsed immediately after being set. You can only set the ConnectionString property when the connection is closed.
Some of the connection string values have corresponding read-only properties. Other errors can be found only when an attempt is made to open the connection. 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.
The Server attribute is mandatory in all situations. The minimum number of connections allowed in the pool.
IfxConnection properties return those settings contained in the ConnectionString as well as default values or values gathered elsewhere. If your application is single threaded, you might have better performance with this property.
Enables or disables automatic enlistment in a distributed transaction.
When set to true or y for yes, any string within double quotes ” is treated as an identifier, and any string within single quotes ‘ is treated infformix a string literal. CP Windows Connection Lifetime When a connection is returned to the pool, the donnection 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 password associated with the User ID.
Resetting the ConnectionString on a closed connection resets all connection string values and related properties, including the password.
The default value of the ConnectionString property is an empty string. If any of those are missing, the server ignores the remaining attributes and next checks the environmental variables, followed by the values strkng specified in setnet The communication protocol used between the CreateConnection and the database server. The following table shows the connection string attributes.
However, you must be certain that your queries are correct, otherwise an error will result.
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 fof exceeds the value specified by connection lifetime.