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