>>>
>>>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