Urgent!! Help!! Data cannot be written to Database!!

Dear all,
I have a very strange problem. Hope to get some light from you.
I have an application writing data to a MS SQL database. The data
seems to be committed to the database as I can retrieve the data from
my application after entering it.
However, after I exit from my application and re-login to it, the data
that I have just written was gone!!!!
I use an SQL statement to query the database directly and the data is
NOT there too.
Strange!!! I could use retrieve the data before i exit out of the
application.
Anyone knows why?

Any help would be much appreciated.
Thanks.

Steven Toh
Singapore.

hi,
to add on, i am using a Win XP with SQL Server 2000.
I am connecting to the database via ODBC.

On Aug 21, 11:41 am, stevento...@gmail.com wrote:
> Dear all,
>    I have a very strange problem. Hope to get some light from you.
> I have an application writing data to a MS SQL database. The data
> seems to be committed to the database as I can retrieve the data from
> my application after entering it.
> However, after I exit from my application and re-login to it, the data
> that I have just written was gone!!!!
> I use an SQL statement to query the database directly and the data is
> NOT there too.
> Strange!!! I could use retrieve the data before i exit out of the
> application.
> Anyone knows why?
>
> Any help would be much appreciated.
> Thanks.
>
> Steven Toh
> Singapore.

On Aug 20, 8:41 pm, stevento...@gmail.com wrote:
> Dear all,
>    I have a very strange problem. Hope to get some light from you.
> I have an application writing data to a MS SQL database. The data
> seems to be committed to the database as I can retrieve the data from
> my application after entering it.
> However, after I exit from my application and re-login to it, the data
> that I have just written was gone!!!!
> I use an SQL statement to query the database directly and the data is
> NOT there too.
> Strange!!! I could use retrieve the data before i exit out of the
> application.
> Anyone knows why?
>
> Any help would be much appreciated.
> Thanks.
>
> Steven Toh
> Singapore.

Try to check the trigger and relation of your Table. I've same
experience with You and it's solved by modify the trigger and check
again your source again.

Thank's