NetTalk Central

Author Topic: database disconnect  (Read 2482 times)

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
database disconnect
« 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]
« Last Edit: May 29, 2014, 03:40:54 AM by agustinh2000 »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11158
    • View Profile
Re: FM3:Unable to open file
« Reply #1 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

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: FM3:Unable to open file
« Reply #2 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
« Last Edit: May 21, 2014, 02:09:19 PM by agustinh2000 »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11158
    • View Profile
Re: FM3:Unable to open file
« Reply #3 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

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: FM3:Unable to open file
« Reply #4 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

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: FM3:Unable to open file
« Reply #5 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