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 an ODBC database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from 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 database, as well as the ODBC user and password. Note that the datatype type is ODBC, with a subtype of MYSQL, reflecting that ODBC is the primary method of accessing a ODBC database.
create database "SIMPLE" type odbc subtype mysql 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 ODBC database. Administrators should insure that the user and password provides access to all of the database objects referenced in the Omnidex Environment Files.
See also: