ODBC Data Reader?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Earl - 04 Mar 2004 07:26 GMT

Is the DataReader only for SQLServer or can it be used with ODBC? If so, is
anyone aware of a sample out there?

Reply to this Message

William Ryan eMVP - 04 Mar 2004 07:44 GMT

They inherit from IDataReader so the one for Sql Server is SqlDataReader.
If you are using the 1.1 framework, there's an ODBCDataReader

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr
fsystemdataodbcodbcdatareaderclasstopic.asp

HTH,

Bill

> Is the DataReader only for SQLServer or can it be used with ODBC? If so, is
> anyone aware of a sample out there?

Reply to this Message

Earl - 04 Mar 2004 18:38 GMT

That link was very helpful Bill. Thanks.

> They inherit from IDataReader so the one for Sql Server is SqlDataReader.
> If you are using the 1.1 framework, there's an ODBCDataReader

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlr
fsystemdataodbcodbcdatareaderclasstopic.asp

> HTH,
>
> Bill
> > Is the DataReader only for SQLServer or can it be used with ODBC? If so,
> is
> > anyone aware of a sample out there?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...