|
Home > Archive > MS SQLCE > August 2005 > Insert, update not working until SQL server restart.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Insert, update not working until SQL server restart.
|
|
|
| I have this problem with SQL server. All of a sudden the insert, updates does
not work on SQL server based application written in ASP. The select commands
are returning fine, its only the inserts and updates. They dont appera to
make any changes in the database. I looked into the ErrorLog files on SQL
server and they look pretty normal. No error or query truncation messages.
I resrated the SQL server and things get to be working again. This happened
a couple of times. It can't be the memory issue, coz there is ample of space
and also the datalog is set to grow as required (not limited).
SQL server is upgraded to SP3. So it is up with the upgrades.
From the application side, either the asp page goes to a page not found
error or returns back to the page as it should, but no updates to database.
Any clues to the problem would be appreciated.
Thanks,
Sam
| |
| Mario Aoun 2005-08-04, 1:25 pm |
| hi sam,
sorry for mentioning the following:
the above subject does not belong to the discussion group we are in.
Anyway, in order to solve your problem, try to open the connection , execute
an operation (insert or update) and then close it. (ex: if you are using
ADO.Net create a new data adapter for the operation)
good luck
mario
"sam" wrote:
> I have this problem with SQL server. All of a sudden the insert, updates does
> not work on SQL server based application written in ASP. The select commands
> are returning fine, its only the inserts and updates. They dont appera to
> make any changes in the database. I looked into the ErrorLog files on SQL
> server and they look pretty normal. No error or query truncation messages.
> I resrated the SQL server and things get to be working again. This happened
> a couple of times. It can't be the memory issue, coz there is ample of space
> and also the datalog is set to grow as required (not limited).
> SQL server is upgraded to SP3. So it is up with the upgrades.
> From the application side, either the asp page goes to a page not found
> error or returns back to the page as it should, but no updates to database.
> Any clues to the problem would be appreciated.
>
> Thanks,
> Sam
| |
|
| Thanks Mario,
I will be trying on what you said. And also,
I was suspicious when i was typing my problem here. But wasn't sure of the
right place. Can you/anyone let me know where I should be posting this issue.
Thanks
Sam
"Mario Aoun" wrote:
[color=darkred]
> hi sam,
>
> sorry for mentioning the following:
> the above subject does not belong to the discussion group we are in.
>
> Anyway, in order to solve your problem, try to open the connection , execute
> an operation (insert or update) and then close it. (ex: if you are using
> ADO.Net create a new data adapter for the operation)
>
> good luck
>
> mario
>
> "sam" wrote:
>
| |
|
|
|
|
|