Professional > Interview scripting > Using Interview Services > Database Connection Interview Service
 
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
Configuring the database connection Interview Service for Author and Professional
Using the Database Connection Interview Service in an interview routing script
The Database Connection Interview Service interface
Using Interview Services