SQL Functoid

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Functoid

Viewing 1 reply thread
  • Author
    Posts
    • November 19, 2008 at 10:28 AM #21228
      community-content

        Hi ,

        I am using a custom fuctoid to lookup some data from a data source, but i dont want to hardcode my connection string as a parameter in the functoid, is there a best practice regarding that issue.

         

        I was thinkng of creating a scripting functoid to call an assembly to read the connection string from a config file.

         

        Any Ideas????

         

        Thanks in advance

      • December 4, 2008 at 3:44 AM #21304
        community-content

          I’ve read in  a book to set the connection string in an UDL-File.

          That’s just a simple Text file with the connection string.

          The DB-Functoid gets the adress of the udl file instead of the connection string.

          File Name=C:\myPathtoUDL\connection.UDL

           

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.