Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA Enterprise SCADA

TABLE OF CONTENTS

<DriverType Type="SQL">

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJul 05, 2024
  • 2 minute read

The <DriverType Type="SQL"> may contain the following elements:

  • <DriverProperty Name="ConnectionString">

    • This string is used when establishing connection to a RealTime Database (RTDB) when using ADO.NET.

    • %Username% and %Password% macros in the connection string that will be substituted with the client's credentials.

    • %LocaleID% macro is used in LCID=%LocaleID%. For example, LCID=en-US. The value of %LocaleID% will be passed from user.

    • %SQLAuthenticationType% macro is used in SECURITY_PACKAGE=%SQLAuthenticationType%. The value of %SQLAuthenticationType% will be passed from user. The value will be either Kerberos or DBMS.

    • %ClientHostName% macro is used in CLIENTHOSTNAME=%ClientHostName%. The value of %ClientHostName% will be passed from the user, and will be the name of client.

    • %TimeZone% macro is used in Timezone=%TimeZone%. The value of %TimeZone% will be passed from user, and will be the timezone of the client.

    • Other standard macros which can be used in this section are: %System%, %SystemUserIdentity%, %VirtualHost(servicename)%.

  • <DriverProperty Name="LegacyADOConnectionString">

    • This string is used when establishing a connection to an RTDB using the older COM version of ADO (not ADO.NET).

    • This property supports the same macros as the ConnectionString property.

  • <DriverProperty Name="MinConnections">

    • The minimum number of connections to hold open to an RTDB.

    • The default is 1.

  • <DriverProperty Name="MaxConnections">

    • The maximum number of connections to obtain in order to process incoming requests.

    • Connections are closed after one minute of inactivity.

    • The default is 1.

  • <DriverProperty Name="RequestTimeOutMS">

    • The time in milliseconds to wait for a response to the request before a timeout notification is issued by the Data Access Layer (DAL).

    • A value of 0 means no timeout is desired.

  • <DriverProperty Name="SQL_INIT_#">

    • Microsoft SQL statements which will run right after connecting with the Microsoft SQL server.

    • The name can be SQL_INIT_1, SQL_INIT_2, SQL_INIT_3...SQL_INIT_10.