Remote testing of ODBC connections - a query

Remote testing of ODBC connections - a query

am 22.09.2005 16:47:57 von ST1138

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.

Re: Remote testing of ODBC connections - a query

am 23.09.2005 08:28:43 von George Bouras

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