Information générale
Catégorie:
COM/DCOM et 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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement