locked
Dynamic DB2 adapter - BizTalk 2009 RRS feed

  • Question

  • I've just recently installed BizTalk Server 2009 Adapters for Host Systems 2.0 Enterprise.  I can see the new DB2 adapters in the Admin Console and have configured them for my host.  The problem is that I'm trying to use dynamic send ports w/ the DB2 Adapter.  According to the doco, I should see (at design time) the following properties when I use an Expression Shape in side my Orchestration:

    • DB2.ConnectionString
    • DB2.DocumentTargetNamespace
    • DB2.ResponseDocumentRootElementName
    I am not seeing these properties, and thus cannot set them for my dynamic port.

    Any help would be appreciated.
    Thursday, July 9, 2009 9:05 PM

Answers

  • Hi

    In order to see those properties in your orchestration, you need to reference the assembly containing the DB2 property schema from the project with the orchestration.

    Find the correct assembly, and reference it - should work.

    eliasen, representing himself and not the company he works for.
    Three times MVP and three times MCTS in BizTalk.
    Blog: http://blog.eliasen.dk
    • Marked as answer by bdunk11 Friday, July 10, 2009 1:39 PM
    Friday, July 10, 2009 7:16 AM

All replies

  • These are the promoted properties of the message in the Expression editor. Try making a message and configure its type. Then in the expression editor you can set these properties like this.

    MyDB2Message(DB2.ConnectionString) = "ConnectionString";

    MyDB2Message(DB2.DocumentTargetNamespace) = "DB2.DocumentTargetNamespaceVale";

    MyDB2Message(DB2.ResponseDocumentRootElementName) = "DB2.ResponseDocumentRootElementNameVale";

    Abdul Rafay http://abdulrafaysbiztalk.wordpress.com/ Please mark this answer if it helps
    Thursday, July 9, 2009 9:09 PM
  • Hi

    In order to see those properties in your orchestration, you need to reference the assembly containing the DB2 property schema from the project with the orchestration.

    Find the correct assembly, and reference it - should work.

    eliasen, representing himself and not the company he works for.
    Three times MVP and three times MCTS in BizTalk.
    Blog: http://blog.eliasen.dk
    • Marked as answer by bdunk11 Friday, July 10, 2009 1:39 PM
    Friday, July 10, 2009 7:16 AM
  • Thanks, that was it.  The .dll is Microsoft.HostIntegration.Adapters.MsDb2.PropertySchemas

    I don't know why I couldn't find it yesterday.  Just one of those days I guess.
    Friday, July 10, 2009 1:40 PM