Frequently Asked Questions

When installing an Oterro application onto a client's computer, you will need to use the Oterro ODBC installer. If you have purchased a distributable version of the Oterro engine, you will find an installer that does not include samples or documentation in your installation directory that can be used on the clients machine.

R:BASE is a better way of managing your constraints and rules, as well as working with other aspects of the Oterro database. RBDefine provides a GUI interface for working with your database. As for doing this through Access, Visual Basic or any other program, there are SQL commands for doing everything except rules.

Oterro stores triggers and stored procedures in the database itself. The stored procedures originate in ASCII files and are inserted using the PUT command. Once a Stored Procedure has been added to the Database, it can be made to function as a Trigger by using the ALTER TABLE command, where you can identify Stored Procedure to be associated with the table to be launched at an UPDATE, INSERT or DELETE.

A trigger is an action placed on a table to automatically execute upon insert, delete, or update of a row of data in the table. A trigger executes a stored procedure. The stored procedure contains the commands to execute upon the trigger action.

Correct. Oterro does not implement them in the same fashion as SQL Server. However, Oterro provides support for them for when you are using optimistic concurrency and SQL SpecialColumns. Oterro also provides the SYS_ROWVER column that contains the version of the row. This computed column is added to a table when the table is ALTERed and the AUTOROWVER setting is ON.

Oterro does not have a built-in function for database replication, although you can certainly do this through your Visual Basic code. Oterro is a robust, multi-user database engine with optimistic concurrency control and intelligent, automatic, and dynamic locking. With Oterro, you do not need to use database replication as a work around for poor multi-user performance.

A: Table, view, and column names are limited to 128 characters at this time.

A: Yes. Oterro supports the use of table and column names with embedded spaces as long as the name is enclosed with the identifier quote character whenever the name is used. The default identifier quote character is a backwards single quote (`). We recommend, however, that you replace the spaces in names with underscores "_" for ease of use.

A: Yes. The Oterro documentation includes a complete list of reserved words. You can minimize the list by adding the keyword ANSI OFF to your configuration file. This is not recommended, but can be used as a way to safely rename the column or table.

A: The semi colon is only used to end a multi-line SQL command. The Oterro engine does not support multi-line commands.

A: All you should need to do if you are accessing a database through an ODBC connection is to replace the database name in the connect string. When using DAO or RDO controls, you would replace the database name with an ODBC connection to the Oterro database. So long as the table and field names remain the same, you should not need to change any of the properties of the bound controls. There may be other code changes if you are using DAO functions that are specific to an Access/Jet database.

A: Oterro can be accessed by any ODBC 2.5 or higher front end development tool. All the functionality is available regardless of the front end tool. Oterro does ship with an H file for use with C++.

A: Yes and No. Oterro can be used in a Multi-User situation where users are connecting with R:BASE at the same time as users connect with Oterro. This does not mean that you can use the application developed in R:BASE without conversion. You will need to redevelop the user interface and much of the application flow (menus and the like) in your new environment.

A: Because of the wide variety of situations and needs, we simply can't make one recommendation. Oterro allows you to use the tools you want to use to develop your application. In general, you should use the tools that you feel most comfortable with and that are appropriate for your needs. Our clients have reported sucess using the following tools:
  • Active Data Objects (ADO) 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
  • TeraScript, Witango
  • MS Office Visio 2003
  • UPS WorldShip

A: Yes. Both environments allow you to access the same data, but R:BASE provides a complete integrated solution. Oterro can only add to the power of R:BASE itself and allows you to expand the native interface. For example, using Oterro you can create databases for use in R:BASE that dynamically restructure themselves, by adding and removing entire sets of tables or you can create databases that exceed the storage capacities of your hardware. Another exciting feature is that with the addition of the SCONNECT READ command in R:BASE you can even use R:BASE to connect to an Oterro database on read only media such as a CD-ROM, allowing you to create offline archives, or network shares that do not provide Write access.

A: Yes. Both products share a common database engine and can be mixed in a multi-user environment. This allows you the flexibility you need to provide the right solution to every user. The following products can be mixed in a multiuser seting:
  • R:BASE for Windows
  • R:Compiler
  • Runtime for Windows
  • Oterro Numbered
  • Oterro Unlimited

A: It will not interfere with Oterro Unlimited or any other Product's ability to connect to a database. However, it is possible for those other products to interfere with the Oterro Numbered's ability to connect to a database. Oterro Numbered will only connect to a database if the connected user count is lower than its license count. For example, if you purchase the Oterro Five User License you will only be able to connect if there are less than five users connected. This means that if you have 2 R:BASE users, 1 Oterro for Tango User and 2 Runtime users connected you would not be able to connect using the Oterro Five User pack as all five connections have been taken.