Otherwise - it will be equal to SQL_ATTR_ROW_ARRAY_SIZE.
Respectively, if the SQL_ATTR_ROW_ARRAY_SIZE attribute value is less than MinFetchRows, then the number of rows queried from the server will equal MinFetchRows. If the connection attempt fails, a new connection attempt is made via IPv4. Note: When the property is set to ivIPBoth, a connection attempt is made via IPv6 if it is enabled in the operating system. The privilege must be granted to the user before connecting to the server. Used to specify the system privilege for the user who connects to the server. Used to set the character set that the driver uses to read and write character data. These options should be enabled for compatibility with such tools. But some 3rd-party tools pass NULL to the parameters. If NULL, the driver should return an error. To retrieve metadata, not all parameters according to MSDN can accept a null value. Used to specify the Oracle system identifier of the database instance.Įnables the use of all schemas that an Oracle user has been granted privileges on. The value may be selected from the drop-down list of available clients. Used to specify the name of the Oracle Client. Used to change the current schema of the session to the specified schema. Used to specify the port number for the connection. Used to specify the host of the data source. Used to select the Oracle client to use with the application. The following table lists the connection string options for Oracle.