Ever had one of those days... I set Transactions to 1 (automatic) and voila.

Richard



>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