Oracle ADO query shows deleted records

From: Steve W (BunnyBoy_at_community.nospam)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 18:28:41 +0100

>From an ASP.NET application (or a .Net component called by an ASP.NET
application) I connect to Oracle via ADO and delete a record from a table.

If I look via Oracle's SQL plus the record has gone.

If I then query the table, the row still seems to be there. Is ADO caching
this data somehow ?

Thanks

Steve

Relevant Pages

  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ... You should really only do this at design-time, or with a command you will ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Table open times and rowsize discontinuity
    ... some manner related to ADO or the tool you are using. ... Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text - ... For the array fetching, the only parameter I can find in the ADO ... exceeding the SDU and the MTU. ...
    (comp.databases.oracle.misc)
  • Re: OO4O 2.1 vs MDAC
    ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
    (microsoft.public.data.ado)
  • ADO.NET and ODBC { CALL ..... } Syntax
    ... Coonecting to Oracle 8i DB running on Unix ... ADO is used as connecting mechanism ... OleDB connection with provider as MSDAORA. ... Especially the using ODBC Call syntax to fetch the data either via Stored ...
    (microsoft.public.dotnet.framework.adonet)