>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
You need to grant permission to the user to EXECUTE the sp. you can do that via SQL Management studio or using the GRANT command.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________