This is an old revision of the document!
Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example
The CREATE DATABASE statement is used to declare a database within an Omnidex Environment File to be accessed using ODBC. This statement can either be issued directly, or it can be extracted from the database through ODBC using the EXTRACT statement as discussed in the previous section.
The CREATE DATABASE statement must include the DSN or File DSN that identifies the ODBC datasource, as well as the ODBC user and password.
create database "SIMPLE" type odbc dsn "simple" user "simple" password "simple" index_directory "idx" in "simple.xml";
Omnidex provides three methods of supporting ODBC security.
One of these approaches must be used to allow connections to the database using ODBC. Administrators should insure that the user and password provides access to all of the database objects referenced in the Omnidex Environment Files.
See also: