![]() ![]() This can enforce execution optimizations. Set this property to true if the query is to be executed over fully replicated tables. You can use earlier versions of the protocol for backward compatibility. Used to specify ODBC protocol version to use. If set to true, the query optimizer does not reorder tables in the join. Setting a low value can result in slow data fetching while setting a high value can result in additional memory usage by the driver, and additional delay when the next page is being retrieved.Įnables the non-colocated distributed joins feature for all queries that are executed over the ODBC connection.Įnforces a join order of tables in SQL queries. Default value should be fine in most cases. Number of rows returned in response to a fetching request to the data source. This parameter is required if authentication is enabled on the server. #Universal database dsn format how to#See Authentication and CREATE user docs for more details on how to enable authentication and create user, respectively. From Admin Tasks, double-click Configure DSN. To create a DSN: Select Navigate, then Administer, and then Consolidation Administration. This parameter is required if authentication is enabled on the server. The DSN specifies the database server name and other database-related information, such as the username and password of a user with full access rights to the database server. Port on which OdbcProcessor of the node is listening. This argument value is ignored if ADDRESS argument is specified. If this attribute is specified, then SERVER and PORT arguments are ignored. Attribute keywordĪddress of the remote node to connect to. If it is not specified, SERVER and PORT attributes are used instead. The exception to this rule is the ADDRESS attribute. If an argument is not specified, the default value is used. All parameter names are case-insensitive - ADDRESS, Address, and address all are valid parameter names and refer to the same parameter. #Universal database dsn format driver#The ODBC driver supports and uses several connection string/DSN arguments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |