>>>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.
I will go back to my notes. Because I swear I tried ADO but had to switch to the ODBC because something didn't work. I will double check.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham