DCS SW 6000 - Manual (Page 51)

Danish Interpretation Systems Installation Manual
Manual 01 19 60011 51
Descriptions of the more technical parts
Database
To use the SW 6000 applications you need a database. The database contains all data used by the application
such as delegate names, microphone information etc. etc.
When installing the SW 6000 software a database will be created with initial data.
The ‘SQL Database Engine’ hosts all databases.
These SQL servers can host the database for SW 6000:
Microsoft SQL 2000 server, Enterprise Edition or Standard Edition
Microsoft SQL Server 2005 Express
Microsoft SQL Server 2005
Microsoft SQL Server 2008 Express
Microsoft SQL Server 2008
If you are planning to use ‘Microsoft SQL Server 2008’ it must be preinstalled on the computer before you install
SW 6000. If you are planning to use ‘Microsoft SQL Server 2008 Express’ you can use the set-up on SW 6000
CD-ROM.
‘Microsoft SQL Server 2008’ is not part of the SW 6000 software package.
The data in the database is not secured in any way. If you want to secure your data, you must contact your
database administrator and change the connect strings used by the applications accordingly. For a description
of connects strings see Connect string.
Connect string
When the applications are connecting to the databases to get access to data they use a ‘connect string’. This
connect string identifies which database should be used by the application and how.
For the SW 6000 the connect string is located in registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\DIS\DCS6000\Database\Connect string
Connect string for MSDE
For MSDE the value of the connect string will typically have a value similar to the following:
Provider = SQLOLEDB.1;Initial Catalog=SW6000-1;Data Source=MSDECOMPUTER\SW6000;
The ‘Provider’ determines how the application should access the database. In this case OLEDB is used, which
is installed when installing MDAC 2.6.
The ‘Initial Catalogue’ is the name of the database to connect to. This is as default SW6000-1.
The ‘Data Source’ determines the computer where the database is located and the database instance on the
computer to be used.
Connect string for the SQL Server
For the SQL server the value of the connect string will typically have a value similar to the following: -
Provider = SQLOLEDB.1;Initial Catalog=SW6000-1;Data Source=SQLSERVERCOMPUTER;uid=sa;