Query timeout expired when doing update to password to a field

Hi all,

I am having a problem with this execute code



Apparently, it keeps on generating query timeout when updating the password field and only in SQL database. In access database the code works fine. The database is accessible since other scripts and queries work well apart from this one on the remind password page.

Can anyone with an idea to the solution help? Will really appreciate.

Regards,

Erick

Capture the sql string your code is generating and try running it manually in your sql server query tool.

Dear Doug,

I have queried this which is generated when I did response write in the sql server but yes it is indicating that it is executed but when you use the password which was sent after the generated one it still seems the field was not updated.

Other queries like "select * from [Staff Details]" query works pretty well returning all the values in the table. I have also checked the table and it shows that the encrypted password was indeed updated.

I don't know. As a guess, check your database structure and verify the password field accepts a string datatype.

You might edit out the hash value from your post.

Also make sure the [name] bracket syntax is correct and doesn't need quotes or something. I mostly use mysql these days which needs backticks around column names, not brackets, and if I recall correctly there is a setting in sql server relating to quoted identifiers.

Hi,

Okay thanks will look into that. Regards