General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only