my $DSN = 'driver={SQL Server};Server=new-borg;database=master;uid=;pwd=;';
my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
my $sql = qq{ select * from sysusers };
my $sth = $dbh->prepare ($sql);
$sth->execute();
while (@row = $sth->fetchrow_array()) {
print $#row,':',join(':',@row),"\n";
}
$sth->finish();
####
5:14:IUSRBEVO:☺♣ ♣§ ₧§J|╝zê∟j7╞? : :2000-09-22 14:08:48.217:2000-09-22 14:08:48.217:0::0::1:1:1:0:1:0:0:0:0
7:2:ARAdmin:♥┼ºoAá╥◄╜╜ á$J§╛:@:2003-02-18 13:08:06.370:2003-02-18 13:08:06.697:0::0::1:1:0:0:0:1:0:0:0
####
5:14:IUSRBEVO:0x0105000000000005150000009E15AE084A7CBC7A881C6A37C63F0000:0x00:2000-09-22 14:08:48.217:2000-09-22 14:08:48.217:0:NULL:0:NULL:1:1:1:0:1:0:0:0:0
7:2:ARAdmin:0x03C5A76F41A0D211BDBD00A0244A15BE:0x40:2003-02-18 13:08:06.370:2003-02-18 13:08:06.697:0:NULL:0:NULL:1:1:0:0:0:1:0:0:0