Calling an API using Visual Basic: An Example

This example calls the OBTAIN PERSON LOAF (BAUDD051) Stored Procedure.

The UF Identity Registry Project Team wishes to thank Pamela K. Bengtson (Research and Graduate Programs) for contributing this example. Any questions concerning this code should be directed to

This is a Visual Basic routine in an Access 2000 module used to call a DB2 stored procedure. Results are currently displayed in a debug window. The intention is to build a form to display lookup values after passing a UFID.

A reference needs to be set for the “Microsoft ActiveX Data Objects 2.6 Library”

*** Statements with an ’ (apostrophe) in front represent comments****

Click here to view sample code.