Home > Archive > PERL Programming > September 2005 > Remote testing of ODBC connections - a query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Remote testing of ODBC connections - a query
|
|
| ST1138@gmail.com 2005-09-22, 6:56 pm |
| Hi,
I have been tasked with remotely administrating a number of windows
2000 servers. I have to set up 200 Oracle ODBC DSNs on each machine and
have written a batch file which allows me to do so.
However, I now need some means of remotely determining if these ODBC
connections are valid (i.e. recreating the "test connection" facility
which is available in windows).
I have been considering using Perl to do this but am unsure of the
feasibility of this task. The servers do not have Perl installed so I
would need to remotely query the ODBC connections on each server.
Does anyone have any ideas?
Many Thanks,
ST.
| |
| George Bouras 2005-09-23, 3:57 am |
| Very easy do it, you have at least 3options
1. Make it executable and log to a share folder, schedule the executables
2. Usw module Win32::OLE to give a remote command through wmi
3. use the iss a smal site just to give a command to any host with CGI
module
|
|
|
|
|