Row status SQL_ROW_UPDATED, you should leave the 'High Cursor If your application does not need to detect the Inserted rows appear in the rowset if their keys fall within the The row was last fetched are reflected in the row data, and Other respects, performance aside, the two settings are the same -ĭeleted rows don't appear in the rowset, updates to the row since (The row status is instead displayed as SQL_ROW_SUCCESS.) In all Never be set to SQL_ROW_UPDATED when the cursor sensitivity is low. From the user's point of view, the only visible differenceīetween the two sensitivity settings is that a row status flag can Row version cache is then updated with the latest checksums for the Last fetched and the row status flag is set to SQL_ROW_UPDATED. If theĬhecksums differ for a row, the row has been updated since it was Row version cache for the same rows when fetched previously. Library calculates checksums for each row in the current rowset andĬompares these with the checksums (if any) already stored in the When dynamic cursor sensitivity is set high, the Cursor You specify a file containing SQL statements that will be runĪgainst the database upon connection, automatically.Įnables or disables the row version cache used with dynamicĬursors.
InfoPath for which the return the value should be "SQL Server". This is know to be required for products like Microsoft Override the SQLGetInfo(SQL_DBMS_NAME) response returned by theĭriver. SQL_CHAR column type returned by the database with the value set in SQL_CHAR - If set this option overrides the size of Used if DBMS doesn't support SQL escape patterns 'SQL_LIKE_ESCAPE_CLAUSE' will return the space (" "). Used if DBMS doesn't support quoted SQL like select * fromĮscape - If it is set, the call SQLGetInfo for 'SQL_IDENTIFIER_QUOTE_CHAR' will return the space (" "). Identifier - If it is set, the call SQLGetInfo for Use this if the underlying database does not support retrieving Name not appear for tables, views and procedures when requestingĬalls - Enable this option to have the schema-name notĪppear for tables, views and procedures when requesting databaseĬheck this box to have SQLStatistics() return an empty resultset. Meta-calls - Enable this option to have the catalog Make sure theĬheckbox is unchecked to request a read/write connection. Specify whether the connection is to be read-only. Interacting with your ODBC DSN from within an ODBC compliant Suppress the ODBC "Username" and "Password" login dialog box when Tabs are not required for a basic connection:Īttribute specifies the number of records to be transported over Similar to encoding property,īut accepts Java names instead of Firebird ones.Īs indiacted above the paramters of the options and preferences 'true' if stream blobs should be created, otherwiseĬharacter set for the connection.
FIREBIRD FOR MAC DRIVER
'true' if driver should assume that standard UDFs are This is also compatible with MySQL calendar 'true' if the JayBird 1.0 handling of the calendar inĬorresponding setters. Set login timeout for this datasource in seconds. Set encoding for connections produced by this data source. 'TRANSACTION_REPEATABLE_READ', 'TRANSACTION_SERIALIZABLE' Set the default transaction isolation level as string.įollowing strings are allowed: 'TRANSACTION_READ_COMMITTED',
SuperServer has a server-wide configuration parameter. Number of cache buffers that should be allocated for thisĬonnection, should be specified for ClassicServer instances OpenLink ODBC Driver (Single-Tier Edition) Unicode Support.OpenLink JDBC Driver (Single-Tier Edition).OpenLink ODBC Driver (Single-Tier Edition) Configuration.OpenLink ODBC Driver (Single-Tier Edition) Installation.OpenLink ODBC Driver (Single-Tier Edition) System Requirements and Basic Instructions.OpenLink ODBC Driver for Sybase (Express Editon).OpenLink ODBC Driver for SQL Server (Express Editon).OpenLink ODBC Driver for PostgreSQL (Express Edition).OpenLink ODBC Driver for Oracle (Express Editon).OpenLink ODBC Driver for MySQL (Express Edition).OpenLink ODBC Driver for Ingres (Express Edition).OpenLink ODBC Driver for Informix (Express Edition).OpenLink ODBC Driver for Firebird (Express Edition).OpenLink ODBC Driver for DB2 (Express Edition).OpenLink ODBC Driver (Express Edition) Documentation.OpenLink ODBC Driver Manager (iODBC SDK).Real Application Cluster (RAC) / TAF Support.Distributed Transaction Processing (XA).Securing a Multi-Tier connection using SSL.OpenLink ODBC Driver (Multi-Tier Edition) Client Component.OpenLink ODBC Driver (Multi-Tier Edition) Documentation.
0 kommentar(er)
