>>>>>>
>>>>>>PMFJI, Do I understand correctly that the SQL 2000 ODBC will work with SQL 2008 except for the new data types, like Date type, correct? I have to make my app support varchar(MAX) type and therefore have to stay with SQL 2000 ODBC. Therefore, I need to make sure not to use DATE type in the SQL 2008. Just wanted to clarify.
>>>>>
>>>>>Yes it's correct
>>>>
>>>>Thank you.
>>>
>>>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.
>
>
>Dimitry this works in many places with 2005 sql in my environment and has for years and works for Naomi as well. I am not so sure you have to follow the this path. Hold on I suspect this will all flesh out with SQL 2005 as the db server and varchar()
Thank you. I will double check how I was using ADO.
"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