|
| CommandTimeOut | | 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. |
| ConnectionString | | (Required) The ConnectionString attribute specifies a connection argument that properly identifies the service, server, database, user, and password necessary to establish a connection to a data source. Each service type will generally require a different ConnectionString syntax. For example, to connect to the Employees SQL Server database on a server named Server1 with administrator rights, the ConnectionString attribute value might be:'DRIVER={SQL SERVER};SERVER=Server1;DATABASE=Employees; UID=Admin;PWD=AdminPwd;' |
| ID | | (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 |
| 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. |