Remote testing of ODBC connections - a query

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.
ST1138 [ Do, 22 September 2005 16:47 ] [ ID #978995 ]

Re: Remote testing of ODBC connections - a query

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
George Bouras [ Fr, 23 September 2005 08:28 ] [ ID #980730 ]
Perl » alt.perl » Remote testing of ODBC connections - a query

Vorheriges Thema: Feed a directory listing to a script
Nächstes Thema: Perl portability