SQL Server Connection String

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Server Connection String

Viewing 1 reply thread
  • Author
    Posts
    • October 22, 2009 at 3:56 PM #23507
      community-content

        Hi ,

           My biztalk server and SQL server are installed on the same box. I am using a database functoid in my map to a table I created in SQL server

         

        I am using the following String

        Provider=SQLOLEDB.1;Integrated Security = SSPI; Persist Security Info = False; Inital Catalog=EDICrossReference;DataSource = CC-DT-IT-01;

         

        But i am not getting any value in my value extractor. I checked the data and it exists but its not retrieved.

         

        Can anyone please help how to fix this issue

         

        Thank you

        Sangeetha

      • October 22, 2009 at 7:25 PM #23509
        community-content

          Hi Sangeetha,

           

              Try this connection string:

           

          Provider=SQLNCLI;Server=CC-DT-IT-01;Database=EDICrossReference;Trusted_Connection=yes;

             Daniel.

          • October 23, 2009 at 3:53 AM #23514
            community-content

              Thank you. It worked.

              • October 23, 2009 at 6:51 AM #23517
                community-content

                  why you hardcoding your connection string..we have option to create connection string in UDL file then call that UDL file from Database functoid…

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