>I have used ODBC to access SQL Server in the past, so you can imagine my surprise to find that the VFP ODBC does not expose Stored Procedures to the client. Is there a way to run a stored procedure through ODBC, specifically useing ASP pages.

Try:
SQLEXEC(g_sql_h1,'execute usp_test')