>>>>There is a utility in the downloads "Get SP parameters collection" that should produce the necessary parameters collection for calling any sp. Just connect to the master database and the list of sp's gets populated.
>>>
>
>JC,
>
>I've got your 'Parameters' utility. On my machine, it does not work for system stored procedures like sp_pkeys and sp_help. Should it be able to get parameters for those procedures?
>
>This problem is what started this thread in the first place.
>
>I'm on W2K; I have not installed any data services or components on this machine besides what comes with the OS. Remember, .parameters.refresh() does not do anything in my app either. I would think it should.
>
>The weekend is here... :)

Does it work with other stored procedures?

I did test the utility with sp_pkeys and sp_help before I posted my previous reply on a W2K server with 2.6 and SQL7 SP3 installed. Are you connecting to the master database? I don't remember if I check the support for the .Refresh() method in the code, but not all backends support it. What version of SQL Server are you using?

Also, make sure it is not a permissions problem. Open up query analyzer and test it with the same user id as in your code.