DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: OLE DB PROVIDER FOR ORACLE

  1. #1
    Naveen K Thalanki Guest

    OLE DB PROVIDER FOR ORACLE


    The OLE DB Provider for Oracle that i use is 'MSDAORA.1'.

    Using this provider I tried to create an updatable recordset but when I attempt
    to update the recordset, I get back an error message stating that the object
    or provider does not support the requested operation.

    I made sure that I created a recordset that based on the server, with its
    locktype property set to optmisitic locking.

    Is this a problem with the provider or a problem with my code.
    Is there a way I could query the OLE DB Provider to find out whether it supports
    updatable recordsets.

    Or does anyone of you out there work on this version of the OLE DB provider
    for updating recordsets.

    Thanks in advance for any help you can give
    Regds
    Naveen

  2. #2
    challis Guest

    Re: OLE DB PROVIDER FOR ORACLE


    Hi

    That provider only supports static, and forward only recordsets

    challis

    "Naveen K Thalanki" <thalanki_naveen@rocketmail.com> wrote:
    >
    >The OLE DB Provider for Oracle that i use is 'MSDAORA.1'.
    >
    >Using this provider I tried to create an updatable recordset but when I

    attempt
    >to update the recordset, I get back an error message stating that the object
    >or provider does not support the requested operation.
    >
    >I made sure that I created a recordset that based on the server, with its
    >locktype property set to optmisitic locking.
    >
    >Is this a problem with the provider or a problem with my code.
    >Is there a way I could query the OLE DB Provider to find out whether it

    supports
    >updatable recordsets.
    >
    >Or does anyone of you out there work on this version of the OLE DB provider
    >for updating recordsets.
    >
    >Thanks in advance for any help you can give
    >Regds
    >Naveen



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center