Karim
|
Posted: 09/27/2003, 5:10 AM |
|
Does anyone know why when you use DataSource.SQL on a grid, then you navigate to edit/update or add a new record, stay there for 20-30 mins, then go back to the grid, the data from the grid disapears? Does it have timeout?
Thanks,
Karim
|
|
|
Karim
|
Posted: 09/28/2003, 8:16 PM |
|
HELP.
Thanks
|
|
|
Karim
|
Posted: 10/07/2003, 11:30 AM |
|
I have 40+ users who are going to shoot me...
Help!
THanks.
Karim
|
|
|
Bill Noble
|
Posted: 10/07/2003, 12:43 PM |
|
I don’t know if this is the same thing, but, MSSQL Server will pop-up a message informing you that it is about to drop the link to the data , and release system resources as there has been no server activity for a while.
Try refreshing the query.
|
|
|
Si Cranmer
|
Posted: 10/07/2003, 3:01 PM |
|
Karim,
you dont say what language or DB. As Bill points out, if you are using Oracle or another DB with transaction control enabled you are missing a commit. The DB is dropping the connection and so rolling back the unfinished transaction.
This is evident if session 1 edits the data and then you try to view it from another. The 2nd session will not see the edited data UNTIL the commit is executed.
HTH
Si.
|
|
|
|