SXI Forum

SeanR

Administrator

Registered: 20-11-2018

Posts: 150

Data Base Connection properties

What are these properties for?

SeanR

Administrator

Registered: 20-11-2018

Posts: 150

Re: Data Base Connection properties

These properties are used when trying to connect to a MSSQL database server that uses Windows Authentication.

Example of a config without properties:

<Connector id="MSSQL" type="DB">
	<Connection xsi:type="sxi:MSSQL">
		<sxi:Server>127.0.0.1</sxi:Server>
		<sxi:User>sxi</sxi:User>
		<sxi:Password>sxi</sxi:Password>
		<sxi:RetryDelay>30</sxi:RetryDelay>
		<sxi:DBName>XLayer</sxi:DBName>
		<sxi:Port>1433</sxi:Port>
	</Connection>
	<sxi:ReturnCodes>
		<sxi:Success></sxi:Success>
		<sxi:RecoverableError>
			<sxi:Code>I/OsError.*</sxi:Code>
			<sxi:Code>.+Read timed out.+</sxi:Code>
			<sxi:Code>Invalid state.+</sxi:Code>
			<sxi:Code>.+Invalid state.+</sxi:Code>
			<sxi:Code>.+Error.+</sxi:Code>
			<sxi:Code>.+SHUTDOWN is in progress.+</sxi:Code>
			<sxi:Code>SHUTDOWN is in progress.+</sxi:Code>
		</sxi:RecoverableError>
	</sxi:ReturnCodes>
</Connector>

Example of a config with properties included:

<Connector id="MSSQL" type="DB">
	<Connection xsi:type="sxi:MSSQL">
		<sxi:Server>127.0.0.1</sxi:Server>
		<sxi:User>sxi</sxi:User>
		<sxi:Password>sxi</sxi:Password>
		<sxi:RetryDelay>30</sxi:RetryDelay>
		<sxi:DBName>XLayer</sxi:DBName>
		
		<!-- ============= PROPERTIES ============= -->
	    <sxi:Properties>
			<sxi:Property name="instance" value="XLayer" />
			<sxi:Property name="domain" value="domain name"/>
			<sxi:Property name="useNTLMv2" value="true"/>
		</sxi:Properties>
		<!-- ============= PROPERTIES ============= -->
		
		<sxi:Port>1433</sxi:Port>
	</Connection>
	<sxi:ReturnCodes>
		<sxi:Success></sxi:Success>
		<sxi:RecoverableError>
			<sxi:Code>I/OsError.*</sxi:Code>
			<sxi:Code>.+Read timed out.+</sxi:Code>
			<sxi:Code>Invalid state.+</sxi:Code>
			<sxi:Code>.+Invalid state.+</sxi:Code>
			<sxi:Code>.+Error.+</sxi:Code>
			<sxi:Code>.+SHUTDOWN is in progress.+</sxi:Code>
			<sxi:Code>SHUTDOWN is in progress.+</sxi:Code>
		</sxi:RecoverableError>
	</sxi:ReturnCodes>
</Connector>