Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: jsbueno on December 19, 2008, 11:27:21 pm

Title: Trying to connect to a DBMS under Wine (MySQL ODBC
Post by: jsbueno on December 19, 2008, 11:27:21 pm

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?

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: Eve on December 22, 2008, 08:18:33 am

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.

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: jsbueno on December 22, 2008, 09:34:51 pm

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 .

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: hd on December 23, 2008, 08:17:44 am

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

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: jsbueno on December 24, 2008, 06:26:24 am

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?

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: Takeshi K on December 24, 2008, 02:57:32 pm

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.

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: jsbueno on December 24, 2008, 10:29:12 pm

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!

Title: Re: Trying to connect to a DBMS under Wine (MySQL
Post by: jsbueno on December 31, 2008, 12:11:50 am

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.