Topic: Questions to Mysql and ODBC Driver

[Stefan Sabolowitsch]

Hi NG / Developers

I want to connect myself via Mysql ODBC Driver (Win2K) with the Mysql database of E-Smith.I get however the always following error message of the Odbc Driver.

"Lost connection to Mysql server during query"

Also to another data base server goes to connections without problems.
Someone can explain step for step to me, how one connects a ODBC Connection to the Mysql database of e-Smith.

Thanks for each assistance.

greetz

Stefan

[tanyu]

You might try to add or edit this registry key :

Hkey_Local_Machine\System\CurrentControlSet\Services\VxD\MSTCP\KeepAliveTime = (32-bit number of your choice)
It specifies the connection idle time in milliseconds before TCP will begin sending keepalives, if keepalives are enabled on a connection. The default is 2 hours (7200000).

It saved me plenty of times when getting ODBC loss of resources...

Hope this helps.

--
Phil.

Stefan Sabolowitsch wrote:
>
> Hi NG / Developers
>
> I want to connect myself via Mysql ODBC Driver (Win2K) with
> the Mysql database of E-Smith.I get however the always
> following error message of the Odbc Driver.
>
> "Lost connection to Mysql server during query"
>
> Also to another data base server goes to connections without
> problems.
> Someone can explain step for step to me, how one connects a
> ODBC Connection to the Mysql database of e-Smith.
>
> Thanks for each assistance.
>
> greetz
>
> Stefan

[Stefan Sabolowitsch]

Hi tanyu
Thanks for your fast answer.
But these changes do not have an effect.

Possibly someone an idea?

greetz

Stefan

[tanyu]

Did you put a low value, like 120000 for instance ?

[Stefan Sabolowitsch]

functioned also not: - ( .
That must be general problem with the e-Smith server.
The error message comes "directly" to the call attempt.
No matter, which to time I enter.
Connections to SuSe, RedHat or other server with Mysql goes directly and without problems.

What is with e-Smith different?

Stefan

[Boris]

External connections to MySQL on SME 5.6 resolved by glibc update.Thanks to Charlie Brady for resolution pointer.
Check this link http://forums.contribs.org/index.php?topic=16344.msg63207#msg63207
for more info.