RDO or ADO

I am using Crystal Report 10 connected to SQL Server 2000
for report writing. I have the option to choose from ODBC
RDO and OLE DB ADO.
I would like to know which one should I choose ?
What is the difference between them and which one is more
efficient ?
ThanksI suggest you use ADO since it is the successor to RDO.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:68a701c493bb$35cb4d60$a301280a@.phx.gbl...
>I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks|||Peter,
Definitely ADO. Even though ADO is now obsolete (superceded by ADO.NET),
RDO is worse than obsolete. ADO replaced RDO years ago.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Peter wrote:
> I am using Crystal Report 10 connected to SQL Server 2000
> for report writing. I have the option to choose from ODBC
> RDO and OLE DB ADO.
> I would like to know which one should I choose ?
> What is the difference between them and which one is more
> efficient ?
> Thanks