Connecting to a relational MR database
UNICOM Intelligence Data Model comes with two versions of the Relational MR Database (RDB) CDSC:
▪RDB DSC. This reads and writes the data through ODBC.
▪RDB DSC 2. This is an OLE DB-based implementation of the DSC, which provides significant advantages in terms of performance and memory usage.
This topic describes how to connect to a Relational MR Database using RDB DSC. To use RDB DSC 2, see
Connecting to a relational MR database using RDB DSC 2.
When connecting to a database using RDB DSC, you can specify the Location connection property (see
Connection properties) using an
ODBC connection string instead of a data source name (DSN). When a UNICOM Intelligence Interviewer project is activated, the ODBC connection string is automatically written to the .
mdd file. This means that you generally do not need to create a DSN when you transfer UNICOM Intelligence Interviewer data using SQL Server Data Transformation Services (DTS).
The xp_syncdb extended stored procedure (see
Adding extended stored procedures) always writes the connection string to the .
mdd file. xp_syncdb specifies the connection string as it was specified when the connection was made. So if you connect using a DSN, xp_syncdb writes the DSN to the Location in the .
mdd file and if you connect using an ODBC connection string, xp_syncdb writes it to the Location in the .
mdd file.
Parameters for the ODBC connection string
DRIVER
The name of the driver: set to SQL Server.
Trusted_Connection
Set to Yes.
DATABASE
The name of the database.
SERVER
The name of the server.
Example
DRIVER=SQL Server;Trusted_Connection=Yes;DATABASE=skidemo;SERVER=llnichols
See also