Software

Ask something
Discussion Locked

Problem in MS SQL 7.0 Please help

0 helpful
3 replies

by imranmcse

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a SQL server 7 at backend and using a application which is integrated with SQL.
I saved data through application but data is not saved at the backend SQL server's tables,however there in no any error message or event viewer entry for this one.
Please help me.

3 replies

by glen_mcleod

The question is pretty vague, but no error messages sounds like there's an uncommited transaction happening here. There's an option in SQL Server that specifies whether transactions are auto-commit or not. If not, a commit instruction must be sentafter each insert, update or delete. If the option is on, check your application for begin transaction statements but no commit transaction statements.

Glen

This discussion is closed to new replies.