Have you used AERROR() to check the error message?

Also, could this be a problem with permissions?

>I cannot get a SQL Server stored proc that returns data rows to execute using SQLEXEC(). I reduced the problem down to the simplest SELECT * FROM ... in a test SP to test it. The test SP runs fine from Query Analyzer, and the SELECT command itself runs from VFP when executed using SQLEXEC(), but the SP will not run from VFP using SQLEXEC(). I know I've done this before and the Help examples are simple. I'm missing something incredibly simple ... or stupid. :-)
>
>Code details below.
>
>Test SP code:

>CREATE PROCEDURE dbo.WBC2_Test AS
>SELECT * FROM usPhone_T

>
>VFP SP Test code:

>h = GetConnection() && gets a connection and I know it works
>ret = SQLEXEC( h, "EXECUTE WBC2_Test" )  && ret returns -1
>?SQLDISCONNECT(h)  && returns 1

>
>VFP SELECT test code:

>h = GetConnection() && gets a connection and I know it works
>ret = SQLEXEC( h, "SELECT * FROM usPhone_T" )  && shows cursor & ret returns 1
>?SQLDISCONNECT(h)  && returns 1

>
>What in the world am I missing here??
>
>Thanks,
>Bill