PreviousNext

Connecting to a Relational MR Database Using RDB DSC 2

Location connection property

When connecting to a relational MR database using RDB DSC 2, you need to specify the Location connection property using an OLE DB connection string. This should specify the parameters shown in the following table.

Here is an example of an OLE DB connection string that connects to the Short Drinks sample database:

Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=short_drinks;
Data Source=LocalHost

MR Init Custom connection property

The MR Init Custom connection property can be used to specify whether the connection should favor memory use or speed. The valid settings are:

• FavorMemory. Uses server-side cursors so that a single SQL Server connection can be re-used across multiple commands. This mode is slower, but uses less memory (and fewer SQL Server connections) as the number of concurrent commands increases.

• FavorSpeed. Uses default cursors, requiring a new connection for each command. This mode is considerably faster than the FavorMemory mode, but does use more memory. The FavorSpeed option also optimizes binding look-up by creating a look-up vector. This is the default setting.

To set this property in the Data Link Properties dialog box, select the All tab, and then double-click the MR Init Custom property. Type the required setting into the Property Value text box and then click OK.

Complete example

The following is a complete connection string for the Short Drinks sample database. Notice that the Data Source property is set to mrRdbDsc2 and the MR Init Custom property is set to favor memory:

Provider=mrOleDB.Provider.2;
Data Source=mrRdbDsc2;
Location="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=short_drinks;Data Source=LocalHost";
Initial Catalog=[INSTALL_FOLDER]\IBM\SPSS\DataCollection\6\DDL\Data\Mdd\short_drinks.mdd;
MR Init Project=short_drinks;
MR Init Custom=FavorMemory

Note that in these examples, each connection property is presented on a separate line for clarity. In practice you should specify the connection string without line breaks.