Support forum

Henk,

Using a proprietry software package that implements a standard ODBC driver – ClearSCADA (www.clearscada.com) I've created the necessary tables and it works if the Diafaan service is started/PHP_script_to_send_SMS_messagesstarted after the Database is running. however the database server may not always be up for a number of reasons and yeah as mentioned it just doesn't seem like it attempts to reconnect. but the strange thing is I can go into the properties of the SQL connector and test the database connection (assuming this creates a new temporary connection), but testing the tables fails with log message (assuming this thinks a connection still exists – and maybe it does, but the database server rejects the request and a new connection is required):
—
DSN=ClearSCADA;LOCATION=MAIN;UID=xxx;PWD=xxx;LOCALTIME=False;

SELECT Id,Phone,Message FROM SMSOutgoing WHERE Id='0'

ERROR [08S01] [Control Microsystems][ClearSCADA database driver]An established connection was aborted by the software in your host machine.
—

Looking at the SQL Connector log i'm also seeing errors at times:
—
EventTime Event
25/3/2011 7:20:06 PM ERROR [HYC00] [Control Microsystems][ClearSCADA database driver]Rollback not supported
—
Not sure if that's the reason why it's not coming back online, but using QTODBC (query tool) I do find that after the server has been restarted, you must manually re-connect.

Although not the prefered method, I was also looking at manually implementing something similar using a scripting connector that would first validate the connection and re-connect on failure. If so, what do you think would be the best way to go about it? And is there someway I can execute a reconnect or disconnect/connect method on the existing SQL Connector object from within the scripting connector code?

---> Quick update: seems every time I stop the database server, the last log recorded IS the 'rollback not supported' error message. Is this a fatal error? ie. SQL connector stops permanently at this point?

Thanks, Nick