Re: Connection string in database lookup functoid…

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Connection string in database lookup functoid… › Re: Connection string in database lookup functoid…

January 9, 2007 at 2:02 PM #17184
community-content
    • Go to any file folder but preferably the one containing your mapping project/files.
    • Create a text file and name it "DBConnection.udl".  (The important part is the extension .udl)
    • Double click the file.
    • On the Provider Tab, select SQL Native Client (this assumes it is installed), then Next
    • For Data Source, enter yours: HPSQL05T
    • Initial Catalog, TESTDB
    • Either use integrated security or click allow saving password
    • Test Connection…OK
    • In your map, either drop a String Concatenate functoid or add the following to the Database Lookup functoid as the second paramter.
    • File Name=<replace this with the path to the .udl file you created>
    • example: File Name=C:\Project\Database\DBConnection.udl
  • Configure the rest of the Database functoid(s) input(s), but at least a Value Extractor, and connect it to output so you can see the results.
  • Test your map.

    • Does this make sense…and did it work?