Re: DBI or Network module??

2001-11-21 Thread Simon Oliver
Steve, I converted you VB to Perl and it works... -- Simon Oliver use strict; use warnings; use Win32::OLE; my $oSQLApp = Win32::OLE-new('SQLDMO.Application'); my $oNames = $oSQLApp-ListAvailableSQLServers(); foreach my $i (1 .. $oNames-Count) { print $oNames-Item($i), \n; }

DBI or Network module??

2001-11-19 Thread steve silvers
This question pertains to MS SQL Server. When I set up a DSN to a database using the SQL Server driver I get to the point where I choose the server on the network. Their may be 10 different server with MS SQL running and I can choose one. Can I do this with Perl? In other words see all the