Odbc.Query
Returns the result of running a native query on an ODBC data source.
Syntax
Odbc.Query(
connectionString as any,
query as text,
optional options as record
) as table
Remarks
Returns the result of running query
with the connection string connectionString
using ODBC. connectionString
can be text or a record of property value pairs. Property values can either be text or number. An optional record parameter, options
, may be provided to specify additional properties. The record can contain the following fields:
ConnectionTimeout
: A duration that controls how long to wait before abandoning an attempt to make a connection to the server. The default value is 15 seconds.CommandTimeout
: A duration that controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.SqlCompatibleWindowsAuth
: A logical (true/false) that determines whether to produce SQL Server-compatible connection string options for Windows authentication. The default value is true.
Examples
Example #1
Return the result of running a simple query against the provided connection string.
Odbc.Query("dsn=your_dsn", "select * from Customers")
Result:
table
Category
Accessing data