Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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