Description: I have a application in visual basic 6 I was updating the ODBC driver 3.51 to 5.1, the aplication work perfect with the 3.51 driver the only chance I make was in the DSN, con. Open "DSN=My Sqlfundacio" My Sqlfundaciob is the 3.51 connection make with the ODBC administrator and My Sqlfundacio is the one I make for the 5.1 driver When I try to update a recordset the next error show up error number -2147217864 (80040e38) Row cannot be located for updating. Some values may have been changed since it was last read. Everytime I want to change some properties in some class I get the following error messages: : Microsoft Cursor Engine [-2147217864] Row cannot be located for updating.Some values may have been changed since it was last read. Recordset[-2146825069] Operation is not allowed in this context. Even if this question was posted a long time ago: Now and then this error occurs in my projects, too.
I'm not all that familiar with My SQL, but the query translation OPENQUERY is performing behind the scenes may be causing your issues, and using EXECUTE AS would ensure no syntax tranformation will take place.
Fields("totalconc") = gvs PSCampo(Trim$(txt Concedido. Had same error, however had it with recordsets rather than data control.
Update 'Error show up her End With and the Table structure is CREATE TABLE `proyecto` ( `codproy` varchar(9) NOT NULL, `cont` smallint(5) DEFAULT NULL, `nsubgrupo` tinyint(3) unsigned DEFAULT NULL, `titulo` varchar(255) DEFAULT NULL, `tipo_actividad` varchar(25) DEFAULT NULL, `subtipo_actividad` varchar(35) DEFAULT NULL, `entidad_financ` varchar(12) DEFAULT NULL, `organismo` smallint(5) DEFAULT NULL, `fentrada` datetime DEFAULT NULL, `comite` varchar(10) DEFAULT NULL, `finicio` datetime DEFAULT NULL, `ffin` datetime DEFAULT NULL, `area` varchar(7) DEFAULT NULL, `fenvioetico` datetime DEFAULT NULL, `faprobetico` datetime DEFAULT NULL, `faprobcient` datetime DEFAULT NULL, `fconcesionfirma` datetime DEFAULT NULL, `registro` varchar(60) DEFAULT NULL, `estado` varchar(1) DEFAULT NULL, `totalconc` decimal(19,4) DEFAULT NULL, `bloqueo` varchar(1) DEFAULT NULL, PRIMARY KEY (`codproy`) ) ENGINE=Inno DB DEFAULT CHARSET=latin1; the exception aper with any table but this is and example Hi German and thanks for your report. Now, my test shows that simple case like: Module Module1 Sub Main() Dim con Dim SQL1 Dim rs Proyecto con = New ADODB. Open("DSN=51") SQL1 = "SELECT * FROM bug38147 WHERE Fld1 = 'Primo'" rs Proyecto = New ADODB. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
In your ODBC Data Source Configuration do you have "Return matched rows instead of affected rows" and "Allow big result sets" If you are importing form XMI are you stripping the GUIDs on import, this is always a good idea if you are making a copy of an existing folder in your model as having two elements with the same GUID is not ideal ;-) I have also noticed that you asked this on Apr 14th - sorry it has taken me so long to find your request. Are you accessing your ea repository as a cloud repository please?
If so, you could try to switch to access the repository as an odbc datasource, and this problem might be solved.