<DriverType Type="LSQL">

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

• <DriverProperty Name="ConnectionString">

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

  • %Username% and %Password% macros in the connection string 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 the user.

  • %SQLAuthenticationType% macro is used in SECURITY_PACKAGE=%SQLAuthenticationType%. The value of %SQLAuthenticationType% will be passed from the 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.

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

• <DriverProperty Name="HostName">

  • This specifies a default hostname for Business Logic Tier (BLT) calls to this alias.

  • If the virtual hostname needs to be defined then use the %VirtualHost(servicename)% macro explained in Macros.

• <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 processing incoming requests.

  • Connections are closed after one minute of inactivity.

  • The default is 1.

• <DriverProperty Name="UsesParser">

  • This element is for legacy Microsoft SQL requests.

  • Set the element to the default of True if the Microsoft SQL string requires parsing to convert the legacy Microsoft SQL string to conform to Microsoft SQL 7.5 standards.

• <DriverProperty Name="UsesADO">

  • This element is for legacy Microsoft SQL requests.

  • Set the element to the default of True if the an ADO connection is required.

  • The "ConnectionString" property will be used as the ADO connection string.

• <DriverProperty Name="ExecutionTimeOutMS">

  • This is the timeout for the creation and execution of BLTs.

  • There is no infinite value.

  • If no value is defined, then the default value will be used.

• <DriverProperty Name="ConnectionManagerPortNumber">

  • This is the port number for the BLT client connection manager.

  • If no value is defined, then the default value will be used.

• <DriverProperty Name="ConnectionManagerMaxBufferSize">

  • This is the maximum buffer size for the BLT client connection manager.

  • If no value is defined, then the default value will be used.

• <DriverProperty Name="ConnectionManagerMaxConnections">

  • This is the maximum numbers of connections for the BLT client connection manager.

  • If no value is defined, then the default value will be used.

• <DriverProperty Name="SQL_INIT_#">

  • Microsoft SQL statements that 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.

• <DriverProperty Name="TablePollMultiplier">

  • This number acts as a multiplier for the poll periodicity property for the RealTime Table Summary control (DNARTTable).

  • This can be used to slow down polling rates of summary displays when running remotely over slow network connections.

  • The default value is 1.