Does anyone know of a tool (preferably Command line since it has to be scheduled in w2k3) to test a ODBC connection?
I am looking for a tool to only make a connection (test the connectivity) login through ODBC:username
asswordfile)DSN
and then logout. I saw that microsoft has a DTCtester utility, but this tool is not flexible enough (performs a little too much tests).
Reason behind this question is that on a powerfuse/citrix farm every night the connection to the oracle database gets lost. Solution is to manually test(meaning connect to) the datasource. But i would prefer a command script / batch file to do this.
To connect in a script though sql*plus is apparently not enough for the powerfuse application.
Any ideas are greatly appreciated.
I am looking for a tool to only make a connection (test the connectivity) login through ODBC:username
asswordfile)DSNand then logout. I saw that microsoft has a DTCtester utility, but this tool is not flexible enough (performs a little too much tests).
Reason behind this question is that on a powerfuse/citrix farm every night the connection to the oracle database gets lost. Solution is to manually test(meaning connect to) the datasource. But i would prefer a command script / batch file to do this.
To connect in a script though sql*plus is apparently not enough for the powerfuse application.
Any ideas are greatly appreciated.
