>>
>>Does it work with other stored procedures?
>>
>
>Yes, it works with stored procedures in the database I am connected to. I am not explicitely connecting to the master database, so I guess that is the problem. I am able to run sp_pkeys (from inside VFP on client) without connecting to master database, but I have to .append the parameters (which I don't have to do with the stored procedures in the database I am connected to).
>
>>
>>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?
>>
>
>Using SQL Server 7.
>
>>
>>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.
>
>Will do...thanks,

SQL 7 does support the Refresh method. Do you have to use a command object? If not, use the connection's execute method like so:

oRS = oConn.Execute("sp_pkeys 'mytablename'")

I tested with this and it works as expected.