I've been reading almost all the posts trying to find some helpful info about how to use ADO with SQL, but everyone uses ADO with ACCESS, is there a way to connect to SQL Server using ADO????, how can you send the strings to SQL, right now I'm using RDO to connect with SQL and works fine, except when I have to get a big resultset (over 5,000 records). Everyone is telling me that ADO is faster.
Can you send me an example in how to connect to SQL using ADO, and how to send strings

Thanks for your time