If you ran make test when you built DBD::ODBC and were connecting to MS SQL Server, the test 20SqlServer should have been run and that includes calls to procedures (look in t/20SqlServer in the DBD::ODBC distribution).
There should have been more to the error message than you have provided.
The proper ODBC syntax is
{ call sp_who() }
Comment on Re: DBD::ODBC, FreeTDS and Stored Procedure