Have you tried to run profiler to see exactally what is being sent. I don't see the problem if you have the connection set to manual transactions.

BOb


>I have an app in development where I want to allow the user to change their password on SQLServer 2000 using the sp_password built-in stored procedure. I've tried SQLSetProp(x, "Transactions", 2). I've tried ADO and it worked, but I would like to avoid using ADO for just this one tiny thing.
>
>Here's the line:
>SQLExec(x,"exec sp_password 'oldpass','newpass'")
>
>The error I get says that sp_password cannot be executed within a transaction. Is VFP7 setting up a transaction on SQL and if so how do I stop it from doing so?
>
>Any help would be appreciated.
>
>Thanks
>
>Richard