General:

• Read/Write capable
• Automatic multi-user locking to provide the most liberal concurrent user access control - built into the engine
• Automatic write to disk verification
• Automatically maintains a duplicate copy of the database
• Engine level security via access rights
• Full referential integrity - constraints and custom business rules enforced at engine level
• Multi-thread compatible
• Supports stored procedures
• Supports triggers
• Data Access Objects (DAO) can be used with Oterro
• RemoteData controls can be used with Oterro
• Oterro automatically enters dates in both the 20th and 21st centuries.
• Supports full ODBC Level 2.x and partial support for Level 3.x
• Full engine level referential integrity
• Cost-based query optimizer built in the engine
• Full engine level multi-user optimistic locking

Platforms Supported:

• MS Windows 98SE
• MS Windows NT 4.0 Workstation
• MS Windows NT 4.0 Server
• MS Windows 2000 Professional
• MS Windows 2000 Server
• MS Windows 2003 Server
• MS Windows 2008 Server
• MS Windows XP
• MS Windows Vista
• MS Windows 7

Supported Development Environments: While not intended to be a complete list of development environments the products listed below have been used by our clients with Oterro:

• ADO.NET
• Active Data Objects 2.x and Remote Data Objects
• Active Server Pages
• Macromedia Cold Fusion
• Pervasive's Tango Enterprise
• Microsoft Visual Basic
• Microsoft Visual C++
• Borland C++ Builder
• Borland Delphi
• Other environments using the Borland Database Engine
• Microsoft Office (including Access, Excel and Word)
• R:BASE for Windows
• Java
• PHP
• Crystal Reports
• IBM WebSphere
• Witango Server 5.x
• MS Office XP 2003
• MS Office Visio 2003
• UPS WorldShip

Transaction Processing:

• Read repeatability transaction processing
• Automatic database recovery

Application Development:

• File structure incorporates multimedia types -binary large objects
• Supports DLL access to the database
• Supports ODBC API for best performance

Data Integrity:

• Optimistic concurrency control
• Primary/foreign key constraints with cascading updates and deletes
• Rules
• Mirrored database
• Write check verify