>>Another option is to use CA with ADO
>
>I do use CA but I thought that ADO will enable you to use new data type (e.g. DATE) but NOT varchar(MAX). Therefore, since I want the varchar(MAX) my only choice is 2000 ODBC.

ADO will handle all data types correctly as long as correct version of SQL Server Native client is installed on PC.