SQLExec to Remote Citadel db...

[timsorenson]

I am trying to connect to a remote citadel db to verify that the service is still active.

We have been having some problems with the Citadel db shutting down because of very large ALE file. The only thing that I found to monitor this situation is to constantly try to connect to database.

I have two processes run on two different computers. I want one to monitor the other. However, I can not figure out how to get the SQLExec object to work. I have tried all of the documentation and that does nothing.

Could someone please point me in the right direction so that I can have one process monitor the other processes database.

Thanks

[Zork]

There is another discusion that has an example attached. This walks you through creating a process with SQLExec.

The discussion is, "How to use SQLExec without the ODBC error."