AdoDotNet.DataSource

This function retrieves the schema collection for the ADO.NET data source using the specified providerName and connectionString. The connectionString can be in text format or a set of key-value pairs....

Syntax

AdoDotNet.DataSource(providerName as text, connectionString as any, optional options as nullable record) as table

About

This function retrieves the schema collection for the ADO.NET data source using the specified providerName and connectionString. The connectionString can be in text format or a set of key-value pairs. The values for the properties can be either text or numerical. An optional parameter, options, can be included to specify additional properties. This parameter can include the following fields: CommandTimeout - a time duration that specifies the maximum time allowed for a server-side query before it is cancelled. The default value is ten minutes. SqlCompatibleWindowsAuth - a boolean value (true/false) that determines whether SQL Server-compatible connection string options for Windows authentication should be generated. The default value is true. TypeMap - a field that specifies... (Note: The text was incomplete, so the last field "TypeMap" was left open-ended)