Table of contents
TOC
Collapse the table of content
Expand the table of content

Odbc.DataSource

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Odbc.DataSource(connectionString as any, optional options as nullable record) as table

About

Returns a table of SQL tables and views from the ODBC data source specified by the connection string connectionString. 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:

  • CreateNavigationProperties : A logical (true/false) that sets whether to generate navigation properties on the returned values (default is true).
  • HierarchicalNavigation : A logical (true/false) that sets whether to view the tables grouped by their schema names (default is false).
  • ConnectionTimeout : A duration which 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 which 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.
© 2018 Microsoft