NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: agustinh2000 on May 21, 2014, 03:51:14 AM

Title: database disconnect
Post by: agustinh2000 on May 21, 2014, 03:51:14 AM

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]

Title: Re: FM3:Unable to open file
Post by: Bruce on May 21, 2014, 08:15:22 AM

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

Title: Re: FM3:Unable to open file
Post by: agustinh2000 on May 21, 2014, 02:04:17 PM

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

Agustín

Title: Re: FM3:Unable to open file
Post by: Bruce on May 21, 2014, 09:36:13 PM

>> 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

Title: Re: FM3:Unable to open file
Post by: agustinh2000 on May 22, 2014, 04:27:48 AM

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

Title: Re: FM3:Unable to open file
Post by: agustinh2000 on May 24, 2014, 04:34:37 AM

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

with version 8 works perfectly

thanks

Agustín