Element Details: Connection.SqlServer
 Back


Available in: Logi Info Source code name: Connection.SqlServer

The Connection.SqlServer element sets the parameters required to connect to a Microsoft SQL Server database.

Element Group:Relational Databases



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
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.
SqlServer
UserDefined
(Required) The host name of the Microsoft SQL Server database.
SqlServerConnectionString
UserDefined
A full connection string to the Microsoft SQL Server database. If a value is defined, it will override all other settings for the connection element and use this string to connect to the database. SqlServer Parameter elements are still processed and added to the string.
SqlServerDatabase
UserDefined
(Required) The name of the Microsoft SQL Server database.
SqlServerPassword
UserDefined
The password for the Microsoft SQL Server database.
SqlServerPort
UserDefined
The port address of the Microsoft SQL Server database. Defaults to port 1433.
SqlServerUser
UserDefined
(Required) The user name for the Microsoft SQL Server database.



PARENT ELEMENTS

Click element to drill down for more information.

Connections Studio Connection


CHILD ELEMENTS

Click element to drill down for more information.

Logi Application Service Jdbc Params
Metadata
Microsoft SQL Server Parameters
Sql Server Context
Studio Connection


 Back to top


 Chart Debug