The ADT Server or Service won't start by clicking the "Server" icon in the Advantage Data Transformer programs list or by selecting Start Advantage Date Transformer Server Service in the Windows Services panel.
These situations can be corrected by directly editing ADT tables through your Database Server Client tools such as Query Analyzer or SQL Plus. Execute the following queries * in the MDB or IDB while the ADT Server is not running.
UPDATE LookOutIdControl SET IdLock=0,LockTime=NULL DELETE FROM LookOutControl WHERE ShutdownTime IS NULL
While using the ADT Server Console STOP or SHUTDOWN command is the recommended method to stop the ADT Server, the result of using another method is not harmful to ADT and is easily corrected by these SQL commands. Be sure that the ADT Server (ipsched.exe) is not running when the DELETE query is executed.
Please be sure to take a backup of your database before any such manual modifications.
*Check your own Database Server query language for the syntax dealing with null time data.