This shows you the differences between two versions of the page.
|
integration:rdbms:sqlserver:databases [2011/04/07 17:54] 127.0.0.1 external edit |
integration:rdbms:sqlserver:databases [2016/06/28 22:38] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ~~NOTOC~~ | ||
| - | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | |||
| - | ====== Integration: Relational Databases ====== | ||
| - | |||
| - | ===== SQL Server ===== | ||
| - | |||
| - | [[integration:rdbms:sqlserver:home|Overview]] | | ||
| - | [[integration:rdbms:sqlserver:environments|Environments]] | | ||
| - | **[[integration:rdbms:sqlserver:databases|Databases]]** | | ||
| - | [[integration:rdbms:sqlserver:tables|Tables]] | | ||
| - | [[integration:rdbms:sqlserver:constraints|Constraints]] | | ||
| - | [[integration:rdbms:sqlserver:datatypes|Datatypes]] | | ||
| - | [[integration:rdbms:sqlserver:queries|Queries]] | | ||
| - | [[integration:rdbms:sqlserver:updates|Updates]] | | ||
| - | [[integration:rdbms:sqlserver:example|Example]] | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ==== Databases ==== | ||
| - | |||
| - | The [[dev:sql:statements:create_database:home|CREATE DATABASE]] statement is used to declare a SQL Server database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from SQL Server using the EXTRACT statement as discussed in the previous section. | ||
| - | |||
| - | The CREATE DATABASE statement must include the DSN or File DSN that identifies the SQL Server database, as well as the SQL Server user and password. Note that the datatype type is ODBC, with a subtype of SQLSERVER, reflecting that ODBC is the primary method of accessing a SQL Server database. | ||
| - | |||
| - | <code> | ||
| - | create database "SIMPLE" | ||
| - | type odbc | ||
| - | subtype mysql | ||
| - | dsn "simple" | ||
| - | user "simple" | ||
| - | password "simple" | ||
| - | index_directory "idx" | ||
| - | in "simple.xml"; | ||
| - | </code> | ||
| - | |||
| - | === SQL Server Security === | ||
| - | |||
| - | Omnidex provides three methods of supporting SQL Server security. | ||
| - | |||
| - | * Administrators can register a user and password in the SQL Server datasource. | ||
| - | * Administrators can register a user and password in the Omnidex Environment File. This user and password will always be used to access the SQL Server database, and no users and passwords will be needed from the application. | ||
| - | * The application can pass a user and password in the [[dev:connections:home|Omnidex Connection String]]. This user and password is then passed directly to SQL Server to access the database. | ||
| - | |||
| - | One of these approaches must be used to allow connections to the SQL Server database. Administrators should insure that the user and password provides access to all of the database objects referenced in the Omnidex Environment Files. | ||
| - | |||
| - | ===== ===== | ||
| - | |||
| - | **[[integration:rdbms:sqlserver:environments|Prev]]** | | ||
| - | **[[integration:rdbms:sqlserver:tables|Next]]** | ||
| - | |||
| - | ====== Additional Resources ====== | ||
| - | |||
| - | See also: | ||
| - | |||
| - | {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} | ||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||