This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
integration:rdbms:odbc:databases [2012/10/26 15:35] 127.0.0.1 external edit |
integration:rdbms:odbc:databases [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 23: | Line 23: | ||
| The [[dev:sql:statements:create_database:home|CREATE DATABASE]] statement is used to declare a database within an Omnidex Environment File to be accessed through ODBC. This statement can either be issued directly, or it can be extracted from the database using the EXTRACT statement as discussed in the previous section. | The [[dev:sql:statements:create_database:home|CREATE DATABASE]] statement is used to declare a database within an Omnidex Environment File to be accessed through ODBC. This statement can either be issued directly, or it can be extracted from the database using the EXTRACT statement as discussed in the previous section. | ||
| - | The CREATE DATABASE statement must include the datasource that connects to the underlying database, as well as a user and password. | + | The CREATE DATABASE statement must include the datasource that connects to the underlying database, as well as a user and password. It is recommended to use a System DSN, rather than a User DSN, so that the DSN will be accessible across all users and from the Omnidex Network Services. |
| <code> | <code> | ||