>>>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 looked at my notes back when I started to use SQL Server with ODBC and/or with ADO. I found that with ADO the type VARCHAR(MAX) was truncated to 255 characters. That is, VARCHAR(MAX) was being mapped to C(255). Have you experienced this?
"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