Database Lookup Functoid
Use the Database Lookup functoid (
) to extract a row from a database table as a Microsoft ActiveX Data Objects (ADO) recordset.
Input
Parameter 1: A value for which to search in the specified database, table, and column.
Parameter 2: A connection string for the database in which to search.
Parameter 3: The name of the table in the database in which to search.
Parameter 4: The name of the column in the table in which to search.
Output
Output 1: An ADO recordset that contains the value sought. Regardless of the number of rows that match the specified value, only the first matching row is included in the recordset.
Remarks
Use this functoid in conjunction with the Value Extractor and Error Return functoids.
Security To avoid the security risks associated with your Microsoft SQL Server™ password being visible as part of the connection string you provide as input parameter 2, you should use Windows NT® authentication instead of SQL Server authentication.
See Also
Adding Basic Functoids to a Map
To download updated BizTalk Server 2004 Help from www.microsoft.com, go to http://go.microsoft.com/fwlink/?linkid=20616.Copyright © 2004 Microsoft Corporation.All rights reserved.
