OdbcDataReader with ODBC Text Driver

[Steve Smith]

I am coding a C# .Net2003 program and am reading a CSV file using the
Microsoft Text Driver.

I am able to access the columns of data using oRdr.GetValue(nn).ToString()
however I cannot figure out how to access the Column Names. It appears that
the driver strips these off when it accesses the file, as the first line is
not returned in my While (oRdr.Read()) loop.

The code is destined to become a generic class that can be used for various
input files, so I want to be able to enumerate the column names.

I have tried oRdr.GetSchemaTable, but this did not work either.

Any help would be appreciated!

Thanks

Steve Smith
St***********@shaw.ca