Database
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Service Cloud 7.1
- Documentation
Attribute
Database (DBN)
Purpose
Specifies the file name prefix the driver uses to create or locate the set of files that define the Object mapping and the embedded database used by the connection. See "Mapping objects to tables" for an explanation of embedded database.
Valid Values
prefix | path+prefix
where:
- prefix
- is the file name prefix for the embedded database. For example,
if Database is set to a value of
JohnQPublic, the embedded database files that are created or loaded have the formjohnqpublic.xxx. - path+prefix
- is a relative or absolute path appended to the file name prefix.
The path defines the directory the driver uses to store the newly
created database files or locate the existing database files. For
example, if Database is set to a value of
C:\data\db\johnqpublic, the driver either creates or looks for the database johnqpublic.xxx in the directoryC:\data\db. If you do not specify a path, the current working directory is used.
Notes
- The
driver parses the User ID value and removes all non-alphanumeric
characters. For example, if User ID is specified as
John.Q.Public, the value used for Database isJohnQPublic. - When SQL Engine Mode is set to Server, the path+prefix value overrides the value specified by the Server DB Directory configuration setting (see "Configuring server mode").
Default
The user ID specified for the connection.