webservice doesn't get to processed code in NetWebpage after database down

[joep]

Hi all,

I have a webservice which consumes received xml's.
Everything is working fine when connected to the database.
But when the connection is lost, I can't get the service to work after the database is up again.
The server window still receives the web:LastPost but it doesn't get to the processed code in the netWebPage.
What is the proper way to deal with a database that went down and up?

Regards Joep

[Bruce]

Hi Joep,

This falls more into the SQL camp than the NetTalk camp - and I'm definitely not the SQL expert - but as I understand it;
Once the connection to the database is lost you should do a
Customers{prop:disconnect}
so that the program "knows" it is disconnected. Then it will automatically reconnect on next attempt.

cheers
Bruce