I have an ASP page calling a stored procedure. When I run the stored procedure on the server (under root) it took 40 - 50 minutes. However, when the ASP page calls it, it dies after about a minute. Any ideas on how to allow the SP to run to completion?

Check the configs on ODBC, OLE DB provider for any timeout setting. BTW, your sp that took 40,50 min to run is somewhat suspicious for me! would you please sending its source here?
-Good luck.

I see I can set the commandTimeout property, so I'll try that.
BTW, it builds a DB (a few tables) from one large table (14K+ records)