[davidl]

import dbi.Row;
import dbi.odbc.OdbcDatabase;
import std.stdio;
pragma(lib,"odbc32.lib"); //this still doesn't work . i need to build it with odbc32.lib in command line. NOTE: i have odbc32.lib in my dmd\lib path
void main() {

OdbcDatabase db = new OdbcDatabase();
writefln("hello");
db.connect("DRIVER={SQL Server};PWD=userpass;UID=user;SERVER=mydatabase-server;database=mydatabase");
writefln("connect");
Row[] rows = db.queryFetchAll("SELECT field1,field2 FROM temp ");
int i=0;
foreach (Row row; rows)
{ i++;
writefln(row[""]); //this would show the field1, but i can't get field2 anymore , and this behaves abnormally IMHO
}
writefln("after for each");
scope (exit)
{
db.close(); //this always tells me unable to close odbc environment
}
}

[davidl]

due to the document in :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/
htm/odbcsqlcolattribute.asp

i find odbcresult.d line 119 should be :
if (!SQL_SUCCEEDED(SQLColAttribute(stmt, i, SQL_DESC_NAME, columnName, columnName.length, &columnNameLength, null))) {
throw new DBIException("Unable to get the SQL column names. ODBC returned " ~ getLastErrorMessage, getLastErrorCode);
}

SQL_DESC_NAME is going to tell the api to get the column alias, if not , we would possibly get only an empty string

[jpelcis]

Thanks again. This is fixed, too.