Up Database Connectivity SQL Server

Database Connectivity

 

Contact Us

 

Home
Up

Back

Database connectivity is flexible and easy within Hexatec SCAN1000 v5

This allows a wide range of options:

bulletADO database connectivity - for SQL & MSDE databases
bulletDAO database connectivity - for Microsoft Access
bulletSaturn Security Database - where system security is important
bulletEvent Log Databases - for secure records of: user logs, system events, etc.

For general database access, the ADO and DAO connectivity options support a wide range of database types including, traditional databases such as:

bulletSQL Server
bulletAccess
bulletDBase, Oracle, etc (via ODBC)

Other data sources include

bulletExcel
bulletOutlook
bullettext and csv files.

For examples of - database integration, take a look at the following case studies:

bulletMedical Product Storage - secure validation records
bulletQuality Control - automated product testing records
bulletTrading System - Utility metering records

 

ADO database connectivity

ADO (ActiveX Data Objects) supports fast, low overhead access to a wide variety of data sources.  ADO database support offers optimised connection to any data source, which has a corresponding OLEDB provider.  This includes large client - server based databases such as SQL Server and Oracle, along with a wide range of other options.

With ADO, databases are normally pre-created and then the project data is then linked to the database.

DAO database connectivity

DAO (Data Access Objects) is an alternative data access system.  DAO is normally used where smaller scale database facilities are required.  In this case the software can directly create Microsoft Access databases, based on project structure.  It is not necessary to have a copy of Access to use this facility.

Security Database

Some applications require high levels of security or for system settings to be held in a central location.  This is achieved using the Security Database option.  A common, shared database can be created, which is used as a central depository for key parameters such as; user name and password, calibration settings, alarm set-points, etc.

Event Log Databases

Event Logs are an easy way to process on-going system information, such as: user-logs, alerts, system warnings, changed data values, etc.  As well as storing event logs in readable text files, or routing them to printers, they can be written to sequential tables in Microsoft Access databases.

[ Back ] Home ] Up ]

Copyright © 2006 Hexatec