none
sql data adapter ports RRS feed

  • Question

  • I have a biztalk project where I have successfully created my sql data adapter schemas.  What I am trying to do now is wire them up to ports and am having trouble finding a clear answer.  We are inserting data into a sql server database and returning the primary key generated from the insert, so I have a request and response schema therefore I also have a 2 way port.  I am confused on the general settings to configure this to have it point to the appropriate sql server and db.  Do I transmit via HTTP and just have the uri be the ip address of the sql server?
    Adam
    Thursday, January 29, 2009 6:30 PM

Answers

  • Hi,

    For the SQL send port you set three things:

    • The database connection string
    • The target namespace of the schema
    • The root record name of the response message

    The stored procedure is determined by the name of the record in the reuqest message.

    There is a good walkthru on this here:

    http://msdn.microsoft.com/en-us/library/aa560708.aspx

    Regards,

    Alan

     


    BloggersGuides.net
    • Proposed as answer by Mikael HåkanssonMVP Friday, January 30, 2009 5:02 PM
    • Marked as answer by ahager Friday, January 30, 2009 8:30 PM
    Thursday, January 29, 2009 6:41 PM