>
>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,
Steve Gibson