Function return OleDbDataReader variable

[lsy]

If i have a function which would like to return a OleDbDataReader variable... is it possible??
I discover when my OleDbConnection is close thus the OleDbDataReader variable also contains nothing.
Attached is my function. Pls help to identify what i have did wrong....

public static OleDbDataReader DB_Query(string sSQL)
{
DOMConfigurator.Configure();
OleDbConnection DBConn = null;
OleDbCommand DBCmd = null;
OleDbDataReader DBReader = null;

using (DBConn = new OleDbConnection(DBCONNECTION))
{
try
{
DBConn.Open();
DBCmd = new OleDbCommand(sSQL, DBConn);
DBReader = DBCmd.ExecuteReader();
DBConn.Close();

}
catch (Exception e)
{
log.Error(e.Message, e);
}
finally
{
DBConn.Close();
DBConn = null;
DBCmd = null;
}
}
return DBReader;
}

[zdavis]

have you tried loading a datatable with the reader. If there are no rows I would think your sql statement is messed up.

[lsy]

have you tried loading a datatable with the reader. If there are no rows I would think your sql statement is messed up.
when inside the function the OleDbDataReader is still holding data... but after connection is close... it become nothing inside... so when i return that is an error in the function which call it.