DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

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
    P.S - Please note I had already posted this in database general section then
    realised this would be a better forum so please excuse the double posting

  2. #2
    Paul Clement Guest

    Re: OLE DB PROVIDER FOR ORACLE

    On 21 Feb 2001 15:22:01 -0800, "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
    P.S - Please note I had already posted this in database general section then
    realised this would be a better forum so please excuse the double posting

    Since I can't see how you created your Recordset (what arguments you used) this is rather difficult
    to troubleshoot.

    However, if you are certain that you are specifying the correct arguments in creating an updateable
    Recordset, then make certain that your Oracle Administrator has provided your user ID with update
    rights to the table.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Joergen Hoeyer Guest

    Re: OLE DB PROVIDER FOR ORACLE


    Paul Clement <UseAdddressAtEndofMessage@swspectrum.com> wrote:
    >On 21 Feb 2001 15:22:01 -0800, "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
    > P.S - Please note I had already posted this in database general section

    then
    > realised this would be a better forum so please excuse the double posting
    >
    >Since I can't see how you created your Recordset (what arguments you used)

    this is rather
    >difficult
    >to troubleshoot.
    >
    >However, if you are certain that you are specifying the correct arguments

    in creating
    >an updateable
    >Recordset, then make certain that your Oracle Administrator has provided

    your user ID
    >with update
    >rights to the table.
    >
    >
    >Paul ~~~ pclement@ameritech.net
    >Microsoft MVP (Visual Basic)





  4. #4
    Joergen Hoeyer Guest

    Re: OLE DB PROVIDER FOR ORACLE


    Things like that wont work unless you have Primary key on at least one column...........Try
    that

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