Author Topic: MySQL Server Connection (Read 8743 times)

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

qwerty · « **Reply #1 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.

Geert Bellekens · « **Reply #2 on:** March 13, 2013, 06:08:15 pm »

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

Geert

K N · « **Reply #3 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

Stefan Bolleininger · « **Reply #4 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

K N · « **Reply #5 on:** March 14, 2013, 01:38:29 am »

@Stefan - ok..let me try these options

K N · « **Reply #6 on:** March 14, 2013, 02:47:31 am »

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

-KN

qwerty · « **Reply #7 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.

K N · « **Reply #8 on:** March 15, 2013, 12:43:06 am »

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

K N · « **Reply #9 on:** March 15, 2013, 02:55:35 am »

Tried all the options suggested to me...

Still I am having the same error

qwerty · « **Reply #10 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.

K N · « **Reply #11 on:** March 15, 2013, 07:13:25 am »

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

K N · « **Reply #12 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

MichaelJ · « **Reply #13 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

qwerty · « **Reply #14 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.

Sparx Systems Forum

News: