Re: Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter

Home Page Forums BizTalk 2004 – BizTalk 2010 Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter Re: Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter

#15671

Rather than use the windows schedule task, you could try the Scheduled Task Adapter.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728

You could use this to initiate an orchestration that will call a .NET class to access MySQL.

Or you could call your .NET class from this adapter. It requires two classes, one to define your config properties like connection string and query and the second implements the MySQL access and returns a stream.