View All Products. Services Consulting Education Modernization Outsourcing. Characters Remaining: Please provide feedback! Accessing odbc. Printable View. Title Accessing odbc. URL Name Article Number How to access bit and bit data sources on Windows bit and bit OS? Where are the bit and bit data sources stored in Windows bit and bit OS? Steps to Reproduce. Clarifying Information. The default value is "0", or no compression.
A value of "1" to "10" specifies the amount of compression from fast, but not very thorough, to very thorough, but not as fast. A value of "6" specifies a balance between size and speed, and represents the ideal level for most applications. The ElevateDB ODBC Driver will automatically adjust this value for situations where the existing compression level is not ideal, such as in cases where the amount of data being sent is so small that it is of no benefit to compress the data.
Using different values can result in log entries being prematurely overwritten or appearing "out-of-order" when viewing the log entries via the LogEvents Table.
Setting the value to "FALSE" can significantly improve the performance of the loading of the Databases system information table when there are a lot of databases in a configuration. This is because ElevateDB has to open the database catalog for each database in order to read the character set and version number.
The maximum number of open SQL statements per connection is , so you should not set the statement cache size that high. Also, the SQL statement cache size is a per-open-database setting. All Rights Reserved Questions or comments? E-mail us at info elevatesoft. Data Source Type.
This string value specifies the name of connection, and is the same as the DSN. This string value specifies the description of the connection. This string value specifies the host name of the ElevateDB Server machine that you are accessing. This string value specifies the service name of the ElevateDB Server machine that you are accessing. This string value specifies the port number of the ElevateDB Server machine that you are accessing. This string value specifies whether pinging will be enabled for the connection to the ElevateDB Server.
This string value specifies how often the connection will ping the ElevateDB Server when pinging is enabled via the PING registry value for the data source. This string value specifies how long the connection will wait on a response from the ElevateDB Server before disconnecting and issuing an error. This string value specifies whether the connection to the ElevateDB Server should be encrypted or no.
This string value specifies the password to use for encrypted connections to the remote ElevateDB Server, as well as for encrypting logins to the remote ElevateDB Server.
This string value specifies the amount of compression to use when communicating with the ElevateDB Server. This string value specifies how many rows will be read in a single request when the connection is requesting rows from the remote ElevateDB Server. The default value is "10". This string value specifies whether the configuration file used by the data source will be located in the process memory "virtual" or on disk. The configuration file in ElevateDB stores the contents of the system-defined Configuration Database.
Please see the Architecture for more information on configuration files. This string value specifies the configuration path to use for the data source. Please see the Architecture for more information on the configuration path. This string value specifies the temporary tables path to use for the data source. Characters Remaining: All Rights Reserved.
See Trademarks for appropriate markings. View All Products. Services Consulting Education Modernization Outsourcing. Characters Remaining: Please provide feedback! Printable View. URL Name Article Number
0コメント