Trying to connect to a DBMS under Wine (MySQL ODBC

[jsbueno]

Hi there,

Some desktops in our enviromment use GNU/Linux. I am trying to get EA emulated under Wine to open projects stored in DBMS - I gave uop trying oracle because its client software is way overkill to try to get running under wine.

Nonethelss, i found no references on this forum, or in the docs, or on the Web about how to set up a working DBMS connection for EA under wine.

I am currently trying to use MySQL using ODBC (I did install native windows MDAC ODBC thigns, I amnot not trying the wine/unixODBC bridge). EA even connects to the DB but when it trioes to oopen a project I  get this error:
"ADODB.Fields item cannot be found in the collection corresponding to the requested name or ordinal"

I suspect this might be  due to some subtle data transformation (like e.g. line ending chars) that takes place when one does switch from reading the DB on Windows to Linux. I also hope this could be fixed by some paramter on the ODBC connection string.  

Did anyone got this working (even with a very different setup)? Else, any ideas?

[Eve]

It sounds like the kind of error you get when you don't set the advanced options as documented at http://www.sparxsystems.com/uml_tool_guide/uml_model_management/setupmysqlodbcdriver.html.

[jsbueno]

I had set the options as listed in there,
except by the fact that option (1)  "Don't Optimize Column Width" is marked as removed since version 3.51.18. -  I am trying to use version 5.01.0004 .

[hd]

Stay with version 3.51 of MyODBC - version 5 has problems.

[jsbueno]

I tried to downgrade to myodbc connector 3.51.14  (the newest 3.51 connector did not look safe, as the option needed for EA was removed on  version 3.51.18 - some _years_ ago ).

Now everything looks fine, but when I finally try to read a project from the datbase I get an alert box which simply states "Provider:[-2147418113]"

Any other ideas? I'd even like to simply hear of anyone who ever got a succesfull DBMS connection under a Wine emulated EA. - I've seen no references of it on this forum or on the web.

Sparxians: is there a way for me to at least get an error description besides the error number above?

[Takeshi K]

Just for your information,

EA help says that MySQL ODBC 3.51.14 has problems so do not use the version.

See the 'MySQL ODBC Driver' page of the EA help file.

[jsbueno]

Oh..thanks --
I installed 3.51.14  because I remembered havign read something about it on the docs. Too bad it was exactly that it would not work.

Anyway, I did switch my version to 3.51.17 (it should be the last one usable since one of the advanced options needed by EA is gone from 3.51.18 and on) - and I get just the same error.  

Merry Christmas to everyone, btw!

[jsbueno]

Still no progress on this issue. I 've tried both 3.51.17 and 3.51.12 (listed in docs examples). None of them even got me as far as i got with the 5.1 series - I always getthe numeric error message instead of the mroe elaborate error I reported on the oppening of this topic.

I am still open to suggestions or ideas.