Connecting to MS SQL server from MySql database

[Jaideep Vinakota]

Hi,
One of my applications use MySql database. Now I need to retrieve data from a vendor app which uses MS SQL Server. I need to change some of the stored procedures to connect to the MS SQL Server and retrieve data from SQL Server into my MySql database.

I could not find any documentation on even if this is possible and supported by Mysql.

My questions:
1) Does mysql support connecting to a remote database
2) If yes to #1 how can I connect to SQL Server?

I appreciate any/all help.

Thanks
Jaideep