SQLTeam.com | Weblogs | Forums

sp_OAMethod

Hi All,
How can I extend the time out value for sp_OAMethod. These are CLR procedures. I tried to use EXEC sys.sp_configure N'remote login timeout (s)', N'300000'
RECONFIGURE

This did not help.
Any help is appricated.

thanks
Mahmood

CLR procedures are not executed via the sp_OA*** procedures, those are only for COM/ActiveX calls. They would need a COM wrapper of some kind in the component in order for SQL Server to activate it.

Without your actual code (or a sample of it with the relevant commands) it will be difficult to help you troubleshoot. There is no "timeout" value that sp_OA*** procedures offer on their own, it would have to be a timeout defined in the COM object they are calling.