Windows 7 64 bits and Mysql repository

[paulistano49]

Since I've changed mys version of windows. I can't connect on a mysql repository. I've this message provider [-2147418113]

I've try to install a 32-bit odbc driver, and it returns the same message.

In fact, even your database is Offline, you receive the same popup.

So, It's a problem of EA.exe which has a  problem with Direct X and which  and is not compatible with  7 and 64 bits OS.

It's a big problem, because we are going to change our computer at the end of windows support for XP.

We need a real 64-bits version of EA  

[hd]

We run 32-bit MySQL ODBC driver on Windows 7 64-bit, connecting to a MySQL repository, all the time with no problems.

Make sure the driver is set up as per...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/projects_and_teams/setupmysqlodbcdriver.html

Also read the Notes at the bottom of that page.

[kleeh]

We run 32-bit MySQL ODBC driver on Windows 7 64-bit, connecting to a MySQL repository, all the time with no problems.

Make sure the driver is set up as per...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/projects_and_teams/setupmysqlodbcdriver.html

Also read the Notes at the bottom of that page.

I have the same error msg as paulistano49  and yes, I've read the page. I tried both 32-bit and 64-bit versions. I can get the 64-bit version to show up as an option in my odbc panel, so I set that one up per your instructions, taking note of the odbcad32.exe file and its location. The connection test results were successful -- in the ODBC panel. But when I get to your software and use that connector, I get the error that paulistano49 has. I cannot get the 32-bit version to even show up in my ODBC Admin panel as an option to Add, so any help on how to do that will be appreciated.
BTW, I'm evaluating this as a trial so if I can't get this connection working, I really won't be able to justify a purchase to management. Why am I using ODBC anyway? Seems like an old way to do this. My Datanamic tool simply asks me for a hostname or IP address and it takes care of it....

[Eve]

Kleer, you will not get EA to connect to the 64 bit version of the driver.

Run the ODBC datasource administrator from C:\Windows\SysWOW64\odbcad32.exe.

Alternatively, select Tools | ODBC Data Sources in EA.

[kleeh]

I've uninstalled the 64-bit version. Made sure 32-bit is installed. Went to SysWOW dir and configured connections on all 3 tabs, just to be sure I had options -- and I named them differently so I could tell. Neither the User DSN nor the System DSN get past the stage where I can transfer schema to a new model (DBMS to .eap). The File DSN I set up does not show up so I use your "Build Connection String" in your Data Link Properties popup. This is the connection string that is built:
DBType=0;Connect=Provider=MSDASQL.1;Password=xxxxxxx;Persist Security Info=True;User ID=root;Extended Properties="Driver=MySQL ODBC 5.1 Driver;SERVER=localhost;UID=root;PWD={xxxxxxxx};DATABASE=insight_card_services_production;PORT=3306;FOUND_ROWS=1;BIG_PACKETS=1";Initial
Catalog=insight_card_services_production;
 
So then I get the Transfer page and I click Transfer. It then complains that I don't have some "usys_system", a "t_connect", and various other entities unheard of in MySQl. (the message is "Microsoft OLE DB Provider for ODBC Drivers[-2147217865] ). Then it tells me "Source version must be at least 3.50". Man, I'm using Mysql 5.1.58 ! What is up with all this??
I really like the potential I see in this product but unless I can reverse engineer my schema, it's not gonna happen.

[kleeh]

By the way, the driver version is 5.1.10.

[Eve]

Sounds like you haven't run the setup script as described in http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/projects_and_teams/upsizingtomysql.html