Hello monks - much wisdom is needed here! I am charged with reading data from several MS databases (Access and SQLServer) using Perl. I'm using Win32::ODBC and thought I was following the documentation carefully, but I get useless data using the DataHash method. It looks like this:

6/8('server_name')

Here is the code:

use Win32::ODBC;

$login = "DSN=ODBCTest";

$sql_text = "SELECT * from tblServer";

$conn = new Win32::ODBC($login) 
  or die "Error Connecting! " . Win32::ODBC::Error();

if (! $conn->Sql($sql_text)) {
  while ($conn->FetchRow()) {
    my $data = $conn->DataHash();
    print "$data('server_name')\n";
  }
}

$conn->Close();
[download]

Supposedly, using DataHash enables you to specify the column name. In this case the column name is 'server_name' but perl treats it like a string with or without quotes. You can use the Data method, but it returns the rows as one big string which is impossible to parse correctly.

Any ideas? Thanks.