Solved

wrong provide problem.

Posted on 2003-11-11
9
233 Views
Last Modified: 2010-05-01
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
Comment
Question by:astudent
9 Comments
 
LVL 18

Accepted Solution

by:
Sethi earned 25 total points
ID: 9720953
Set the Cursor type to adoOpenDynamic and it will work. By default VB opens a read only cursor.
0
 

Expert Comment

by:zljk
ID: 9720958
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
 

Author Comment

by:astudent
ID: 9721068
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Assisted Solution

by:Crazy_king_in
Crazy_king_in earned 25 total points
ID: 9721634
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
 
LVL 2

Expert Comment

by:MaxPol
ID: 9721705
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
 
LVL 26

Assisted Solution

by:EDDYKT
EDDYKT earned 25 total points
ID: 9721928
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 10537161
Moderator, my recommended disposition is:

    Split points between: Sethi and Crazy_king_in and EDDYKT

Dan Rollins -- EE database cleanup volunteer
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
passing parameter in sql procedure 9 65
VBA filters 2 66
vb6 connector to SQL Server 2 37
VB6 common control 6 sp6 object library not registerd 3 23
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question