>I am trying to use VFP9 to access a stored procedure in our SQL Server database. However, I get the below error when I attempt to call this stored procedure.
>

>lc_conn = SQLCONNECT('my connection string')
>=SQLEXEC(lc_conn, 'mystoredproc', 'cust_list')
>

=SQLEXEC(lc_conn, 'EXEC mystoredproc', 'cust_list')

>***AError() reports the following:
>***SQL Server execute permission denied on object 'mystoredproc'
>

>
>
>However, I am able to query this SQL Server database with the following, but not as a stored procedure.
>
>

>***This works.
>lc_conn = SQLCONNECT('my connection string')
>=SQLEXEC(lc_conn, 'Select * From customer', 'cust_list')
>

>
>Do I need to see our DBA about permission?
>
>Thanks,
>
>Jerry