WebServer SQL Login Issue

[jtailleur]

Hi All,

Not sure quite how to tackle this one.  I have a small webserver I am testing, and have it all working great.  I have a separate login procedure that reads login information from an SQL table.  The webserver happily connects and opens the table; gets the security information, etc.

The issue, is that nightly, this server gets reset (not under my control).  The webserver, for some reason, leaves the connection up once someone logs in, and once that connection is killed, I can no longer log in.  I have to restart the webserver.  Any thoughts on how to handle this disconnect?


Joe.

[jtailleur]

Ok; well, apparently the secret is to use a PROP:Disconnect before Opening the file.  That way it ensures Clarion "Connects" again.

It seems to work very reliably now. 

[Bruce]

good tip - thanks Joe.

[kevin plummer]

Hi Joe,

as a side note, also have a look at the tips for SQL for MARS and Busyhandling if you haven't set that up yet. If it is a highly threaded app you may also need to use SQLTimeout to stop deadly embraces on your SQL server.

Cheers,

Kevin

[astahl]

Hi Joe,

Thanks for the tip.  I have been struggling since November with this issue. Every morning I had to restart my NT Server before clients would get online!

Thanks again,

Ashley