OleDb.Query

This function retrieves the output of a query executed using OLE DB with the provided connection string. The connectionString can be in the form of plain text or as a set of key-value pairs. The properties in the key-value pairs can have values that are either text or numeric. An optional parameter called options can be included to specify additional properties. This parameter can include the following fields: - ConnectionTimeout: This specifies the duration for which the system should wait before abandoning a connection attempt to the server. The default value depends on the specific driver being used. - CommandTimeout: This specifies the duration for which a server-side query is allowed to run before it is terminated. The default value is ten minutes. - SqlCompatibleWindowsAuth: This is a logical value (true/false) that determines whether the connection string options generated for Windows authentication should be SQL Server-compatible. The default value is true.