|
|
IDL DataMiner Guide: IDL DataMiner API |
|
IDLdbDatabase objects have the following properties in addition to properties inherited from any superclasses. Properties with the word "Yes" in the "Get" column of the property table can be retrieved via IDLdbDatabase::GetProperty. Properties with the word "Yes" in the "Set" column in the property table can be set via IDLdbDatabase::SetProperty.
| Note For a discussion of the property description tables shown below, see About Object Property Descriptions. |
If True, the GetTables method is available for the current driver.
The name of the Database with which the object is associated.
The ODBC level supported by the driver being used to connect to the database.
The version number of the Database that the object is associated with.
The version number of the ODBC driver being used to connect to the database.
If True, a connection to a database exists.
If True, the database is read-only.
The maximum number of connections supported by the ODBC driver. If the maximum value is unknown, this property will contain 0.
The maximum number of recordsets supported by the ODBC driver. If the maximum is unknown, this property will contain 0.
The ODBC level of the driver manager.
The SQL level supported by the connection.
The SQL server name for this database connection.
If True, the ODBC cursor library will be used. The ODBC cursor library is used to emulate advanced functionality on data sources that don't support the advanced functions. If you find that advanced functionality is not available using your database's standard driver, try using the ODBC cursor library. Advanced functionality supported by the cursor library includes positioned updates, positioned deletes, and multi-directional cursor movement.
| Note This property must be set (or unset) before the connection to the data source is made. Once the connection is made, this property cannot be changed. The default is to not use the cursor library. |
| Warning To support the above-mentioned operations, the cursor library constructs SQL search statements to locate the desired record. If the WHERE clause of the generated SQL statement selects more than one row, the operation will affect more than one record. |
| Warning On some systems the ODBC cursor library is loaded dynamically. The ODBC system cannot detect whether the library was loaded successfully, so this property may contain a True value if the USE_CURSOR_LIB property was set, even if the cursor library was not subsequently loaded. |
The user name used during the connection to the datasource.
If True, verbose error messages will be generated. Normal error messages contain a text explanation (normally from the ODBC system) of the error. Verbose message include the following additional information: