How to use an ODBC data source in the Lookup variable in Datacap

The Lookup variable allows certain clients such as askmaster Web to provide to operators a link for querying a database and presenting returned data for population. An OLEDB example can be found within foundation applications and general documentation such as Application Development using IBM Datacap Taskmaster Capture.

Solution:

Use dsn="DSN=..." notation, particularly when supplying the user name and password in cases where credentials are not stored within the ODBC data source.

Here is an example using a SQL fingerprint database:
TestFP;User ID=uid;Password=pwd">SELECT tp_TemplateID FROM Template

Note: In this example the Vendor field will be updated with whatever value is stored in the template ID (tp_templateID) column of the record that the operator selects. The user name "uid" and password "pwd" are used to login to the SQL database corresponding with the DSN "TestFP"; please note that TestFP is not necessarily the exact database name.