Database Connection Interview Service
The Database Connection Interview Service is a COM-callable .NET assembly that can be used as a basis for writing other more sophisticated Interview Services. When the service is accessible from IOM.Services, it allows an ADO database connection to be shared between multiple running interviews. This helps improve performance and scalability for interview scripts, that use direct database access, by eliminating the need for each script to individually connect to the database.
The Interview Service automatically ensures a successful connection is established before supplying the connection to the routing script. A single ADO Connection object can be shared between all running interviews.
The service’s source is available as a UNICOM Intelligence Developer Documentation Library sample, and is in:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\DDL\Code\DBConnectionService
The assembly .dll file is:
C:\Program Files\Common Files\IBM\SPSS\DataCollection\<version>IOM\DBConnectionClient.dll
See also