User`s guide
78 Chapter 7: Configuration
See Also
• Database Configuration
• Database Service Names and SID
• Database TNS Alias
7.10.2 Database Setup Options
There are several ways to configure the database connection settings. The
following sections describe the configuration options for the Viz Content Pilot
(VCP) client and the Newsroom Component (NrC). Configurations for the VCP
client also applies for Viz Template Wizard (TW) and Viz Object Store (VOS).
This section contains information on the following topics:
• Initialization File
• Initialization File and Registry
• Initialization File and Environment Variable
• Registry
Initialization File
A initialization file (INI) is used by all the VCP applications. The only exception is
the Newsroom Component (NrC) that mainly uses registry settings, except when
configured to use Viz Video Hub. Since it is possible to connect to the VCP
database by only using an INI file, the tnsnames.ora file may be omitted.
The INI file can be opened with the Inifile Editor (located in the program folder) or
a regular text editor.
If the database username and password is changed (default is
PILOT
/
PILOT
), they
too must be set under the
Database
section.
Initialization File and Registry
A combination of an initialization (INI) file and registry settings, allow the use of a
Database TNS Alias. This is helpful if the database setup is used by more than one
application.
The TNS alias is held by the
name
property under the
Database
section in the
ContentPilot.ini file.
In addition to the INI file, a
TNS_ADMIN
string must be added to the registry to
avoid potential conflicts with other applications using a local environment
variable. The
TNS_ADMIN
string holds the path to the
tnsnames.ora
file which
contains database connection information for one or more databases.
The
TNS_ADMIN
string should be added to the
Viz content pilot 5.x
registry key.
The following are valid path definitions to a tnsnames.ora file:
• TNS_ADMIN: C:\Program Files\<directory> (path to a local
tnsnames.ora
file)
• TNS_ADMIN: \\<hostname>\<directory> (path to a remote
tnsnames.ora
file)