Element Details: Connection.ADO
 Back


Available in: Logi Info Source code name: Connection.ADOIntroduced in: 12.1.188

Connection.ADO enables data connections using any ADO data provider as the driver.

These connections are normally used with DataLayer.SQL elements.

The following example Connection.ADO example works with HPCC clusters.

<Connection Type="ADO"
AdoAssembly="System.Data.CData.HPCC.dll" ID="HPCC" AdoConnectionString="URL=http://192.168.193.242:8510;Offline=false;Cluster=yourCluster;Version=1" CommandTimeOut="30" />

ADO connections work with .NET only, not available in Java.

Element Group:General Purpose Data Connectors



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AdoAssembly
UserDefined
(Required) The assembly name or filename of an ADO data provider. Provider DLLs may be located in either the .NET Global Assembly Cache (GAC) or the web application's bin folder. For data providers located in the GAC, specify the invariant name. For example: System.Data.SqlClient For data providers located in the web application's bin folder, specify the DLL filename. For example: System.Data.RSSBus.Facebook.dll
AdoConnectionString
UserDefined
(Required) A connection string valid for the ADO.NET data provider.
CommandTimeOut
UserDefined
The CommandTimeOut attribute specifies the amount of time, in seconds, before the request to connect to the data source is presumed to have failed. For most data sources, the default value is 60 seconds. For MySql, the default is 30 seconds.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
SqlSyntax
Vertica
SqlServer
Redshift
PostgreSQL
Oracle
MySql
DB2
1010data
SqlSyntax specifies the type of database server. The value is used by ActiveSQL DataLayers which must know the database type to generate correct SQL statements. Studio's QueryBuilder also uses SqlSyntax for ODBC connections.



PARENT ELEMENTS

Click element to drill down for more information.

Connections Studio Connection


CHILD ELEMENTS

Click element to drill down for more information.

Metadata


 Back to top


 Chart Debug