NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Matthew on June 21, 2013, 04:18:42 AM

Title: ReConnect to MSSQL DataBase
Post by: Matthew on June 21, 2013, 04:18:42 AM

Hello.

I am using FM3 v. 5.09

I have some problem with connection to SQL DataBase.

1. I have single EXE program which checks in timer EVENT if some file exists in some folder on local disk and if exists then read this file and put data from this file to some database.
2. This program is connecting to DataBase on startup using FM3 SQL_Connect.
3. This program is on different physical machine than SQL DataBase.

1. How can I connect again to my DataBase without restart EXE program. when suddenly SQL Server stop working for a while and then start again (for example there is reboot system)?
2. How can I check if my connection to the SQL DataBase is still active (in timer EVENT)?

-------------------------------------------------------------------------------------------------------------------
When I try to run again SQL_Connet procedure I have STOP MESSAGE when SQL Server is still unattainable and then program is terminated - see attachmenet.

Regards,
Matthew

[attachment deleted by admin]

Title: Re: ReConnect to MSSQL DataBase
Post by: kevin plummer on June 22, 2013, 01:48:21 AM

your glo:dbowner should be threaded and populate this with the server,db,user,password in the processlink embed in the webhandler.

Title: Re: ReConnect to MSSQL DataBase
Post by: Matthew on June 23, 2013, 11:45:49 PM

Thank You Kevin for your answer.

I forgot to write that I am not using NetWebServer class, but NetServer and I have all the time one thread.

I run my EXE program which connect at startup to dababase and in timer event I do something operations. So how can I check if my connection to the SQL DataBase is still active and if not trying to connect again.

If I use again procedure SQL_Connect where I set FM3GLO:Connected = FALSE to trying connect againt it throw mi STOP MESSAGE and  program is terminated (attachement).

Anyone know how to checking connection to database and reconnect if necessary without close and run again application?

Regards,
Matthew

Title: Re: ReConnect to MSSQL DataBase
Post by: Bruce on June 23, 2013, 11:57:01 PM

Hi Matthew,

This falls into the category of a "more general" Clarion question- and hopefully someone here with SQL knowledge can respond - but you may have more joy posting in the normal Clarion newsgroups. Phrase it as a "general" Clarion question, not mentioning the NetTalk bit (which is irrelevant to your problem) and you might get something useful.

I am definitely _not_ a SQL expert, but as I understand it, this is a problem for Clarion programs in general. But it may be solved in some Clarion version, or there may be techniques to use, or whatever.

cheers
Bruce