Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I have created a stored procedure in SQL Server. I can execute this SP from Sql Server Management Studio fine. But when I try to execute this SP from VFP, I get the following error:
>
>***********
>"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'mytest', database 'MyDatabase', owner 'dbo'."
>***********
>
>I can query any table in SQL Server with SQL Pass Through. And I can call the System Stored Procedures but I can't call a Stored Procedure that I created.
>
>What do I have to do to call a SP that I created from VFP?
>
>Thanks,
>
>Jerry
Hi Jerry,
this is the way I do it:
lnRet = gocnn.execute('< nameofstoredprocedure >', 4)
and it works for me.
HTH
Beth
Précédent
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