General information
Category:
COM/DCOM and OLE Automation
>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,
What is the error message if any? I can run these without a problem. Make sure it's not a permissions problem, shouldn't be because most of these are available on the public role for the master database.
Although I haven't tested with command objects, usually I do it through the connection's execute or by using the sp name as if it was a method of the connection object.
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.HTH
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only