DataReader

I have a question regarding the ADO.NET DataReader.

Basically, I'm instantiating a command object (with SQL statement and open connection)...then doing the following:


dim reader as new oledb.oledbdatareader()
reader = command.executeReader()

For some reason, I'm getting an "unspecified error" from VB.

Any ideas??

Thanks!!

The datareader shouldn't have a public constructor so this line should be incorrect:
dim reader as new oledb.oledbdatareader()

Try this:
dim reader as oledb.oledbdatareader = command.executeReader()

Also I am assuming that the command object is of the oledb type as well.