Not logged in : Login |
Click Next. The third tab contains settings that are not required for a basic connection: Read Only connection - Specifies whether the connection is "Read-only." Make sure the checkbox is unchecked to request a "Read/Write" connection. Defer fetching of long data - Defers fetching of LONG (BINARY, BLOB etc.) data unless explicitly requested in a query. This provides significant performance increases when fields in query do not include LONG data fields. Disable interactive login - Suppresses the ODBC "Username" and "Password" login dialog boxes when interacting with your ODBC DSN from within an ODBC compliant application. Multiple Active Statements Emulation - Enables use of Multiple Active statements in an ODBC application even if the underlying database does not allow this, as it is emulated in the driver. Row Buffer Size - Specifies the number of records to be transported over the network in a single network hop. Values can range from 1 to 99. SQL_DBMS_NAME - Manually overrides the SQLGetInfo(SQL_DBMS_NAME) response returned by the driver. This is required for products like Microsoft InfoPath (for which the return the value should be "SQL Server").
Attributes | Values |
---|---|
description |
|
described by | |
title |
|
type | |
position |
|
is topic of | |
is schema:step of |