SQL adapter to SQL2008 RRS feed

  • Question

  • Hi.

    I have a Server 2003 whit Biztalk2006 r2, sql2005, vs2005.  And this works find.

    Can i use biztalk SQL adapter to connect to a new server whit SQL2008, and read and write data to database on this server?

    I have download and instal LOB adapter and Biztalk sql adapter.

    I make a connection to this SQL2008 whit "Consume adapter Service" and i pick a database, and i pick a tabel, an i want to insert.

    I receive 3 xsd schemas.   Then i make a map.   But I'm not quite sure which of the three schemas I shall use.

    But i try one of them. And i make an Orchestration.

    I build this and deploy this to my Biztalk server.  When i try to send a message to insert to this SQL2008 server, the message is going to dehydrated in Biztalk.

    Is there someone out there who can help me or have a guide on how to use "Consume adapter Service" to connect to SQL2008.

    Brg. Nit


    Thursday, September 9, 2010 9:11 AM