The communication among the different levels of information systems is nowadays a widespread requirement and strongly felt in all industrial sectors.
The first step towards efficient integration is to make the software on-board the machine able to exchange the information useful for MES applications with the database.
Automa makes
SmartDB available to its customers, a product which allows a
Super-Flash application to access a database to write and read data.
One of the top strong points of the product is its ability to exchange information with 80% of the databases present on the market, as it follows the ODBC and OLE DB standard (which supports the two most common interfaces towards the database: Microsoft's ODBC driver and OLE DB provider) and allows execution of SQL commands.
To get further information on
SmartDB, the
Product Profile can be downloaded.
Description |
Product which allows access, in reading and writing, to the data of a database from a Super-Flash application. It makes a series of functions available (which can be used by means of MicroC) divided into: initialisation, connection, control, recordset, conversion and information. |
Characteristics |
Simple: SmartDB makes a layer of reasoned, simplified and problem-oriented functions available: it was thought up to prevent having to force the programmer to go too deep into the underlying technologies Powerful: local or remote, multiple, synchronous and asynchronous connections; execution of SQL programs; direct manipulation from MicroC of the Database accessing functions Flexible: combination with a procedural language like MicroC; availability of an engine multitasking, and easy interaction with all the resources of the application (variables, alarms trend, recipes, etc.) allow even the most complex problems to be faced efficiently
|
Limits |
it is only possible to connect to Databases which have an OLE DB provider or an ODBC driver, typically made available by the Database manufacturer or directly from Microsoft it does not manage error indication if asynchronous operations of asynchronous type are used (connection, control and recordset) it does not manage stored procedures with output parameters it does not manage the return value of the stored procedure
|
Competence |
a minimum of theoretical knowledge about Databases a minimum of knowledge about the Databases used a minimum of knowledge about the Database provider for composing the connection knowledge of the SQL language for composing the commands fair knowledge of the MicroC programming language
|
Minimum requirements |
Windows 2000/XP Operating System with ADO and OLE DB support Client for access to the Database (for Microsoft SQL Server integrated in the Operating System) Super-Flash version 3.9 and later MicroC version 2.2 and later
|
Product Contents |
The package supplied, available on CD or downloadable from this site in the FreeDownload section for Runtime licences or in the Download section for the Royalty-Free licences, contains:
SmartDB 1.0.1 Product (DLL) Documentation: User Manual Demo of Super-Flash application - Smartkey Drivers
|
 |
|
Top of page