Understanding the single Historical Archive Data Access Layer (DAL) file

The following parameters in the Data Access Layer (DAL) file are configurable:

• DriverProperty LegacyADOConnectionString Server is the Microsoft SQL Server name as the Relational Database Management System (RDBMS) Host Name (for example, pdcHs1, pdcSqlsvr).

• DriverProperty ConnectionString Server is the Microsoft SQL Server name as the RDBMS Host Name (for example, pdcHs1, pdcSqlsvr).

• DriverProperty HostName is the virtual host name of the Archive service (for example, pdcArchive).

An appropriate source DAL filename can be chosen as needed.

The following is a DALConfig_SingleArchive_PDC.xml source DAL file example for clustered SQL Server installation:

<?xml version="1.0" encoding="UTF-8"?>

<DALConfig xmlns="http://www.telvent.com/DALConfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.telvent.com/DALConfig DALConfig.xsd">

<DriverAlias Alias="Archive">

<DriverType Type="SQL">

<DriverProperty Name="LegacyADOConnectionString">Provider=MSOLEDBSQL;Server=pdcSqlsvr,20010;Trusted_Connection=yes;Network Library=dbmssocn;WSID=%ClientHostName%;Application Name=%ClientAppName%</DriverProperty>

<DriverProperty Name="ConnectionString">Server=pdcSqlsvr,20010;Trusted_Connection=yes;WSID=%ClientHostName%;Application Name=%ClientAppName%</DriverProperty>

</DriverType>

<DriverType Type="LSQL">

<DriverProperty Name="ConnectionString">Server=pdcSqlsvr,20010;Trusted_Connection=yes;WSID=%ClientHostName%;Application Name=%ClientAppName%</DriverProperty>

<DriverProperty Name="HostName">pdcArchive</DriverProperty>

</DriverType>

<DriverType Type="BLT">

<DriverProperty Name="HostName">pdcArchive</DriverProperty>

</DriverType>

<DriverType Type="CHART">

<DriverProperty Name="HostName">pdcArchive</DriverProperty>

</DriverType>

<DriverType Type="DBEdit">

<DriverProperty Name="ConnectionString">Server=pdcSqlsvr,20010; Trusted_Connection=yes; User Id=%Username%; Password=%Password%; WSID=%ClientHostName%;Application Name=%ClientAppName%;MultipleActiveResultSets=True</DriverProperty>

</DriverType>

<DriverType Type="ESQL">

<DriverProperty Name="ConnectionString">Data Source=pdcSqlsvr,20010;Trusted_Connection=yes;WSID=%ClientHostName%;Application Name=%ClientAppName%</DriverProperty>

</DriverType>

</DriverAlias>

</DALConfig>