Hi all,
I am using ADO command objects to run stored procedures against SQL Server. However, I haven't been able to use this technique for system provided stored procedures (such as sp_pkeys, sp_help, etc.). It is as if these stored procedures don't even exist.
I can revert to using SQLEXEC(hnSQL, "EXEC sp_pkeys ...",) syntax; and it works from within VFP. I am using the same connect string to connect via ADO and SQLStringConnect().
Is it possible to run these sp' through ADO command object?
Thanks,
Steve Gibson