Problems with MySQL Repository

[Zidane]

Hi All!

A very similar problem was mentioned in this thread, but unfortunately it wasn't solved there....

http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=suggestions;action=display;num=1140540601;start=0#0

Server
mysql-5.0.24.a-win32

Client
MySQL ODBC 3.51
Tried with EA 6.1.791 and 6.5.796

Migration:
I created the repository and migrated a very small project. During model transfer I get the following error

An error has occured: Microsoft OLE DB Provider for ODBC Drivers [-2147217887]
[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-community-nt]Data too long for column 'PatternXML' at row 1
[]
Field: version

Press OK to continue to next row (this record will be lost), Cancel to abort

By pressing OK the model data transfer completes, but maybe this is the cuase of the actual error....

Error:
Whenever I change something (e.g. on classes) and want to save, I get following errors:

Microsoft Cursor Engine [-2147217864]

ADODB.Recordset [-2146825069]

This is really urgent, cause we'll start a multi user test of EA architect in the next days. If this is successful we go for EA in the whole company. So, help is needed  

Thank you very much,

DD

[hd]

In the MySQL ODBC configuration, make sure you have the options "Don't Optimize Column Width" and "Return Matching Rows" checked. You can find them on the Advanced tab. (These were set as default on earlier MySQL ODBC drivers.)

If you still have a problem, submit a bug report to Sparx, including a copy of the project being transferred.

[Zidane]

Works  

Thank you very very much.

[StefanPears]

Hi all,

I get nearly the same message as above:

"microsoft Cursor Engine [-2147217887] multiple-step operation generated errors.  Check each status value."

This occurs, when I try to apply a large text to a property.notes field, lets say more than 4000 chars. I couldn't find the options Henk mentioned above, because we are using a Oracle 9i database and a "Oracle in OraHome92" ODBC driver.

Thanks for help.
Stefan

Edited: It's not the size. I tried to copy and paste the text from the elements linked dokument to the property.notes field via clipboard and I guess there are invalid (and invisible) characters inside. I do not get the above error when I convert the text into plain text (without formatting) before pasting.