database disconnect

[agustinh2000]

Bruce, when I upgraded from version 7 to 8 NT have to restart the webserver every day as I receive this error (image).

It happens after several hours. Especially when there is no activity.

I tried it on two servers thinking it may be the odbc but the error is the same

thanks

Agustín

[attachment deleted by admin]

[Bruce]

I don't think it's a NT7/NT8 issue.
Did you update anything else at the same time? Like what version of Clarion were you/ are you using?

Cheers
Bruce

[agustinh2000]

Clarion upgrade from version 8 to 9
fm 3 5.18 but also with version 5.17
string theory latest version

Agustín

[Bruce]

>> Especially when there is no activity.

Are you being disconnected from the SQL server after long periods of inactivity? Maybe try opening a file in the WebServer procedure itself, and leaving it open. (Or maybe, there should be no file opened there if you're opening one already.)

This looks less like a NetTalk problem and more like a C9 problem. I know in C9.1 there were a number of fixes regarding SQL - so maybe that's a good option for you too.

Cheers
Bruce

[agustinh2000]

I'm actually connected through odbc to mysql.
I'll do more tests.
Example. compiling with Clarion 8 FM 5.18  NT 8.12...

and I comment..

Agustín

[agustinh2000]

Bruce. clarion 9 has the problem, I will try 9.1 clarion

with version 8 works perfectly

thanks

Agustín