Read Database Data

Use the OPCSystems.dll assembly to call GetDatabaseData to return a DataTable of values from a database table or view.

  • The GetDatabaseData function returns a DataTable of values from the local or remote service by obtaining database values where the service is running.
  • Returns blank DataTable if service is not reachable.
  • DBProvider is the database provider type to use.
  • DBServer is the database server to connect to. Not applicable for MS Access and Oracle.
  • TableOrView is the table name or view name to query the data from.
  • MSSQLWindowsAuthentication – when connecting with SQL Server use Windows Authentication. When false specify the DBUser and DBPassword for SQL user login.
  • DBUser is the user name for security authentication. Not applicable if using SQL Server and MSSQLWindowsAuthentication is set to true.
  • DBPassword is the password for security authentication. Not applicable if using SQL Server and MSSQLWindowsAuthentication is set to true.
  • FieldNames is a string array containing the field names to query from the table for view.
  • DataTypes is an array of field data types for the fields.
  • UseDates will enable using the StartDate and EndDate.
  • StartDate as the start date and time of history to retrieve.
  • EndDate as the end date and time of history to retrieve.
  • QueryString is the WHERE condition to append to the query. When blank it is not used.
  • NetworkNode is the name of the network node of the OPC Systems Service to connect to. Leave blank for localhost connection.
  • ErrorString will be set to Success when function is successful and an error message when in error.
  • RemoteSCADAHostingName is the name of the Live Data Cloud OPC Systems Service to connect to.
CONTENTS

VB

C#

Software Maintenance

ANNUAL SOFTWARE MAINTENANCE

BENEFITS TO PURCHASING MAINTENANCE WITH LICENSE:

1. Free version upgrades for maintenance contract duration plus 90 days
2. Product upgrades, such as tag or feature increases, for the difference in price vs. the full feature price.
3. If you have the full OAS suite, then new features will be added to your contract at no additional cost.
4. For your maintenance renewal(before expiration date), you pay percentage(20%) of your original price.
5. You can move a license from one system to another.

WITHOUT A MAINTENANCE CONTRACT:
1. No version upgrades after 90 days of purchase.
2. If you want a change in tag or features, you must pay full price for new license.
3. If you have the full OAS suite, to obtain new features purchase of product feature is required.
4. If you decide to get on maintenance after it has expired it will cost double(40% of the current price of the license vs. 20% of the original price) what it would have if you had purchased it with your license.
5. You cannot move a license.