Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: K N on March 13, 2013, 01:22:06 am

Title: MySQL Server Connection
Post by: K N on March 13, 2013, 01:22:06 am

Hi

Once I open the EA MySQL repository, say for eg it is idle for about 15 mins and then when I start working on it ...EA gives me following message:

"Microsoft OLE DB Provider for ODBC Drivers [-2147467259]

[MySQL][ODBC 5.1 Driver][mysql-5.0.77]Lost connection to MySQL server during query"

Is it the issue from DB side or there is any provision in EA which needs to be set for this?

Thanks
KN

Title: Re: MySQL Server Connection
Post by: qwerty on March 13, 2013, 09:42:27 am

I can't recall the exact scenario but there were some flags you needed to turn on in the MySQL ODBC driver.

q.

Title: Re: MySQL Server Connection
Post by: Geert Bellekens on March 13, 2013, 06:08:15 pm

see here: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1329383486/0#0

Geert

Title: Re: MySQL Server Connection
Post by: K N on March 14, 2013, 12:56:36 am

Hi

I have already selected these options while creating DSN:

-  Return matched rows instead of affected rows (Connection or Cursors/Results tab)

 - Allow big result sets (Connection tab)

Thanks
KN

Title: Re: MySQL Server Connection
Post by: Stefan Bolleininger on March 14, 2013, 01:36:39 am

Hi,


The issue is not the EA or the EA-database, it is the ODBC-driver or the SQL-server.

Two possibilities:
1)check for your user (the user you use for login to the database) in the sqlserver the timeouts and change them.
2) try the automatic reconnect in the ODBC driver.

Regards

Stefan

Title: Re: MySQL Server Connection
Post by: K N on March 14, 2013, 01:38:29 am

@Stefan - ok..let me try these options

Title: Re: MySQL Server Connection
Post by: K N on March 14, 2013, 02:47:31 am

@Stefan: I tried both the options...still the same error

-KN

Title: Re: MySQL Server Connection
Post by: qwerty on March 14, 2013, 08:35:28 pm

Have you checked the MySQL server logs? Maybe also it's a network issue? I'm just guessing here as I'm not a DBA, just a user with a bit experience.

q.

Title: Re: MySQL Server Connection
Post by: K N on March 15, 2013, 12:43:06 am

Thanks qwerty!! ..I have asked one of our DBAs to look into that..

Title: Re: MySQL Server Connection
Post by: K N on March 15, 2013, 02:55:35 am

Tried all the options suggested to me...

Still I am having the same error

Title: Re: MySQL Server Connection
Post by: qwerty on March 15, 2013, 07:12:06 am

Have you tried contacting Sparx support. They have a couple of smart guys there which are in the matters. If any they should be the ones that might have heard of similar issues.

q.

Title: Re: MySQL Server Connection
Post by: K N on March 15, 2013, 07:13:25 am

Thts what I was thinking to do now...thanks!!

Title: Re: MySQL Server Connection
Post by: K N on March 20, 2013, 12:10:13 am

I contacted SparxSystem support...

They told me to increase the max_allowed_packet variable on the server...
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

still have to try on this..

Thanks
KN

Title: Re: MySQL Server Connection
Post by: MichaelJ on February 08, 2019, 01:58:44 am

Hi, did you solve the problem?
I have behavior with an Oracle DB via a Procloud server express.

Regards

Title: Re: MySQL Server Connection
Post by: qwerty on February 08, 2019, 07:25:01 am

The OP is dealing with MySQL. Oracle looks like a DB you don't want to use with EA (except you like the pain). Oracle is designed for large queries while EA sends lots of tiny ones. SQLServer (MySQL, Postgresql, etc.) are much nicer players with EA.

q.