MARS is available to .NET provider and SQL Native Client as I stated. You need to enable it in the connection string, and your application code must be written...
You did not say which API you are using but MARS is only available with SQL Native Client or the .net provider SQLClient. Assuming you are using one...