>Hi All,
>
>Could someone please help me with some code examples on setting up a ADO connection to SQL Server,I'm currently using ODBC,but would like to see the difference with ADO.
>
>Regards
>
>Colin Smith

In addition to Sergey's advice, you might check out download #9840 . Much of it was based on the info presented in JP's paper.