• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

wrong provide problem.

hello experts, i am tyring to execute the following in VB
 ;
;
;
with rs
      .update
      .fields(0).value='abc'
      .fields(10).value =123
end with
;
;
it givs the error message that the provider does not support this mehthod.
i am connecting with Oracle 8 using the connection string (Dsn Less connection)
"driver={microsoft oracle for odbc};uid=scott;pwd=tiger"
please tell me where am i wrong and the soloution.
Waiting..
Thanks.
A Student
0
astudent
Asked:
astudent
3 Solutions
 
SethiCommented:
Set the Cursor type to adoOpenDynamic and it will work. By default VB opens a read only cursor.
0
 
zljkCommented:
A snippet of code where you open the recordset might help. It might be read-only (altough that should produce a different error). R u actually editing something before calling update ? Give us the whole procedure, please.
0
 
astudentAuthor Commented:
thanks Sethi, Please tell me have i typed the correct connection string, because it says that provider does not support this method (rs.update) is there any need to write the "provider = " part of connection string, if yes, what it should be.
Thanks.
Waiting..
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Crazy_king_inCommented:
Hi
I guess. U have called rs.update with out any changes to the record set and after that ur trying to change the values...Is that correct..check out this way

with rs
     .fields(0).value='abc'
     .fields(10).value =123
     .update
end with

This may work, give a try...
0
 
MaxPolCommented:
Hi, I don't know if this is stil valid, but microsoft oracle for ODBC always had issues in updating.

Here is a trick anyway that might work.

If you link to the table with (i.e.) Ms Access and create an index (yes, create a new index on the table you wish to update), then you should be able to make update even from your code.

Another solution is to use other vendors Oracle ODBC drivers.

Bye,

Max
0
 
DanRollinsCommented:
Moderator, my recommended disposition is:

    Split points between: Sethi and Crazy_king_in and EDDYKT

Dan Rollins -- EE database cleanup volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now