Book a Demo

Author Topic: Microsoft cursor engine & ADODB.Recordset  (Read 7149 times)

Monsieur

  • EA User
  • **
  • Posts: 142
  • Karma: +0/-0
    • View Profile
Microsoft cursor engine & ADODB.Recordset
« on: March 19, 2015, 02:15:58 am »
Hello,

Big problem submitted by one my user during creation or modification of items.
[size=16]ANY HELP ON SOURCE (of the problem) IS ACCEPTED.[/size]
Give me something, i need to fix this !

Bellow, screencapture + attempt of traduction.

-----------------------------------------------------------

Microsoft Cursor Engine
The ligne havn't been found to update. Some Value may have change since their last read.

-----------------------------------------------------------

Microsoft Cursor Engine
The ligne havn't been found to update. Some Value may have change since their last read.

-----------------------------------------------------------

ADODB.Recordset
The asked operation is not avalable in that context.


-----------------------------------------------------------

Thanks for helping

« Last Edit: March 19, 2015, 03:10:29 am by damien.reche »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Microsoft cursor engine & ADODB.Recordset
« Reply #1 on: March 19, 2015, 07:55:44 am »
I had that with a MySQL server where the ODBC drive had wrong settings.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller

Monsieur

  • EA User
  • **
  • Posts: 142
  • Karma: +0/-0
    • View Profile
Re: Microsoft cursor engine & ADODB.Recordset
« Reply #3 on: March 19, 2015, 11:02:23 pm »
Thanks both of you, my parameters seems fine, and the driver version also.
 [smiley=dankk2.gif] [smiley=dankk2.gif]
I will look into that since it seems to be the best lead (maybe reinstall and try to test a bit)

I keep you all updated! [smiley=thumbsup.gif]

Monsieur

  • EA User
  • **
  • Posts: 142
  • Karma: +0/-0
    • View Profile
Re: Microsoft cursor engine & ADODB.Recordset
« Reply #4 on: April 01, 2015, 01:57:36 am »
Update:       
IT WAS THE ODBC PARAMATERS
some smart ass change them without checking
+ those 2 parameters have a huge impact!
Quote
Select the following checkboxes (where provided):
  • Return matched rows instead of affected rows (Connection or Cursors/Results tab)
  • Allow big result sets (Connection tab)

Thanks community
M.  :D